MS Access MCQs | Microsoft Access Multiple Choice Questions(MCQs) and Answers | MS Office Quiz

Questions

1 This data type allows alphanumeric characters and special symbols.

A memo

B text

C auto number

D currency

Answer: Option [B]

2 Query design window has two parts. The upper part shows

A Name of fields, field type and size

B Sorting check boxes

C Tables with fields and relationships between tables

D None of the above

Answer: Option [C]

3 In a database table, the category of information is called ________

A record

B tuple

C field

D None of the above

Answer: Option [C]

4 Which of the following is not a database object ?

A Form

B Tables

C Reports

D Relationships

Answer: Option [D]

5 In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side is called _______

A Parent , Child

B Child , Parent

C Row , Column

D None of the above

Answer: Option [A]