MS Access MCQs

Question 1

To set a password for the database, select ____________ in the Microsoft Access open window.

Accepted Answer

Open exclusive

Answer

Open read only

Answer

Open write only

Answer

Open explicit

Question 2

You can not import data into access database from

Accepted Answer

None of the above

Answer

Dbase iii database files

Answer

Excel spreadsheets

Answer

Comma delimited text files

Question 3

Which report section only prints one time at the end of the report?

Accepted Answer

Report Footer

Answer

Report Header

Answer

Page Header

Answer

Page Footer

Question 4

Which of the following properties identifies the type of information stored in a field?

Accepted Answer

Data type

Answer

Field description

Answer

Field name

Answer

Field properties

Question 5

In Access press CTRL+F8 to

Accepted Answer

Toggle the Navigation Pane

Answer

Cycle between open windows

Answer

Restore the selected minimized window when all windows are minimized

Answer

Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window

Question 6

Which of the following views is used to graphically summarize and analyze data in a recordset?

Accepted Answer

PivotChart

Answer

Datasheet

Answer

Form

Answer

PivotTable

Question 7

All attachment fields display as a(n) ______ in Datasheet View.

Accepted Answer

paperclip

Answer

icon

Answer

button

Answer

thumb tack

Question 8

Which of the following is not a view for interacting with a form object?

Accepted Answer

Layout view

Answer

Datasheet view

Answer

Design view

Answer

Form view

Question 9

What is the result of 'Select * from customer where CustID>10 and CustID<100' query?

Accepted Answer

display all customers with CustID from 11 to 99

Answer

display all customers with CustID from 10 to 100

Answer

display all customers with CustID above 10

Answer

display all customers with CustID below 100