wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Access Chapter 3 Computer Applications MC

Total questions: 25

Worksheet time: 13mins

Name
Class
Date
1.

__________ is the Access object designed to extract data from one or more tables.

a)

Datasheet

b)

Report

c)

Form

d)

Query

2.

_________ is the dialog box used to add tables to a query.

a)

query table

b)

edit

c)

show table

d)

add table

3.

The __________ command instructs Access to carry out the instructions and display the results of a query.

a)

run

b)

go

c)

start

d)

begin

4.

Adding the ___________ type of statement to the query design grid will cause Access to display only certain records.

a)

comment

b)

criterion

c)

description

d)

objective

5.

Multiple criteria entered in the same Criteria row becomes a __________ statement.

a)

AND

b)

OR

c)

ELSE

d)

SUM

6.

Multiple criteria entered in different criteria rows becomes a ___________ type of statement.

a)

AND

b)

OR

c)

ELSE

d)

SUM

7.

_________ is the character between the text and the mathematical expression for the values.

a)

plus sign

b)

minus

c)

colon

d)

asterisk

8.

Use the ____________ to be guided through a series of dialog boxes to generate a form.

a)

form button

b)

form wizard

c)

form generator

d)

form box

9.

The Add Existing Fields button is located in the __________ group on the Form Layout Tools Design tab.

a)

views

b)

tools

c)

themes

d)

controls

10.

Use the _____________ key to select multiple control objects in a form or report.

a)

F1

b)

Alt

c)

Shift

d)

Ctrl

11.

Use the __________ object when you want to specify which fields to print.

a)

table

b)

form

c)

query

d)

report

12.

____________ is the default orientation.

a)

portrait

b)

landscape

c)

full

d)

autofit

13.

What is the name of the field place holder where data is entered or edited in a form.

a)

text box control

b)

label control object

c)

caption

d)

control property

14.

Placing multiple criterion statements on the same row in your query design grid means that ________.

a)

Each criterion statement must be satisfied

b)

Any one of the criteria statements must be satisfied

c)

None of the criterion statements must be satisfied

d)

An error will occur

15.

You can add fields from another table to a form using the ________ task pane in Layout View.

a)

Insert field

b)

Form design

c)

Field List

d)

Navigation

16.

You cannot add or edit data while viewing the __________ feature in Access.

a)

table

b)

query

c)

form

d)

report

17.

The Run button in the Results Group on the Query Tools Design tab displays which of the following symbols?

a)

Exclamation point

b)

Question mark

c)

Asterisk

d)

Ampersand

18.

Use the __________ view to make changes to a form.

a)

form

b)

layout

c)

design

d)

datasheet

19.

A black join line with the number one at each end indicates which type of relationship between two tables?

a)

one-to-many

b)

one-to-one

c)

singular

d)

locked

20.

What type of statement is often used to create mailing labels?

a)

Neither AND or OR

b)

AND

c)

AND or OR

d)

OR

21.

What is the name of the field place holder where data is entered or edited in a form?

a)

text box control

b)

label control object

c)

caption

d)

control property

22.

__________ is the term for the lower half of the query design window.

a)

Design grid

b)

Subdata sheet

c)

Sub form

d)

Sandbox

23.

How are a report and a form similar?

a)

They are comprised of a series of objects referred to as cobwebs.

b)

They contain the same fields

c)

They can be found in layout view

d)

They can be modified the same way

24.

You are using a query with a criterion statement to return records with a specific date value. The date portion of the criterion statement is enclosed in _____________.

a)

question marks

b)

exclamation points

c)

pound symbols

d)

slashes

25.

In mathematical calculation, field names in the mathematical expression are ________.

a)

Separated by a comma

b)

Encased in parenthesis

c)

Followed by a colon

d)

Encased in square brackets