AL1 C3 C4

Question 1

Which of the following is not one of the methods of inserting a field in the query design grid?

Answer 1

opening the table or query in Design view and then double-clicking the desired field

Question 2

Create a query by clicking the Query Design button in the Queries group on the _____ tab.

Answer 2

Create

Question 3

In the results of a query using aggregate functions, Access automatically determines the

Answer 3

column heading names

Question 4

At the first Simple Query Wizard dialog box, the first piece of information you are asked to specify is

Answer 4

the table(s) containing the data to be extracted

Question 5

Double-clicking a query in the Navigation pane will do which of the following?

Answer 5

Open the query in Datasheet view

Question 6

Specific information can be extracted from a table by running a(n)

Answer 6

query

Question 7

A field in a query that contains two criteria statements, either of which can be met to return results, is called a(n) _____ statement.

Answer 7

Or

Question 8

Which of the following criteria statements will return field values beginning with S and ending in anything?

Answer 8

“S*”

Question 9

At the third (and last) Simple Query Wizard dialog box, you type a name for the query and then are given options to _____ or _____ the query.

Answer 9

open; modify

Question 10

If you suspect that a client has mistakenly been entered into your clients table under two different client numbers, you would use a _____ query to find the problem.

Answer 10

find duplicates

Question 11

To display the aggregate function list in the query design grid, click the _____ button in the _____ group.

Answer 11

Totals; Show/Hide

Question 12

Which of the following query types requires two tables?

Answer 12

find unmatched

Question 13

In creating a calculated field, what symbol do you use for division?

Answer 13

forward slash (/)

Question 14

When you enter criteria statements in your query design grid, Access automatically enters _____ around criteria in text fields and _____ around criteria in date fields.

Answer 14

