Name:     ID: 
 
    Email: 

PracticeMidTerm

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

 1. 
Operators specified as selection criteria in a query, such as equal, not equal, or greater than, are known as ____ operators.
a.
comparison
b.
selection
c.
indexed
d.
optional
 
 
midtermpractice_files/i0030000.jpg

Figure 3-13
 

 2. 
Sharon has just run the query whose results are shown in Figure 3-13. Now she wants to view the data sorted in descending order by employer name and has just established that field as the current field. Her next step is to ____.
a.
click the button shown as item 1
b.
click the button shown as item 2
c.
click the button shown as item 3
d.
start the Sort Wizard
 

 3. 
After applying a filter, you can click the ____ button to toggle between filtered and nonfiltered displays.
a.
Run
b.
View All
c.
Remove Filter
d.
Toggle View
 

 4. 
To divide records into groups based on the values in a specified field you would use the ____ operator.
a.
Group Subset
b.
Group By
c.
Group Range
d.
Logical Group
 

 5. 
When creating a form accessing data from two tables, Access uses the defined ____ to join the tables.
a.
referential integrity
b.
primary keys
c.
foreign keys
d.
relationship
 

 6. 
After you have clicked Forms in the Objects bar of the Database window, you can create a new form by clicking the New button in the ____ window.
a.
Database
b.
Forms
c.
Object
d.
Datasheet
 

 7. 
The ____ comparison operator lets you define a condition with two or more values.
a.
Like
b.
In
c.
As
d.
Or
 

 8. 
The ____ logical operator negates a criterion.
a.
Nor
b.
Or
c.
Not
d.
Nand
 

 9. 
In the Input Mask Wizard, the practice area is called the ____ text box.
a.
Sample
b.
Try It
c.
Practice
d.
Experiment
 

 10. 
Access detects ____ validation rule violations immediately after you finish all changes to the current record and advance to another record.
a.
field
b.
row
c.
record
d.
table
 



 
Submit          Reset Help