37)
In a calculated field, existing field names are enclosed in square ________.
37)
Answer:
brackets
Explanation:
38)
If you intend to use sorted query results in a report, the sort order should be specified in
________ view.
38)
Answer:
Query Design
Explanation:
39)
A placeholder for unknown characters in the criteria of a query is called a(n) ________.
39)
Answer:
wildcard
Explanation:
40)
When a query is saved, the records reside in the related table; only the ________ of the
query is saved.
40)
Answer:
design
Explanation:
41)
The lower part of the Query Design window is known as the ________.
41)
Answer:
design grid
Explanation:
42)
A field in one table used to connect to the primary key in another table is called a(n)
________ key.
42)
Answer:
foreign
Explanation:
43)
In a query, compound criteria can be created using ________ operators such as AND and
OR.
43)
Answer:
logical
Explanation:
44)
Calculations that are performed on a group of records are called ________ functions.
44)
Answer:
aggregate
Explanation:
45)
A select query, based on criteria, shows a portion of the total records available, also known
as a(n) ________.
45)
Answer:
subset
Explanation:
46)
The ________ is an area of Access where you can view the security and privacy settings for
your Access installation.
46)
Answer:
Trust Center
Explanation:
47)
Queries in Access can be designed to display only records that match certain conditions,
called ________.
47)
Answer:
criteria.
Explanation:
8
48)
When opening the Relationships window for the first time, the ________ dialog box
appears.
48)
Answer:
Show Table
Explanation:
49)
A(n) ________ separates a new field name from the expression for the new calculated field.
49)
Answer:
colon
Explanation:
50)
Because several tables might have a similarly named field (e.g., Address), Access includes
a(n) ________ row on the query design grid to avoid confusion.
50)
Answer:
table
Explanation:
51)
To allow more space in which to write an expression, you can open the ________ dialog
box.
51)
Answer:
Zoom
Explanation:
52)
SUM, AVG, MIN, and MAX are examples of ________ functions.
52)
Answer:
aggregate
Explanation:
53)
A(n) ________ field stores the result of a mathematical operation.
53)
Answer:
calculated
Explanation:
54)
Match the following terms with their meaning:
I. Asterisk A. serve as a placeholder for one or more unknown
characters in your criteria
II. Criteria row B. a placeholder to match any number of characters
III. Question mark C. where a wildcard character would be used
IV. Criteria D. searches for unknown single characters
V. Wildcards E. conditions that identify specific records you are
looking for with a query
54)
Answer:
B, C, D, E, A
Explanation:
55)
A(n) ________ query retrieves specific data from one or more tables and displays the
results in Datasheet view.
55)
Answer:
select
Explanation:
56)
A Relationship Report is found in the Navigation Pane under ________.
56)
Answer:
Unrelated Objects
Explanation:
57)
A formula that will perform a calculation is called a(n) ________.
57)
Answer:
expression
Explanation:
9
58)
Match the following terms to their meaning:
I. Logical operators A. displays records in query results that meet all
parts of the specified criteria
II. AND condition B. displays records in query results that meet any of
the specified criteria
III. OR condition C. =, >, and <
IV. Comparison operators D. AND and OR
V. Compound criteria E. Uses logical operators
58)
Answer:
D, A, B, C, E
Explanation:
59)
By default, tables are sorted in order by the ________.
59)
Answer:
primary key
Explanation:
60)
To change the formatting of a new calculated field, you must use the ________.
60)
Answer:
Property Sheet
Explanation:
61)
Access automatically will add number signs (#) before and after ________ criteria in a
query.
61)
Answer:
date
Explanation:
62)
The ________ is the area below the Ribbon that displays information such as security alerts.
62)
Answer:
Message Bar
Explanation:
TRUE/FALSE. Write ‘T’ if the statement is true and ‘F’ if the statement is false.
63)
If the field list is too small in the Relationships window, double–click the title bar to automatically
resize the list.
63)
Answer:
True
False
Explanation:
64)
A query can select records from any two database tables, whether or not they are related.
64)
Answer:
True
False
Explanation:
65)
Sort order for a query is saved with the query design, whether the sort was specified in the design
grid or in Datasheet view.
65)
Answer:
True
False
Explanation:
66)
In query criteria, when searching for a single unknown character, use the ? character.
66)
Answer:
True
False
Explanation:
10
67)
The field on the one side of a one–to–many relationship is typically the primary key in that table.
67)
Answer:
True
False
Explanation:
68)
Clicking the Totals button adds a new row to the design grid.
68)
Answer:
True
False
Explanation:
69)
A new calculated field uses the formatting of the field(s) used in the expression.
69)
Answer:
True
False
Explanation:
70)
A crosstab query requires only a field for a row heading and a field for a column heading.
70)
Answer:
True
False
Explanation:
71)
The Zoom dialog box allows more working space into which to type a calculation.
71)
Answer:
True
False
Explanation:
72)
A join line appears in the Relationships window whenever two tables are related based on a
common field.
72)
Answer:
True
False
Explanation:
73)
Every field included in the query design grid must appear in the query result.
73)
Answer:
True
False
Explanation:
74)
Sorting a table in Ascending order on the State field would result in Alaska displaying before
California.
74)
Answer:
True
False
Explanation:
75)
Because fields are only added to the right of the design grid, to add a field between existing fields
requires you to clear the grid and start over.
75)
Answer:
True
False
Explanation:
76)
You can sort query results only in Design view.
76)
Answer:
True
False
Explanation:
77)
In a manual sort, the outermost sort field must be listed to the right of the innermost sort field.
77)
Answer:
True
False
Explanation:
11
78)
When creating an OR condition for the values in a single field, you must enter the word OR in the
criteria row.
78)
Answer:
True
False
Explanation:
79)
In addition to a one–to–many relationship, tables can also have a one–to–one relationship.
79)
Answer:
True
False
Explanation:
80)
A crosstab query summarizes a large amount of data into a small, easy–to–read space.
80)
Answer:
True
False
Explanation:
81)
Text criteria in a query are not case sensitive.
81)
Answer:
True
False
Explanation:
82)
In Query Design view, the Show Table command is used to add tables to the design grid.
82)
Answer:
True
False
Explanation:
83)
Access will automatically add quotes around a dollar amount used as a criteria.
83)
Answer:
True
False
Explanation:
84)
After clicking the Totals button, the words Sum By appear on the Total row in all fields.
84)
Answer:
True
False
Explanation:
85)
In a query, you should not enter dollar signs in the query criteria.
85)
Answer:
True
False
Explanation:
86)
The advantage of using calculated fields in a query is the need for fewer fields in the database and
increased flexibility.
86)
Answer:
True
False
Explanation:
87)
In a query design, the Totals button can also be used to group (summarize) nonnumeric data.
87)
Answer:
True
False
Explanation:
88)
Sort order in Datasheet view overrides the sort order in Design view.
88)
Answer:
True
False
Explanation:
89)
When referential integrity is enforced, small symbols indicate which is the one table and which is
the many table within the relationship.
89)
Answer:
True
False
Explanation:
12
90)
Placing criteria for two different fields on the Criteria row creates an AND condition.
90)
Answer:
True
False
Explanation:
91)
To create a copy of a database, Access 2010 requires you to use a closed database file rather than
Save As.
91)
Answer:
True
False
Explanation:
92)
The table or tables from which a query selects its data are referred to as the data source.
92)
Answer:
True
False
Explanation:
93)
When sorting a table in Datasheet view, Access allows only one sort field per table.
93)
Answer:
True
False
Explanation:
94)
Queries are most often created as a basis for a report, but query results can be printed like any other
table of data.
94)
Answer:
True
False
Explanation:
95)
Relationships are established based on key fields.
95)
Answer:
True
False
Explanation:
96)
When printing tables, Access automatically includes the table name in the footer of the printout.
96)
Answer:
True
False
Explanation:
97)
Field order in a query can be changed by dragging the field to a new position on the design grid.
97)
Answer:
True
False
Explanation:
13