MS Access MCQ Questions and solutions with explanations | MS Office

A. enterprise

B. distributed

C. tier

D. global

A. Click on the three dots to the right of the caption entry field

B. Click on the three dots to the right of the format entry field

C. Click on the input mask toolbar

D. Click on the three dots to the right of the input mask entry field

A. Number

B. Text

C. Currency

D. All of the above

A. 4

B. 3

C. 2

D. 1

A. query

B. form

C. report

D. None of the above

A. Inner join

B. Left outer join

C. Right outer join

D. Self join

A. operator

B. query

C. expression

D. None of the above

A. grand totals

B. Column headings

C. subtotals

D. page numbers

A. inner

B. first

C. second

D. third

A. Save your changes, close the workbook, and then reopen it.

B. Select the pivot table worksheet and press f9 on the keyboard

C. Click the report, and on the pivot table toolbar, click the refresh data button

D. All of the above