True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
You can use the Undo command if you change your mind after sorting a
table.
|
|
|
2.
|
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.
|
|
|
3.
|
You can use toolbar buttons to sort any field in ascending or descending
order.
|
|
|
4.
|
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.
|
|
|
5.
|
You must base a query on a form in the database.
|
|
|
6.
|
To specify that a query display only records where last names are
“Schmidt,” you would key “Schmidt” in the Criteria row.
|
|
|
7.
|
You can create a report based on a table or a query.
|
|
|
8.
|
A report looks just the same when printed as when you print a table from
Datasheet view.
|
|
|
9.
|
The only way to create a report is to use the Report Wizard.
|
|
|
10.
|
You use a Wizard to create mailing labels.
|
|
|
11.
|
When you create mailing labels, you create a report object.
|
|
|
12.
|
If you want to rearrange the fields in Datasheet view, you can drag them to a
new location.
|
|
|
13.
|
Creating a form does not add a new object to the database.
|
|
|
14.
|
The navigation buttons at the bottom of a form are the same buttons as those
available in Datasheet view.
|
|
|
15.
|
You cannot edit an existing record in a form; you must open the record in
Datasheet view in order to edit it.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
16.
|
One way to restore the original order of records after performing a sort is to
use the ____ command.
a. | Remove Filter/Sort | c. | Remove Sort | b. | Restore Order | d. | Display All
Records |
|
|
|
17.
|
To locate a specific name in the Last Name field of a table, use the ____
command.
a. | Sort | c. | Query | b. | Find | d. | Report |
|
|
|
18.
|
If you want Access to locate any book title that contains the word
“Cycling,” make sure the Match box contains ____.
a. | Whole Field | c. | Any Part of Field | b. | Start of Field | d. | Match Exactly |
|
|
|
19.
|
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. | Find | d. | Replace |
|
|
|
20.
|
To find multiple records containing the same value in one or more fields, you
would create a ____.
a. | sort | c. | query | b. | find | d. | report |
|
|
|
21.
|
The arrangement of rows and columns at the bottom of the query window is called
the ____ grid.
a. | design | c. | field | b. | query | d. | criteria |
|
|
|
22.
|
When you use the Report Wizard, you can select ____.
a. | what fields to display | c. | a sorting order for the data | b. | a grouping level for
the data | d. | all of the
above |
|
|
|
23.
|
A ____ is a database object that allows you to organize, summarize, and print
all or a portion of the data in a database.
a. | form | c. | report | b. | query | d. | table |
|
|
|
24.
|
____ orientation formats the report with the long edge of the page at the
top.
a. | Portrait | c. | Normal | b. | Wide | d. | Landscape |
|
|
|
25.
|
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 |
|
|
|
26.
|
____ is the shortcut key combination that displays the Find dialog box.
a. | Shift + F | c. | Alt + F | b. | Shift + F4 | d. | Ctrl + F |
|
|
|
27.
|
If you want to search an entire database, select the database table name in the
____ box.
a. | Search | c. | Find | b. | Look In | d. | Match |
|
|
|
28.
|
You can create a report based on a ____.
a. | table | c. | form | b. | query | d. | either a or b |
|
|
|
29.
|
To rearrange database files in Datasheet view, you select the ____ containing
the fields and then drag them to a new location.
a. | entries | c. | columns | b. | rows | d. | queries |
|
|
|
30.
|
A series of dialog boxes that guides you through creation of a form or report is
called a ____.
a. | Datasheet | c. | Step-by-Step | b. | Wizard | d. | none of the
above |
|
Completion
Complete each
statement.
|
|
|
31.
|
The Access feature that enables you to find multiple records matching specified
criteria is a(n) ____________________.
|
|
|
32.
|
The ____________________ command locates the search text and replaces it with
new text that you specify.
|
|
|
33.
|
A(n) ____________________ provides a way for you to ask a question about
information stored in a database table.
|
|
|
34.
|
If you perform a(n) ____________________ sort on the Zip field in an Access
table, 45299 would appear before 42101.
|
|
|
35.
|
The ____________________ command provides a fast way to locate specific records
or find certain values within fields quickly.
|
|
|
36.
|
The ____________________ of a report determines how it will print on the
page.
|
|
|
37.
|
Although you can create a form manually, you also can use the
____________________ to guide you through the process of creating a data-entry form.
|
|
|
38.
|
A(n) ____________________ offers another way to enter data in a table in
Access.
|
|
|
39.
|
Mailing labels are created in Access as a type of
____________________.
|
|
|
40.
|
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.
|
|
|
41.
|
A(n) ____________________ sort will place a list of names in alphabetical
order.
|
|
|
42.
|
You can move through a database or form using the navigation buttons, or you can
use the ____________________ bars to navigate with the mouse.
|
|
|
43.
|
The Find command in Access is located on the ____________________ menu.
|
|
|
44.
|
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.
|
|
|
45.
|
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.
|
|
|
46.
|
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.
|
|
|
47.
|
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.
|
|
|
48.
|
To easily create mailing labels, select the ____________________ Wizard in the
New Report dialog box.
|
|
|
49.
|
You sort records in ____________________ view.
|
|
|
50.
|
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)
____________________.
|