MS Access MCQs

Question 1

Which of the following is use to get data from user?

Accepted Answer

Form

Answer

Query

Answer

Pages

Answer

Report

Question 2

Which of the following statements about a tab control in a form is incorrect?

Accepted Answer

It can contain only one object.

Answer

It defines a layered space.

Answer

It is a control object.

Answer

It is created in multipage forms.

Question 3

In a query, using the keyword _______________ will return records in which the field value is between two numbers.

Accepted Answer

Between

Answer

Is Null

Answer

Like

Answer

Not

Question 4

In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?

Accepted Answer

Referential integrity is enforced

Answer

Referential integrity isn't enforced

Answer

An inner join is set

Answer

An outer join is set

Question 5

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

Accepted Answer

To describe the data that should be entered in each field

Answer

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

Answer

To enter lookup data that the field should refer to.

Answer

None of the above

Question 6

Which field type can store photos?

Accepted Answer

OLE

Answer

Hyperlink

Answer

Both of these can be used

Answer

Access tables can't store photos

Question 7

In access, this displays the results of a calculation in a query

Accepted Answer

Calculated field

Answer

Lookup field

Answer

Source field

Answer

Child field

Question 8

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

Accepted Answer

At least one field

Answer

Lots of confusing information

Answer

More than 100 records

Answer

None of the above

Question 9

What type of control in a form can display data from database table?

Accepted Answer

Bound control

Answer

Unbound control

Answer

Both of above

Answer

None of above