microsoft access mcq set 2 Detailed Explanation And More Example

Question : 1

The following property determines what is displayed in a control.

a) The control source property

b) The display property

c) The comes from property

d) The data property

Question : 2

How can you display Pivot Table report summary data in a currency format?

a) Use custom calculation

b) Type in the currency symbol

c) Modify the field settings

d) None of the above

Question : 3

What is the purpose of the description column in Table Design View?

a) To define the data type applied to each field within the table

b) To describe the data that should be entered in each field

c) To enter lookup data that the field should refer to.

d) None of the above

Question : 4

What method can you use to add a new table to your database?

a) Use Design View to create a table

b) Enter data directly by using a datasheet

c) Both of above

d) All of the above

Question : 5

In Access to open an existing database press

a) CTRL+N

b) CTRL+O

c) ALT+F4

d) None of these

Question : 6

If you are creating a cross tab query, what must table you are querying contain?

a) Lots of confusing information

b) More than 100 records

c) At least one field

d) None of the above