Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Access CH 7 & 8

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.

A(n) _________ is the most basic type of Access query.

a)

record source

b)

select query

c)

duplicates

d)

field list

2.

The tables or queries from which a query gets its data are referred to as its ______________.

a)

select query

b)

duplicates

c)

record source

d)

field list

3.

Two or more records are considered _______________ only when all the fields in your query results contain the same values.

a)

filed list

b)

find unmatched

c)

select query

d)

duplicates

4.

To view only the records in one table that don't have a matching record in another table, you can create a(n) _______________ query.

a)

Find Unmatched

b)

Field List

c)

Record source

d)

duplicates

5.

A(n) ____________ is a window that lists all the fields in the underlying record source or database.

a)

record source

b)

simple query

c)

field list

d)

parameter query

6.

Which of the following queries cannot be created using the Query Wizard?

a)

Parameter query

b)

Simple query

c)

Find duplicates query

d)

Find unmatched query

7.

Which of the following statements best describes why queries are different from sort or filter commands?

a)

You can apply them to multiple fields.

b)

You can save them.

c)

You can modify them.

d)

You can use them on forms.

8.

To find records that contain matching field values, you can create a query using which of the following wizards?

a)

Find Matching

b)

Matching Fields

c)

Duplicate Records

d)

Find Duplicates

9.

Before creating a query form multiple tables, you must first ensure that the tables have which of the following?

a)

Unmatched records

b)

A defined relationship

c)

A filter applied

d)

No related records

10.

To add a table to a query, you must be in which of the following views?

a)

SQL

b)

Datasheet

c)

Normal

d)

Design

11.

A control that displays the result of a calculation or expression

a)

bond control

b)

calculated control

c)

control wizards

d)

stacked layout

12.

Help you create controls such as command buttons, list boxes, combo boxes, and option groups

a)

bound control

b)

calculated control

c)

control wizards

d)

stacked layout

13.

Controls that are arranged vertically with a label on the left and the control on the right

a)

stacked layout

b)

bound control

c)

conditional formatting

d)

control wizards

14.

A control that uses a filed in a table or query as the data source

a)

bound control

b)

calculated control

c)

control wizards

d)

conditional formatting

15.

Used to change the appearance of a control or the value in a control when certain conditions are met

a)

control wizards

b)

calculated control

c)

bound control

d)

conditional formatting

16.

The easiest way to create a bound control is to double-click or drag a field from the Property Sheet to the report.

a)

True

b)

False

17.

Display formatting can be applied to controls and labels in a form or report.

a)

True

b)

False

18.

You can change an entire control layout of a report or form from one type to the other.

a)

True

b)

False

19.

The Remove Layout command in the Table group removes a control from a form or report.

a)

True

b)

False

20.

You can use Print Preview to set the margins for a form or report.

a)

True

b)

False