Name: 
 

IC3 - Lesson 22



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

 1. 

____ is the shortcut key combination that displays the Find dialog box.
a.
Alt + F
c.
Shift + F4
b.
Shift + F
d.
Ctrl + F
 

 2. 

To find multiple records containing the same value in one or more fields, you would create a ____.
a.
sort
c.
find
b.
query
d.
report
 

 3. 

To quickly change all dates of 4/13/01 to 4/13/02 in an Access table, use the ____ command.
a.
Sort
c.
Query
b.
Replace
d.
Find
 

 4. 

____ orientation formats the report with the long edge of the page at the top.
a.
Portrait
c.
Landscape
b.
Normal
d.
Wide
 

 5. 

If you want to search an entire database, select the database table name in the ____ box.
a.
Match
c.
Search
b.
Find
d.
Look In
 

 6. 

If you want Access to locate any book title that contains the word “Cycling,” make sure the Match box contains ____.
a.
Match Exactly
c.
Start of Field
b.
Whole Field
d.
Any Part of Field
 

 7. 

A ____ is a database object that allows you to organize, summarize, and print all or a portion of the data in a database.
a.
report
c.
query
b.
table
d.
form
 

 8. 

The arrangement of rows and columns at the bottom of the query window is called the ____ grid.
a.
query
c.
field
b.
design
d.
criteria
 

 9. 

You can create a report based on a ____.
a.
query
c.
form
b.
table
d.
either a or b
 

 10. 

To locate a specific name in the Last Name field of a table, use the ____ command.
a.
Query
c.
Find
b.
Report
d.
Sort
 

 11. 

The box containing the field name at the top of the column in Datasheet view is also a ____ you can use to select the column.
a.
header box
c.
column selector
b.
field selector
d.
both a and b
 

 12. 

One way to restore the original order of records after performing a sort is to use the ____ command.
a.
Display All Records
c.
Restore Order
b.
Remove Sort
d.
Remove Filter/Sort
 

 13. 

To rearrange database files in Datasheet view, you select the ____ containing the fields and then drag them to a new location.
a.
entries
c.
rows
b.
columns
d.
queries
 

 14. 

When you use the Report Wizard, you can select ____.
a.
a sorting order for the data
c.
a grouping level for the data
b.
what fields to display
d.
all of the above
 

 15. 

A series of dialog boxes that guides you through creation of a form or report is called a ____.
a.
Step-by-Step
c.
Datasheet
b.
Wizard
d.
none of the above
 

Completion
Complete each sentence or statement.
 

 16. 

To add a new record in a data-entry form, you can click the ____________________ button in the navigation bar at the bottom of the form.
 

 

 17. 

The Access feature that enables you to find multiple records matching specified criteria is a(n) ____________________.
 

 

 18. 

If you perform a(n) ____________________ sort on the Zip field in an Access table, 45299 would appear before 42101.
 

 

 19. 

Mailing labels are created in Access as a type of ____________________.
 

 

 20. 

Although you can create a form manually, you also can use the ____________________ to guide you through the process of creating a data-entry form.
 

 

 21. 

You can move through a database or form using the navigation buttons, or you can use the ____________________ bars to navigate with the mouse.
 

 

 22. 

The ____________________ of a report determines how it will print on the page.
 

 

 23. 

To easily create mailing labels, select the ____________________ Wizard in the New Report dialog box.
 

 

 24. 

You sort records in ____________________ view.
 

 

 25. 

You can use the ____________________ command to reverse a replacement made with the Replace feature, but you must issue the command before you edit another record.
 

 

 26. 

The ____________________ command locates the search text and replaces it with new text that you specify.
 

 

 27. 

The ____________________ command provides a fast way to locate specific records or find certain values within fields quickly.
 

 

 28. 

A(n) ____________________ provides a way for you to ask a question about information stored in a database table.
 

 

 29. 

Access will search for the text and values that were entered in the Find What box for the last search when you press the ____________________ shortcut key combination.
 

 

 30. 

To print a list that includes the last name and telephone number of every member of a club from a database that includes complete member contact information, you would create a(n) ____________________.
 

 

 31. 

In the Report Wizard’s Title dialog box, you can also choose to ____________________ the report before you print it to make sure it is set up the way you want.
 

 

 32. 

To include a field in a report in the Report Wizard dialog box, you select the field name in the Available Fields list and then click the ____________________ button to move the field name to the Selected Fields list.
 

 

 33. 

The Find command in Access is located on the ____________________ menu.
 

 

 34. 

A(n) ____________________ offers another way to enter data in a table in Access.
 

 

 35. 

A(n) ____________________ sort will place a list of names in alphabetical order.
 

 

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

 36. 

You use a Wizard to create mailing labels.
 

 37. 

Creating a form does not add a new object to the database.
 

 38. 

If you want to rearrange the fields in Datasheet view, you can drag them to a new location.
 

 39. 

You must base a query on a form in the database.
 

 40. 

If you performed an ascending sort on the Date field, 3/14/08 would be at the top of the column and 3/14/07 would be at the bottom of the column.
 

 41. 

You cannot edit an existing record in a form; you must open the record in Datasheet view in order to edit it.
 

 42. 

The only way to create a report is to use the Report Wizard.
 

 43. 

When you create mailing labels, you create a report object.
 

 44. 

A report looks just the same when printed as when you print a table from Datasheet view.
 

 45. 

To specify that a query display only records where last names are “Schmidt,” you would key “Schmidt” in the Criteria row.
 

 46. 

You can use toolbar buttons to sort any field in ascending or descending order.
 

 47. 

You can create a report based on a table or a query.
 

 48. 

If you sort the Purchase Price field in descending order, $4,500 will be at the top of the column and $210 will be at the bottom of the column.
 

 49. 

The navigation buttons at the bottom of a form are the same buttons as those available in Datasheet view.
 

 50. 

You can use the Undo command if you change your mind after sorting a table.
 



 
Check Your Work     Reset Help