quotation marks (“ “); pound symbols (#)

Question 15

In which query design grid row field do you type the equation for a calculated field?

Answer 15

Field

Question 16

A query field that uses a mathematical equation to determine the contents that display is called a _____ field.

Answer 16

calculated

Question 17

Queries are used to perform one of the most important database functions, which is to

Answer 17

extract specific data from a table

Question 18

Which of the following is not one of the options in the drop-down list in the Sort row field in the query design grid?

Answer 18

Alphabetically

Question 19

In the Crosstab Query Wizard, the first field selected causes

Answer 19

one row to display in the query results datasheet for each group

Question 20

When modifying a table in Design view, which of the following elements displays in the lower half of the work area rather than the top?

Answer 20

Field Properties

Question 21

The Access spelling check will not find which of the following kinds of errors?

Answer 21

grammatical errors

Question 22

Return to Datasheet view from Design view by clicking the View button in the Views group on the _____ tab.

Answer 22

Table Tools Design

Question 23

When you delete a field, it

Answer 23

cannot be undone with the Undo button

Question 24

Where is the Spelling button?

Answer 24

in the Records group on the Home tab

Question 25

To get information about a function using the Tell Me feature, click in the Tell Me text box on the ribbon to the right of the _____ tab and then type the function.

Answer 25

View

Question 26

Use the keyboard shortcut _____ to display the Find and Replace dialog box with the Find tab selected.

Answer 26

Ctrl + F

Question 27

When you create a new table in Design view, Access automatically assigns the first field the name _____ and assigns the _____ data type.

Answer 27

ID; AutoNumber

Question 28

When you click the Ascending button in the Sort & Filter group on the Home tab, data in the active field is sorted as follows:

Answer 28

Text is sorted alphabetically from A to Z, numbers are sorted from lowest to highest, and dates are sorted from earliest to latest

Question 29

To print specific records in a table, begin by

Answer 29

selecting the records

Question 30

To move a field in Design view, begin by

Answer 30

clicking the field selector bar at the left side of the row you want to move

Question 31

Which of the following is not one of the three elements specified for each field in Design view?

Answer 31

sort order

Question 32

When you delete a field in a table, what happens to the data stored in that field?

Answer 32

It is deleted and cannot be restored

Question 33

To format text in a specific field, choose the Long Text data type and specify _____ formatting.

Answer 33

rich text

Question 34

When creating a table, you can switch from Datasheet view to Design view by

Answer 34

clicking the View button

Question 35

Use the _____ data type to store URLs.

Answer 35

Hyperlink

Question 36

This data type accepts alphanumeric data up to 65,535 characters in length.

Answer 36

long text

Question 37

When applying formatting in Datasheet view, the buttons in the Text Formatting group (Bold, Italic, Underline, etc.) apply formatting to

Answer 37

all the data in the table

Question 38

What does the word query mean?

Answer 38

question

Question 39

The Run button is in the _____ group on the Query Tools Design tab.

Answer 39

Results

Question 40

If the results of the calculation should display as currency, apply numeric formatting and define the number of digits past the decimal point using the _____ task pane.

Answer 40

Property Sheet

Question 41

Clicking the Query Design button opens a query window in the work area and also displays the Show Table dialog box, where you

Answer 41

click the name(s) of the table(s) to be included in the query

Question 42

What is the minimum number of fields needed to create a crosstab query?

Answer 42

three

Question 43

Multiple criteria all entered in the same row in the query design grid become a(n) _____ statement.

Answer 43

And

Question 44

A find unmatched query finds which of the following?

Answer 44

records in one table that do not have matching records in the other related table

Question 45

How do you start the Lookup Wizard?

Answer 45

Click in the field in the Data Type column, click the option box arrow, and then click Lookup Wizard at the drop-down list

Question 46

By default, the Long Text data type uses _____ formatting.

Answer 46

plain text

Question 47

Monetary data should be stored in a field with the _____ data type.

Answer 47

Currency

Question 48

To apply formatting to data in Datasheet view, use options in the Text Formatting group on the _____ tab.

Answer 48

Home

Question 49

When creating a calculated field, use _____ to surround the field names.

Answer 49

brackets

Question 50

In which of the following situations would you use a find unmatched query?

Answer 50

to find customers who have never placed orders

Question 51

A crosstab query must be built from fields in

Answer 51

one table

Question 52

A query _____ be designed that combines And and Or statements.

Answer 52

can

Question 53

The _____ query is useful for identifying loyal customers in an orders table.

Answer 53

find duplicates

Question 54

A _____ query calculates aggregate functions in which field values are grouped by two fields.

Answer 54

crosstab

Question 55

When extracting records for a query using the yes/no checkboxes, you must type a _____ for true records containing a checkmark and a _____ for false records that do not contain a checkmark.

Answer 55

1; 0

Question 56

To add a criterion in the query design grid, click in the field in the Criteria row in the column containing the field name and then

Answer 56

type the criterion statement

Question 57

To store values that will be only True or False, use the _____ data type.

Answer 57

Yes/No

Question 58

Use the keyboard shortcut Ctrl + H to do which of the following?

Answer 58

Display the Find and Replace dialog box with the Replace tab selected

Question 59

What function is inserted by default when you add a Total row to a table?

Answer 59

count

Question 60

When designing a table in Design view, the text you enter in the Description field will display _____ when the field is active.

Answer 60

in the Status bar

Question 61

What happens when data is entered that does not satisfy the conditional test established in the Validation Rule property box?

Answer 61

Access rejects the entry and displays an error message

Question 62

You asked to enter values for the lookup field at the _____ Lookup Wizard dialog box.

Answer 62

second

Question 63

After completing a table design, save it by clicking the Save button on the

Answer 63

Quick Access Toolbar

Question 64

To limit the data entered into a field to a specific list of items, use the

Answer 64

Lookup Wizard

Question 65

What appears on the Run button on the Query Tools Design tab?

Answer 65

exclamation point (!)

Question 66

To list multiple queries together in the Navigation pane, click the option box arrow in the Navigation pane menu bar and then click _____ at the drop-down list.

Answer 66

Object Type

Question 67

At the second Simple Query Wizard dialog box, you are asked whether you would like to create a detail or a(n) _____ query.

Answer 67

summary

Question 68

When typing a description, consider identifying the field’s purpose or contents or

Answer 68

providing instructional information for data entry

Question 69

What are you asked to indicate at the first Lookup Wizard dialog box?

Answer 69

how the lookup column will get its values

Question 70

In what order should the fields in the query design grid appear?

Answer 70

in the order in which you want them to display in the query results datasheet

Question 71

Default values are assigned in the _____ section of Design view.

Answer 71

Field Properties

Question 72

When a default value is set for a field in a table that already contains data, what happens to the existing entries?

Answer 72

Nothing happens to them

Question 73

At the first Input Mask Wizard dialog box, you are asked to

Answer 73

choose which input mask the data should look like

Question 74

Use the _____ property box to enter a statement containing a conditional test that is checked each time data is entered into a field.

Answer 74

Validation Rule

Question 75

How can you customize the error message that Access displays when a validation rule is violated?

Answer 75

Type the message in the Validation Text property box

Question 76

Which of the following is not an example of an aggregate function?

Answer 76

Group By

Question 77

The _____ is used as a wildcard character in query design.

Answer 77

asterisk (*)

Question 78

To provide a larger area for typing criterion in a query, press _____ to display the Zoom box.

Answer 78

Shift + F2

Question 79

Which data type should be used to store social security numbers?

Answer 79

Short Text

Question 80

When creating a calculated field in a query, the field name should be separated from the equation by which of the following?

Answer 80

a colon

Question 81

What will the criteria "[S-W]*" return?

Answer 81

field values that begin with S through W and end in anything

Question 81

Which of the following is not one of the steps in creating a find unmatched query?

Answer 81

Click Find Run Unmatched Query

Question 82

How do you start the Input Mask Wizard?

Answer 82

Click the Build button at the right side of the Input Mask property box

Question 83

To use the Access Help feature, click the Help button in the Help group on the Help tab or press the _____ key.

Answer 83

F1

Question 84

To add a Total row to a table in Datasheet view, click the Totals button in the _____ group on the _____ tab.

Answer 84

Records; Home

Question 85

In the query design grid, selecting the Group By option in the Total field drop-down list does which of the following?

Answer 85

groups the records for statistical calculations

Question 86

Which of the following is not one of the three basic steps in designing a query?

Answer 86

Sort the data that will be extracted

Question 87

To start the Simple Query Wizard, begin by clicking the Query Wizard button in the Queries group on the _____ tab.

Answer 87

Create

Question 88

Which of the following is not one of the options available at the Match drop-down list at the Find and Replace dialog box?

Answer 88

End of Field

Question 89

When data has been entered at the Find and Replace dialog box, Access will search in _____ by default.

Answer 89

the column where the insertion point is positioned

Question 90

When you choose Ascending in the query design grid’s Sort row field for a numeric data field, how will the results be sorted?

Answer 90

from lowest to highest

Question 91

What does the Center button in the Text Formatting group do?

Answer 91

centers all text in the active column

Question 92

Use the Delete Rows button when deleting a field in _____ view.

Answer 92

Design

Question 93

An input mask is a _____ that controls how data is entered in the field.

Answer 93

set pattern

Question 94

When moving a field in Design view by dragging with the mouse pointer, a _____ will be attached to the pointer and a(n) _____ will display in the new position.

Answer 94

gray square; thick black line

Question 95

The third field selected in the Crosstab Query Wizard

Answer 95

is summarized by an aggregate function

Question 96

You can build a query in all the following ways except

Answer 96

by saving it as a .qry file