MS Access MCQs

Question 1

Relationship can be establish between two tables by

Accepted Answer

Drag Primary key of a table into Foreign key of another table

Answer

Drag Foreign key of a table into Primary key of another table

Answer

Drag any key of a table into any key of another table

Answer

All of the above

Question 2

This is not one of the sections of the form design window

Accepted Answer

Form content

Answer

Form footer

Answer

Form header

Answer

Form detail

Question 3

In Access to Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.) list box or combo box

Accepted Answer

F9

Answer

F4 or ALT+DOWN ARROW

Answer

DOWN ARROW

Answer

PAGE DOWN

Question 4

After creating the table which of the following is correct?

Accepted Answer

Fields can added and deleted as needed

Answer

Fields cannot be added

Answer

Fields cannot be deleted

Answer

Fields can added but only once

Question 5

What is the use of Cascade Delete Option in MS Access?

Accepted Answer

It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted

Answer

It makes sure that all the records from the parent table and child table is deleted from selected database

Answer

It makes sure that all the related records will be deleted automatically from Parent table when the records from child table is deleted

Answer

None of above

Question 6

In Access to switch between Edit mode (with insertion point displaye(D)

Accepted Answer

F2

Answer

F4

Answer

F5

Answer

F6

Question 7

Which of the following statements does NOT hold true for the Top Values property?

Accepted Answer

The Top Values property displays only the highest values from the query.

Answer

The Top Values property requires the fields to have a defined sort order.

Answer

The Top Values property finds a specified number of records.

Answer

The Top Values property finds a specified percentage of records.

Question 8

A(n) __________ is an Extensible Scheme Standard file that is an approved W3C standard design as a basic infrastructure.

Accepted Answer

XSD

Answer

HTML

Answer

XML

Answer

XSL

Question 9

Which query do you use to answer the question "What is the average salary of the employees"?

Accepted Answer

Select query

Answer

Search query

Answer

Cross tab query

Answer

Update query