MS Access MCQs

Question 1

__________ is used to build 'intuitive' queries.

Accepted Answer

QBE

Answer

SQL

Answer

Xbase

Answer

XML

Question 2

What is the type of query that extracts data from a table and puts them into separate table?

Accepted Answer

Make table query

Answer

Parameter query

Answer

Update query

Answer

Put table query

Question 3

Which of the following data types automatically generates a consecutive number?

Accepted Answer

Autonumber

Answer

Memo

Answer

Number

Answer

Text

Question 4

Which of the following is invalid field name?

Accepted Answer

Student.Address

Answer

Student'sAddress

Answer

Student_Address

Answer

Student Address

Question 5

Press the following keys in Access to Cancel Print Preview or Layout Preview

Accepted Answer

C or ESC

Answer

CTRL+P

Answer

P or CTRL+P

Answer

S

Question 6

The filter by selection feature allows you to filter:

Accepted Answer

Those records that match an entity in a field

Answer

Records based on a criterion you specify

Answer

Records that meet any of several criteria you specify

Answer

All of above

Question 7

The default and maximum size of text field in Access

Accepted Answer

50 and 255 Characters

Answer

8 and 1 GB

Answer

266 characters & 64000 characters

Answer

None of above

Question 8

Which of the following methods CANNOT be used to delete records from a table?

Accepted Answer

Pressing [Ctrl]+[']

Answer

Selecting records and pressing [Delete]

Answer

Clicking the Delete Record button

Answer

From the ribbon, selecting Delete Record

Question 9

How can you display the related records from other tables in datasheet view?

Accepted Answer

Click on the expand indicator next to the record

Answer

Double click on the record to expand it

Answer

Apply filter by command to display related records

Answer

All of above