MS Access MCQs

Question 1

In Access to switch to the property sheet (Design view in forms and reports in both Access databases and Access projects)

Accepted Answer

F4

Answer

F2

Answer

F5

Answer

F6

Question 2

Which data type is better to use for storing phone number in the following format "977-1-1234567"?

Accepted Answer

Text

Answer

AutoNumber

Answer

Number

Answer

Currency

Question 3

What is the keyboard shortcut to move to the last records in a table?

Accepted Answer

[Ctrl]+[End]

Answer

[Tab]

Answer

[Shift]+[Tab]

Answer

[Ctrl]+Home]

Question 4

Press the following keys in Access to Print the current or selected object

Accepted Answer

CTRL+P

Answer

P or CTRL+P

Answer

S

Answer

C or ESC

Question 5

Which is not an option for Filter on a text field?

Accepted Answer

Between

Answer

Begins With

Answer

Contains

Answer

End With

Question 6

You can keep the sum([Sales]) to calculate the totals for each month in

Accepted Answer

the month group footer section

Answer

the report footer section

Answer

the page footer section

Answer

the summary section

Question 7

Which of the following types of joins displays records with the same value in the common field?

Accepted Answer

Inner join

Answer

Left outer join

Answer

Right outer join

Answer

Self join

Question 8

Which of the following type s of queries are action queries?

Accepted Answer

Append Queries

Answer

Update queries.

Answer

Crosstab Queries

Answer

Parameter queries

Question 9

Which of the following creates a drop down list of values to choose from a list?

Accepted Answer

Lookup Wizard

Answer

OLE Object

Answer

Hyperlink

Answer

Memo