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.
|