Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
Access 2003 can best be described as ____ software.
a. | Spreadsheet | b. | Presentation | c. | Database | d. | Systems |
|
|
|
2.
|
A specific category of data such as a customer's name, city, state, or
phone number is called a(n) ____.
a. | Object | b. | Record | c. | Field | d. | Table |
|
|
|
3.
|
A group of related fields, such as all the demographic information for one
customer, is called a(n) ____.
a. | Record | b. | Table | c. | Database | d. | Object |
|
|
|
4.
|
A collection of records for a single subject, such as all of the customer
records, is called a(n) ____.
a. | Table | b. | Control | c. | Element | d. | Object |
|
|
|
5.
|
A(n) ____ is a collection of information associated with a topic such as sales
of products to customers.
a. | Database | b. | Field | c. | Record | d. | Object |
|
|
|
|
|
|
6.
|
In the figure above, how many records are visible?
|
|
|
7.
|
In the figure above, how many fields are visible?
|
|
|
8.
|
A zip code field should be given which data type?
a. | Alphanumeric | b. | Text | c. | Numeric | d. | AutoNumber |
|
|
|
9.
|
Which data type stores combinations of text and numbers up to 255
characters?
a. | Text | b. | Memo | c. | Number | d. | OLE Object |
|
|
|
10.
|
Which data type stores quantities?
a. | Text | b. | AutoNumber | c. | Yes/No | d. | Number |
|
|
|
11.
|
Which data type should be used for a birthdate field?
a. | Text | b. | Memo | c. | Date/Time | d. | Lookup Wizard |
|
|
|
|
|
|
12.
|
In the figure above, item 1 points to the ____ button.
a. | Sort Ascending | b. | Sort Descending | c. | Find | d. | Find and
Replace |
|
|
|
13.
|
In the figure above, item 2 points to the ____ button
a. | Filter Ascending | b. | Filter Descending | c. | Sort
Ascending | d. | Sort Descending |
|
|
|
14.
|
The wildcard character that stands for any group of characters is the
____.
a. | Period (.) | b. | Semicolon (;) | c. | Asterisk
(*) | d. | Plus sign (+) |
|
|
|
15.
|
Which of the following comparison operators means "less than or equal
to"?
|
|
|
|
|
|
16.
|
The table in the figure above, is shown in ____ view.
a. | Datasheet | b. | Object | c. | Update | d. | Design |
|
|
|
17.
|
Which of the following field properties is NOT required for each field?
a. | Format | b. | Field Name | c. | Data
Type | d. | All are required |
|
|
|
18.
|
This button searches for a string of characters in the current field or all
fields.
a. | Find | b. | Sort Ascending | c. | Filter By
String | d. | Filter By Criteria |
|
|
|
19.
|
A(n) ____ is a temporary view of the data whose criteria is discarded when you
close the datasheet.
a. | Query | b. | Filter | c. | Find | d. | Union |
|
|
|
|
|
|
20.
|
In the figure above, item 3 points to ____.
a. | The Title field | b. | A field list | c. | The Category
field | d. | A criteria entry |
|