MS Access MCQs

Question 1

What is the first step in creating a form or report with the form wizard or report wizard?

Accepted Answer

Selecting the underlying table or query on which you want to base the form or report

Answer

Selecting the fields that you want to appear in the form or report

Answer

Reading several screens of mostly useless information and clicking next

Answer

Selecting how the form or report should be formatted

Question 2

In Access press PAGE UP

Accepted Answer

Move up one page

Answer

Move up one line

Answer

Exit the combo box or list box

Answer

None of these

Question 3

Which of the following is a method to create a new table in MS Access?

Accepted Answer

All of above

Answer

Create table in Design View

Answer

Create Table using wizard

Answer

Create Table by Entering data

Question 4

Which Form tool creates a new form that show both a form and datasheet views?

Accepted Answer

Split Form

Answer

Form

Answer

Form Wizard

Answer

Multiple Item Form

Question 5

A(n) _______________ query makes changes to or moves records in a dynaset, in a single operation.

Accepted Answer

action

Answer

select

Answer

summary

Answer

parameter

Question 6

A _______ name must be unique within a database

Accepted Answer

Table

Answer

Field

Answer

Record

Answer

Character

Question 7

Queries can be created in Access by

Accepted Answer

All of the Above

Answer

Typing Queries in SQL View

Answer

Drag and Drop fields on Query Builder

Answer

Using Query Wizard

Question 8

The type of query extract the data and put them into separate table

Accepted Answer

A make-table query

Answer

A parameter query

Answer

An update query

Answer

A crosstab query

Question 9

Which of the following is the file extension for an Extensible Markup Language?

Accepted Answer

XML

Answer

EML

Answer

HTML

Answer

XSD