Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ETM 1030 > AL1 C3 C4 > Flashcards

AL1 C3 C4 Flashcards

1
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

Create

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

column heading names

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

the table(s) containing the data to be extracted

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Open the query in Datasheet view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

Or

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

“S*”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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.

A

open; modify

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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.

A

find duplicates

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

Totals; Show/Hide

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which of the following query types requires two tables?

A

find unmatched

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

forward slash (/)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

Field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

calculated

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

extract specific data from a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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?

A

Alphabetically

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

In the Crosstab Query Wizard, the first field selected causes

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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?

A

Field Properties

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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

A

grammatical errors

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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

A

Table Tools Design

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

When you delete a field, it

A

cannot be undone with the Undo button

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Where is the Spelling button?

A

in the Records group on the Home tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

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.

A

View

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

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

A

Ctrl + F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

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

A

ID; AutoNumber

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

To print specific records in a table, begin by

A

selecting the records

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

To move a field in Design view, begin by

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

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

A

sort order

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

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

A

It is deleted and cannot be restored

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

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

A

rich text

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

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

A

clicking the View button

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

Use the _____ data type to store URLs.

A

Hyperlink

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

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

A

long text

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

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

A

all the data in the table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

What does the word query mean?

A

question

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

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

A

Results

40
Q

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.

A

Property Sheet

41
Q

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

A

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

42
Q

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

A

three

43
Q

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

A

And

44
Q

A find unmatched query finds which of the following?

A

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

45
Q

How do you start the Lookup Wizard?

A

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

46
Q

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

A

plain text

47
Q

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

A

Currency

48
Q

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

A

Home

49
Q

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

A

brackets

50
Q

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

A

to find customers who have never placed orders

51
Q

A crosstab query must be built from fields in

A

one table

52
Q

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

A

can

53
Q

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

A

find duplicates

54
Q

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

A

crosstab

55
Q

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.

A

1; 0

56
Q

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

A

type the criterion statement

57
Q

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

A

Yes/No

58
Q

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

A

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

59
Q

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

A

count

60
Q

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

A

in the Status bar

61
Q

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

A

Access rejects the entry and displays an error message

62
Q

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

A

second

63
Q

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

A

Quick Access Toolbar

64
Q

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

A

Lookup Wizard

65
Q

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

A

exclamation point (!)

66
Q

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.

A

Object Type

67
Q

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

A

summary

68
Q

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

A

providing instructional information for data entry

69
Q

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

A

how the lookup column will get its values

70
Q

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

A

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

71
Q

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

A

Field Properties

72
Q

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

A

Nothing happens to them

73
Q

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

A

choose which input mask the data should look like

74
Q

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

A

Validation Rule

75
Q

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

A

Type the message in the Validation Text property box

76
Q

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

A

Group By

77
Q

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

A

asterisk (*)

78
Q

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

A

Shift + F2

79
Q

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

A

Short Text

80
Q

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

A

a colon

81
Q

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

A

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

81
Q

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

A

Click Find Run Unmatched Query

82
Q

How do you start the Input Mask Wizard?

A

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

83
Q

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

A

F1

84
Q

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

A

Records; Home

85
Q

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

A

groups the records for statistical calculations

86
Q

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

A

Sort the data that will be extracted

87
Q

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

A

Create

88
Q

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

A

End of Field

89
Q

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

A

the column where the insertion point is positioned

90
Q

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

A

from lowest to highest

91
Q

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

A

centers all text in the active column

92
Q

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

A

Design

93
Q

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

A

set pattern

94
Q

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.

A

gray square; thick black line

95
Q

The third field selected in the Crosstab Query Wizard

A

is summarized by an aggregate function

96
Q

You can build a query in all the following ways except

A

by saving it as a .qry file

ETM 1030 (18 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions