Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ACCESS CHAPTER 2 - Study Guide Mar22

Total questions: 20

Worksheet time: 11mins

Name
Class
Date
1.

A question that is asked of Access or any other database management system is called a(n) '

(a)  

2.

To include the Total row in the design grid, click the _____ button on the Design tab.

a)

Totals

b)

Aggregate

c)

Statistics

d)

Calculations

3.

To show the Navigation Pane if it is hidden, click the ____ Button.

a)

Restore

b)

Show/Hide

c)

Shutter Bar Open/Close

d)

Show

4.

To change the caption for a field in a query, click the field in the design grid, click the _____ button on the Design tab, click the Caption box, and enter the new caption.

a)

Property Sheet

b)

Caption

c)

Format

d)

Field Name

5.

To use a parameter query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.

a)

Run

b)

Enter Values

c)

Use parameter

d)

Open

6.

To include all fields in the design grid, double-click the question mark (?) in the field list. ____________________

a)

True

b)

False

7.

A(n) ____ join is the default join in Access.

a)

left outer

b)

outer

c)

inner

d)

right inner

8.

To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

a)

Enlarge

b)

Magnify

c)

Resize

d)

zoom

9.

To use the Expression Builder to create a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

a)

Expression Builder

b)

Builder box

c)

Field Builder

d)

Build

10.

You can include ____ in calculations to indicate which calculation should be done first.

a)

curly braces {}

b)

slashes//

c)

brackets[]

d)

parentheses()

11.

To quit Access, click the ____ button on the right side of the Access title bar.

a)

close

b)

exit

c)

quit

d)

stop

12.

To find all individuals whose name is Francis or Frances, enter ____ in the Criteria row of the appropriate column.

a)

Franc#s

b)

Franc%s

c)

Franc*s

d)

Franc?s

13.

To indicate grouping in Access, select _____ as the entry in the Total row for the field to be used for grouping.

a)

Group By

b)

Like

c)

Where

d)

Same

14.

Wildcards are symbols that represent any character or combination of characters. ____________________

a)

True

b)

False

15.

You can delete a table by right-clicking the field list and clicking ____ on the shortcut menu.

a)

Remove Table

b)

Erase Table

c)

Delete Table

d)

Hide Table

16.

Each individual criterion must be true in order for the compound criterion to be true.

a)

OR Criterion

b)

AND Criterion

17.

Represents any collection of characters.

a)

*

b)

/

18.

A comparison operator.

a)

AND

b)

NOT

19.

A mathematical operator for division.

a)

*

b)

/

20.

Either individual criterion must be true in order for the compound criterion to be true.

a)

NOT criterion

b)

OR criterion