Name:     ID: 
 
Email: 

Access:  Lesson Three

True/False
Indicate whether the statement is true or false.
 

 1. 
A query is a database object that lets you ask the database about the data it contains.
 

 2. 
A filter temporarily displays records in a datasheet based on the condition that you specify.
 

 3. 
You can use Filter By Selection when you need to display records that contain one or more values based on the values stored in one or more fields
 

 4. 
A sort or a filter is the only method to change the way that data is displayed in a table datasheet.
 

 5. 
A matching field is also called a mirror field because it is common in both tables involved in the relationship.
 

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 6. 
When you use ____, you select a field value (or part of a field value) in a datasheet, and then click the Selection button in the Sort & Filter group on the Home tab.
a.
Filter By Selection
c.
Filter by Query
b.
Filter By Form
d.
Filter by Value
 

 7. 
To use____, click the Advanced button in the Sort & Filter group on the Home tab. In the menu that opens, click Filter By Form.
a.
Filter By Selection
c.
Filter By Query
b.
Filter By Form
d.
Filter By Value
 

 8. 
After applying any filter to a field, clicking the ____ button in the Sort & Filter group on the Home tab removes it and displays all records again.
a.
Move Filter
c.
Query Filter
b.
Toggle Filter
d.
Select Filter
 

 9. 
In the ____ window, you build and change the query using the query design grid.
a.
Format Design
c.
Form Design
b.
Layout Design
d.
Query Design
 

 10. 
A query can contain ____ of the fields in the table.
a.
one
c.
all
b.
some
d.
all of the above
 

 11. 
When you need to sort data first based on the values in one field, and then by the values in a second field, you can set the sort orders for the two fields using the ____ in the design grid.
a.
Grid boxes
c.
Sort boxes
b.
Field boxes
d.
Text boxes
 

 12. 
You can run the query by clicking the Run button in the ____ group on the Query Tools Design tab.
a.
Query
c.
Total
b.
Results
d.
Data
 

 13. 
When you relate tables, Access uses a set of rules to ensure that there are matching values in
the common field used to form the relationship, both at the time you create the relationship and
as you enter data in the tables after you create the relationship. This set of rules is called ____.
a.
referential integrity
c.
match conditions
b.
security rules
d.
field rules
 

 14. 
To create a relationship between tables, click the ____ tab on the Ribbon. In the Show/Hide group, click the Relationships button.
a.
Database Tools
c.
Data
b.
Relationship
d.
Format
 

 15. 
The ____ symbol next to a field name in a field list indicates the table’s primary key.
a.
plus sign
c.
number 1
b.
lock
d.
key
 

 16. 
After you add two related tables to the query design, a ____ shows the relationship between the tables.
a.
relationship line
c.
join line
b.
help line
d.
match line
 

 17. 
Another type of condition that you can create causes a record to be displayed in the query datasheet when the record matches a range of values. This is called a ____.
a.
complex condition
c.
simple condition
b.
multi-field condition
d.
range-of-values condition
 

 18. 
The ____ operator selects records that match at least one of two or more conditions in a query.
a.
Or
c.
Plus
b.
And
d.
Either
 

 19. 
The ____ operator selects records that match all of two or more conditions in a query.
a.
Or
c.
Either
b.
And
d.
Plus
 
 

FIGURE 3-1

nar001-1.jpg

Access Case 3-1
Danielle is adding a total row to a query datasheet.  Please refer to the figure above when answering the questions below.
 

 20. 
If Danielle wants to view a list of functions that are available for a field in the Total row, what should she do? 
a.
Click the arrow that appears on the left side of the field
b.
Right-click in the field to access a special field toolbar
c.
Double-click in the field
d.
none of the above
 



 
         Start Over