MS Access MCQs

Question 1

In the Field List of a table, the primary key appears _______________.

Accepted Answer

with key icon

Answer

bold

Answer

italicized

Answer

underlined

Question 2

In the second subform wizard dialog box you specify the table to use as the data source and the

Accepted Answer

Fields from the selected table

Answer

Records from the selected form

Answer

Form from the selected table

Answer

Content from the selected form

Question 3

Which of the following is a standard file format language for web documents?

Accepted Answer

HTML

Answer

XML

Answer

XSD

Answer

XSL

Question 4

Which major database object stores all data?

Accepted Answer

Table

Answer

Field

Answer

Query

Answer

Record

Question 5

A __________ enables you to view data from a table based on a specific criterion

Accepted Answer

Query

Answer

Form

Answer

Macro

Answer

Report

Question 6

the executive responsible for the data processing function in an organization is

Accepted Answer

Dbms

Answer

Pm

Answer

Dp

Answer

Dpm

Question 7

Referential integrity means

Accepted Answer

Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table

Answer

Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent table

Answer

Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table

Answer

All of above

Question 8

A database object in MS Access that stores a question about the data in database?

Accepted Answer

Query

Answer

Table

Answer

Form

Answer

Report

Question 9

Which is NOT a method of creating a table?

Accepted Answer

Layout View

Answer

Datasheet View

Answer

Design View

Answer

Template