Multiple Choice
Identify the
letter of 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.
|
Tables,
queries, and modules are examples of Access ____. a. | Entities | b. | Controls | c. | Values | d. | Objects | | |
|
|
|
6.
|
The term
____ database comes from the fact that two or more tables are linked by a common
field. a. | Hierarchical | b. | Network | c. | Schematic | d. | Relational | | |
|
|
|
7.
|
This Access
object contains all of the raw data within the database. a. | Query | b. | Form | c. | Table | d. | Module | | |
|
|
|
8.
|
This Access
object provides an easy-to-use data entry screen. a. | Macro | b. | Module | c. | Table | d. | Form | | |
|
|
|
9.
|
An Access
module stores which type of programming code? a. | C++ | b. | Visual Basic for Applications | c. | COBOL | d. | Macros | | |
|
|
|
10.
|
In a
datasheet, which mode assumes that you are trying to change the value of a particular
field? a. | Edit
mode | b. | Navigation
mode | c. | Update
mode | d. | Form
mode | | |
|
|
|
11.
|
In the
figure above, how many records are visible?
|
|
|
12.
|
In the
figure above, how many fields are visible?
|
|
|
13.
|
This Help
menu option analyzes a database for possible data corruption. a. | Contact
Us | b. | Detect and
Repair | c. | Check for Updates | d. | Activate
Product | | |
|
|
|
14.
|
This Help
menu option provides the version and product ID of Access. a. | Microsoft Access
Help | b. | Office on
Microsoft.com | c. | About Microsoft Access | d. | Contact
Us | | |
|
|
|
15.
|
A telephone
field should be given which data type? a. | Number | b. | Currency | c. | Text | d. | AutoNumber | | |
|
|
|
16.
|
The
individual pieces of information stored in individual fields in the database are
called a. | Datasheets | b. | Objects | c. | Raw data | d. | Field types | | |
|
|
|
17.
|
Which data
type stores combinations of text and numbers up to 255 characters? a. | Text | b. | Memo | c. | Number | d. | OLE Object | | |
|
|
|
18.
|
Which data
type stores lengthy text such as comments or notes? a. | Text | b. | Memo | c. | Number | d. | Hyperlink | | |
|
|
|
19.
|
Which data
type stores quantities? a. | Text | b. | AutoNumber | c. | Yes/No | d. | Number | | |
|
|
|
20.
|
Which data
type should be used for a birthdate field? a. | Text | b. | Memo | c. | Date/Time | d. | Lookup Wizard | | |
|
|
|
21.
|
Which data
type stores only one of two values? a. | OLE Object | b. | Hyperlink | c. | Yes/No | d. | Null | | |
|
|
|
22.
|
Which data
type links files created in other programs such as pictures, sound clips, documents, or
spreadsheets? a. | Lookup | b. | OLE Object | c. | Yes/No | d. | Link Wizard | | |
|
|
|
23.
|
Which data
type stores Web addresses? a. | Lookup Wizard | b. | Hyperlink | c. | WWW Address | d. | HTML | | |
|
|
|
24.
|
Which of the
following field properties is NOT required for each field? a. | Format | b. | Field Name | c. | Data Type | d. | All are required | | |
|
|
|
|
|
|
25.
|
In the
figure above, item 6 points to the ____ button. a. | Filter | b. | Remove | c. | Add | d. | Find | | |
|
|
|
26.
|
In the
figure above, item 1 points to the ____ button. a. | Sort Ascending | b. | Sort
Descending | c. | Find | d. | Find and Replace | | |
|
|
|
27.
|
In the
figure above, item 2 points to the ____ button a. | Filter Ascending | b. | Filter
Descending | c. | Sort Ascending | d. | Sort
Descending | | |
|
|
|
28.
|
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 | | |
|
|
|
29.
|
The wildcard
character that stands for a single number digit is ____. a. | Asterisk
(*) | b. | Question mark
(?). | c. | Double quotation mark
(") | d. | Pound sign (#) | | |
|
|
|
30.
|
The wildcard
character that stands for any group of characters is the ____. a. | Period
(.) | b. | Semicolon
(;) | c. | Asterisk
(*) | d. | Plus sign
(+) | | |
|
|
|
31.
|
The wildcard
character that stands for any single character is the ____. a. | Ampersand
(&) | b. | Question mark (?) | c. | Exclamation mark
(!) | d. | Caret
(^) | | |
|
|
|
32.
|
Which of the
following comparison operators means "greater than"?
|
|
|
33.
|
Which of the
following comparison operators means "less than or equal to"?
|
|
|
34.
|
Which of the
following comparison operators means "not equal to"?
|
|
|
35.
|
To find
numbers greater than or equal to 500, use which comparison operator?
|
|
|
36.
|
To find all
records where there is any entry in the field, even if the entry is 0, use which
criteria? a. | <>0 | b. | Is Not Null | c. | *=* | d. | *<>* | | |
|
|
|
37.
|
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 | | |
|
|
|
|
|
|
38.
|
In the
figure above, item 3 points to ____. a. | The Title field | b. | A field
list | c. | The Category
field | d. | A criteria entry | | |
|
|
|
39.
|
Which
control, when "pressed" displays "yes" information? a. | Bound image
control | b. | Combo box | c. | Tab control | d. | Toggle button | | |
|
|
|
40.
|
This control
is used to provide consistent descriptive text as you navigate from record to
record. a. | Text
box | b. | Combo
box | c. | List
box | d. | Label | | |
|
|
|
41.
|
This control
is used to display, edit, or enter data for each record. It does not provide a list of possible data
entries. a. | Label | b. | Text box | c. | Combo box | d. | Command button | | |
|
|
|
42.
|
This control
displays a list of possible data entries from which the user can choose. a. | Label | b. | Text box | c. | List box | d. | Tab control | | |
|
|
|
43.
|
This control
is used to create a three-dimensional aspect to a form and to organize other
controls. a. | Command
button | b. | Toggle button | c. | Rectangle
control | d. | Tab control | | |
|
|
|
44.
|
This control
is used to display OLE data. a. | Option button | b. | Bound object
frame | c. | Unbound image control | d. | OLE
control | | |
|
|
|
45.
|
This control
provides an easy way to initiate a command or run a macro. a. | Check
box | b. | Toggle
button | c. | Command button | d. | Image
control | | |
|
|
|
46.
|
This control
is both a list box and a text box control. a. | Bound image control | b. | Unbound image
control | c. | Combo box | d. | Toggle button | | |
|
|
|
|
|
|
47.
|
In the
figure above, item 2 points to a(n) ____. a. | Option button | b. | Label | c. | Combo box | d. | List box | | |
|
|
|
48.
|
In the
figure above, item 3 points to the form's ____. a. | View buttons | b. | Record navigation
buttons | c. | Option buttons | d. | Control
buttons | | |
|
|
|
49.
|
Which type
of control would you most likely use to display first name information? a. | Text
box | b. | Label | c. | Combo box | d. | List box | | |
|
|
|
50.
|
Which of the
following would most likely be used to display a Yes/No field on a form? a. | Check
box | b. | Command
button | c. | Combo box | d. | Label | | |
|
|
|
51.
|
Click the
____ button in Form Design View to open the properties sheet for the chosen control. a. | View | b. | Open | c. | Sheet | d. | Properties | | |
|
|
|
|
|
|
52.
|
In the
figure above, item 1 points to the ____. a. | Field list | b. | Toolbox toolbar | c. | Horizontal
ruler | d. | Form View button | | |
|
|
|
53.
|
In the
figure above, item 3 points to the ____ button. a. | Toolbox | b. | Properties | c. | AutoFormat | d. | Form View | | |
|
|
|
54.
|
Which of the
following would NOT be considered a graphic image? a. | Picture | b. | Logo | c. | Text | d. | Clip art | | |
|
|
|
55.
|
Bound object
frame controls are used to display data from a field defined with what data type? a. | Text | b. | Memo | c. | Image | d. | OLE Object | | |
|
|
|
56.
|
Text boxes
bound to underlying fields are generally placed in this report section. a. | Group
Header | b. | Group Footer | c. | Report
Header | d. | Detail | | |
|
|
|
57.
|
The Report
Footer section prints ____. a. | At the end of the entire report | b. | At the bottom of every
page | c. | At the top of the
entire report | d. | At the top of every page | | |
|
|
|
58.
|
The Group
Header section prints ____. a. | At the top of the first page of the report | b. | At the top of every
page | c. | Once for every
record | d. | Before every group of records | | |
|
|
|
59.
|
The Detail
section prints ____. a. | At the top of the first page of the report | b. | At the bottom of the
every page | c. | At the end of the entire report | d. | Once for every
record | | |
|
|
|
60.
|
The Group
Footer section prints ____. a. | Before every group of records | b. | After every group of
records | c. | At the top of every page | d. | At the bottom of every
page | | |
|
|
|
61.
|
The Page
Footer section prints ____. |