Microsoft Access Test 1

Result

Microsoft Access Test 1

Score
-
out of -
Rank
-
out of -

TIME Taken - -

SHARING IS CARING

If our Website helped you a little, then kindly spread our voice using Social Networks. Spread our word to your readers, friends, teachers, students & all those close ones who deserve to know what you know now.

Weekly Quiz Competition

Question 1
1 / -0

Which of the following is not a part of a table structure in MS-Access?

A
Field Name

B
Field Type

C
Primary Key

D
Number of Records

Solution

From the given options Field Name, Field Type Primary Key are the part of a table.
Question 2
1 / -0

An integer takes a storage size of

A
2 bytes

B
1 byte

C
4 bytes

D
8 bytes

Solution

An integer takes a storage size of 2 bytes.
Question 3
1 / -0

Which of the following is not a data type?

A
Picture/Graphic

B
Date/Time

C
Text

D
Number

Solution

From the given options Date/Time, Text and Number are the data types.
Question 4
1 / -0

Microsoft Access is an example of

A
Computer

B
DBMS

C
CPU

D
Device

Solution

MS-Access is the DataBase Management System (DBMS) found in the Microsoft Office suite.
Question 5
1 / -0

Which field property helps in setting data validation in a table?

A
Caption

B
Default Value

C
Decimal Places

D
Validation Rule

Solution

Validation Rule property specifies a condition that must be met before the data is accepted into the database.
Question 6
1 / -0

The default data type for a field is

A
Number

B
AutoNumber

C
Currency

D
Text

Solution

The default data type for a field is Text.
Question 7
1 / -0

In a MS-Access database, which component is not present?

A
Formula Bar

B
Tables

C
Queries

D
Forms

Solution

MS-Access contains various components, i.e. Tables, Queries, Forms, Reports, Macros and Modules.
Question 8
1 / -0

Which property is used to add a label to the field to assist the user?

A
Default value

B
Default value

C
Format

D
Indexed

Solution

Caption is used to add a label to the field for assisting to the user.
Question 9
1 / -0

You create a table in MS-Access. You decided to create two fields RollNO and date of birth, what will be the data type for Date of the Birth column?

A
Number

B
Text

C
Yes/No

D
Date/Time

Solution

Date/Time will be the data type because it allows to store date and time format.
Question 10
1 / -0

What is the purpose of the description column in table Design View?

A
To describe the data that should be entered in each field

B
To define the data type applied to each field within the table

C
To enter lookup data, the field should be refer to the table

D
None of the above

Solution

A Design View of table provides three columns as Field Name, Data Type and Description. The description column provides the facility to write description about Field Name.
Question 11
1 / -0

When you define a field for a table, which of the following parameters do Access always consider optional?

A
Field Name

B
Data Type

C
Field Size

D
Description

Solution

Description field of table is optional, as it depends on database designer that he/she wants to describe field or not.
Question 12
1 / -0

What data type should you choose for a zipcode field in a table?

A
Text

B
Number

C
Memo

D
All of these

Solution

Number data type should be chosen for a zipcode field in a table.
Question 13
1 / -0

Single and double are the types of

A
Integer data type

B
Decimal numbers

C
Text data

D
None of these

Solution

Integer data type provides single and double data types.
Question 14
1 / -0

Which data type helps you to handle input that is in boolean format?

A
OLE Object

B
Attachment

C
Yes/No

D
None of these

Solution

Yes/No will allow boolean value.
Question 15
1 / -0

For what, Memo data type is used?

A
To add table

B
To store objects created in other programs

C
For long text entries

D
For short text entries

Solution

As we know, Memo provides character upto 65536 so, it is used for long text entries.

User

Question Analysis

Correct -
Wrong -
Skipped -

My Perfomance

Score
-
out of -
Rank
-
out of -

Re-Attempt Weekly Quiz Competition

Microsoft Access Test 1

Result

Microsoft Access Test 1

Score

-

Rank

-

SHARING IS CARING

Question 1

Field Name

Field Type

Primary Key

Number of Records

Solution

Question 2

2 bytes

1 byte

4 bytes

8 bytes

Solution

Question 3

Picture/Graphic

Date/Time

Text

Number

Solution

Question 4

Computer

DBMS

CPU

Device

Solution

Question 5

Caption

Default Value

Decimal Places

Validation Rule

Solution

Question 6

Number

AutoNumber

Currency

Text

Solution

Question 7

Formula Bar

Tables

Queries

Forms

Solution

Question 8

Default value

Default value

Format

Indexed

Solution

Question 9

Number

Text

Yes/No

Date/Time

Solution

Question 10

To describe the data that should be entered in each field

To define the data type applied to each field within the table

To enter lookup data, the field should be refer to the table

None of the above

Solution

Question 11

Field Name

Data Type

Field Size

Description

Solution

Question 12

Text

Number

Memo

All of these

Solution