MS Access MCQs

Question 1

In Access press ALT+F11 to

Accepted Answer

None of these

Answer

Display the Control menu

Answer

Display the shortcut menu

Answer

Close the active window

Question 2

Which of the following queries can create a table?

Accepted Answer

Make-Table

Answer

Append

Answer

Delete

Answer

Update

Question 3

Data can be import into Access Database from

Accepted Answer

Excel Files

Answer

Word Files

Answer

PowerPoint Files

Answer

HTML Files

Question 4

Where can you find the undo command in Access?

Accepted Answer

Quick Access toolbar

Answer

Office button

Answer

Home command tab

Answer

Status bar

Question 5

Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?

Accepted Answer

Database Tab

Answer

Home Tab

Answer

Create Tab

Answer

External Data Tab

Question 6

In Access press to Open the Visual Basic Editor from a selected property in the property sheet for a form or report

Accepted Answer

F7

Answer

F6

Answer

F8

Answer

None of these

Question 7

The ability of a database to grow as the data tracking needs grow is its __________.

Accepted Answer

scalability

Answer

expandability

Answer

maintainability

Answer

platform-independence

Question 8

Which of the following is not one of the methods available in the new query dialog box to create queries?

Accepted Answer

Datasheet view

Answer

Design view

Answer

Crosstab query wizard

Answer

Simple query wizard

Question 9

Which of the following statements about calculated fields is NOT true?

Accepted Answer

Data contained in a calculated field is created the first time a query is run.

Answer

A calculated field does not store data in a recordset.

Answer

Calculated fields use an expression or formula as its data source.

Answer

A calculated field can be created using the Expression Builder dialog box.