WorksheetsAccess CH 7 & 8
Total questions: 20
Worksheet time: 10mins
A(n) _________ is the most basic type of Access query.
record source
select query
duplicates
field list
The tables or queries from which a query gets its data are referred to as its ______________.
select query
duplicates
record source
field list
Two or more records are considered _______________ only when all the fields in your query results contain the same values.
filed list
find unmatched
select query
duplicates
To view only the records in one table that don't have a matching record in another table, you can create a(n) _______________ query.
Find Unmatched
Field List
Record source
duplicates
A(n) ____________ is a window that lists all the fields in the underlying record source or database.
record source
simple query
field list
parameter query
Which of the following queries cannot be created using the Query Wizard?
Parameter query
Simple query
Find duplicates query
Find unmatched query
Which of the following statements best describes why queries are different from sort or filter commands?
You can apply them to multiple fields.
You can save them.
You can modify them.
You can use them on forms.
To find records that contain matching field values, you can create a query using which of the following wizards?
Find Matching
Matching Fields
Duplicate Records
Find Duplicates
Before creating a query form multiple tables, you must first ensure that the tables have which of the following?
Unmatched records
A defined relationship
A filter applied
No related records
To add a table to a query, you must be in which of the following views?
SQL
Datasheet
Normal
Design
A control that displays the result of a calculation or expression
bond control
calculated control
control wizards
stacked layout
Help you create controls such as command buttons, list boxes, combo boxes, and option groups
bound control
calculated control
control wizards
stacked layout
Controls that are arranged vertically with a label on the left and the control on the right
stacked layout
bound control
conditional formatting
control wizards
A control that uses a filed in a table or query as the data source
bound control
calculated control
control wizards
conditional formatting
Used to change the appearance of a control or the value in a control when certain conditions are met
control wizards
calculated control
bound control
conditional formatting
The easiest way to create a bound control is to double-click or drag a field from the Property Sheet to the report.
True
False
Display formatting can be applied to controls and labels in a form or report.
True
False
You can change an entire control layout of a report or form from one type to the other.
True
False
The Remove Layout command in the Table group removes a control from a form or report.
True
False
You can use Print Preview to set the margins for a form or report.
True
False
