MS Access Questions & Answers | Basic Computer Knowledge

1.

A ______ name must be unique within a database

   A.) Table
   B.) Record
   C.) Field
   D.) All of the above

Answer: Option 'A'

Table

2.

_____ property is used to set the maximum size for data stored in a field?

   A.) Data entry
   B.) Field size
   C.) Format
   D.) Rows

Answer: Option 'B'

Field size

3.

Which key is used to join the two table in MS-Access?

   A.) Foreign key
   B.) Primary key
   C.) Special key
   D.) None of these

Answer: Option 'A'

Foreign key

4.

Collection of rlated records in a database is known as

   A.) Record
   B.) Relationship
   C.) File
   D.) Table

Answer: Option 'D'

Table

5.

There are three types of data found in a spreadsheet:

   A.) Equations, data, numbers
   B.) Numbers, formulas, labels
   C.) Data, words, numbers
   D.) Words, numbers, labels

Answer: Option 'B'

Numbers, formulas, labels

MS Access MCQs Download Pdf

Recent Posts