Ordering Records
Calculated Fields
Joining Tables
Criteria
Miscellaneous Queries
100
To order records in a table, choose ascending or descending in what row of the design grid?
The Sort line
100
Calculated fields can be of these two types.
Individual or group
100
The default type of join is
An inner join
100
A condition that the records to be included in a query must satisfy is called
criterion
100
Inner joins are used to show
Records that match between the two tables.
200
A query that is sorted by more than one field has a primary sort key and a
secondary sort key.
200
When you need a value calculated for each record, use this type
Individual
200
The line between two tables in a query shows that
The two tables are related
200
A wildcard character that represents one character is
?
200
To change join properties
Right click the join line between the two tables.
300
If a query is sorted in ascending order which would come first “Detroit” or “Chicago”?
Chicago
300
What feature in Access is available to help you create complex expressions?
Expression builder
300
What is required for the one common field between two tables used for a join?
Fields must be of the same type
300
A wildcard character that represents multiple characters is
*
300
This type of query allows you to choose how many records will show in the result.
Top values query
400
If you specify more than one sort key, the sort key on the left will be
the primary sort key
400
Where are calculated fields stored?
They are not stored
400
Changing join properties will change
The join type (inner or outer join) NOTE: This will then change the number of records that are shown when the query is run
400
To combine criteria with OR the criteria must be in what area of the grid?
On a separate line from the other criteria
400
This type of query calculates a statistic for data that is grouped by two different types of information.
Crosstab query
500
The secondary sort key is located where in the grid in relationship to the primary sort key?
To the right
500
What are the three purposes of the Totals row in a query?
Statistics, criteria & grouping
500
An outer join shows
All records from one table and the matching records in the related table
500
To combine criteria with AND the criteria must be in what area of the grid?
On the same line as the other criteria.
500
This operator allows you to search for a range of values.
Between
M
e
n
u