Microsoft Access Questions

MCQ bookmark_border

11.

Which of the following is the ascending order of data hierarchy?

A

Bit – Byte – Field – Record – Database – File

B

Bit – Byte – Field – Record – File – Database

C

Byte - Bit – Field – Record – File – Database

D

Bit - Byte – Record – Field – File – Database

Correct Answer: B

Bit – Byte – Field – Record – File – Database

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

12.

To create a table in MS Access

A

Database should be created before creating a table

B

You should allow atleast one Primary key in a table

C

Table can be created using Table Templates

D

All of the above

Correct Answer: D

All of the above

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

13.

Database access levels are specified so as to define who can access what in a database, it is identified through

A

User ID

B

Password

C

Status

D

All of these

Correct Answer: A

User ID

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

14.

The default and maximum size of text field in access

A

50 and 255 characters

B

266 characters and 6400 characters

C

288 characters and 6880 characters

D

299 characters and 6499 characters

Correct Answer: A

50 and 255 characters

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

15.

_____ enables the user to automatically insert numbers in a sequential or random number.

A

Auto Number

B

Look up Wizard

C

Hyperlink

D

Ole object

Correct Answer: A

Auto Number

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

16.

A file containing relatively permanent data is

A

Sequential file

B

Transaction file

C

Master file

D

Random file

Correct Answer: C

Master file

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

17.

The checking operation performed on input data is called the

A

Control of data

B

Validation of data

C

Cross check

D

Verification of data

Correct Answer: B

Validation of data

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

18.

A search value can be exact value or it can be

A

Wild card character

B

Comparison operation

C

Relationship

D

Logical operator

Correct Answer: A

Wild card character

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

19.

Which of the following is not a Form style available in the Form Wizard dialog box?

A

Stone

B

Standard

C

Highlights

D

Blends

Correct Answer: C

Highlights

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

20.

This form displays multiple records, one per row, in the form window

A

Justified

B

Columnar

C

Tabular

D

Datasheet

Correct Answer: D

Datasheet

Check Answer report_problem Report forum Discussion