Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
Which of the following types of business data can be managed with Access?
a. | names and addresses | b. | product data | c. | purchasing and
buying data | d. | All of the above |
|
|
|
2.
|
A database is made up of a collection of
a. | text files. | b. | workbooks. | c. | objects. | d. | records. |
|
|
|
3.
|
How many Access database can you have open at one time?
a. | one | b. | as many as your computer’s memory will
allow | c. | five | d. | twenty |
|
|
|
4.
|
The area of the Access screen that is divided into groups of tabs and commands
is called the
a. | ribbon. | b. | Title bar. | c. | Status
bar. | d. | Navigation pane. |
|
|
|
5.
|
What does the Navigation pane at the left side of the Access screen
display?
a. | a list of commonly-used commands | b. | a list of recently-opened
databases | c. | the objects that are contained in the database | d. | All of the
above |
|
|
|
6.
|
A database must contain as least one
a. | form. | b. | table. | c. | report. | d. | query. |
|
|
|
7.
|
Can more that one object be open in the work area at one time? If so, how
are the objects displayed?
a. | Yes, each object is displayed in its own tab | b. | Yes, the objects are
displayed side by side in the work area | c. | No, only one object can be open at a time in
the work area | d. | Yes, the work area is split horizontally with objects stacked on top of each
other |
|
|
|
8.
|
When a table is displayed in Datasheet view, each column represents a
a. | field in the table. | b. | record in the table. | c. | unique
value. | d. | query. |
|
|
|
9.
|
If a field is one piece of information about a person, place, or item, then all
the fields for one unit make up a
a. | table. | b. | query. | c. | record. | d. | database. |
|
|
|
10.
|
What data type should you use for a field that will store telephone
numbers?
a. | Date/Time | b. | Number | c. | Yes/No | d. | Text |
|
|
|
11.
|
When creating a new table, by default Access provides the ____ field as the
first field and assigns it the ____ data type.
a. | Name; Text | b. | Description; Text | c. | ID;
AutoNumber | d. | Sequence; Number |
|
|
|
12.
|
 This images shows a
a. | Query in Design view. | b. | Form based on a table. | c. | table in Datasheet
view. | d. | table in Design view. |
|
|
|
13.
|
 Notice that the mouse pointer in this
picture is situated between two columns and has changed to a double-headed arrow. What will
happen if the user double-clicks the left mouse button?
a. | The Street_Address field will be sorted in descending
order. | b. | The Street_Address field will be resized to accommodate the longest
entry. | c. | The Supplier_Name field will be hidden. | d. | The
Supplier_Name field will be resized to accommodate the longest
entry. |
|
|
|
14.
|
A relational database management system eliminates the need for
a. | sequential processing. | b. | multiple tables. | c. | indexes. | d. | data
redundancy. |
|
|
|
15.
|
The ability to relate, or ____ tables is part of what makes Access a relational
database system.
a. | join | b. | merge | c. | append | d. | parse |
|
|
|
16.
|
A primary key field ____ contain the same value for different records.
a. | cannot | b. | can | c. | must | d. | should |
|
|
|
17.
|
When a relationship is established between two tables, the primary key in one
table is joined to the ____ key in the other table.
a. | foreign | b. | client | c. | subordinate | d. | secondary |
|
|
|
18.
|
How does joining tables help ensure data integrity?
a. | by automatically checking for misspelled words | b. | by ensuring
sequential values in the primary key field | c. | by forcing a record to be in the primary table
(e.g., Customers) before it can be entered into a related table (e.g.,
Orders) | d. | All of the above |
|
|
|
19.
|
In a one-to-many relationship, which table would contain the foreign key for the
relationship?
a. | both primary and related tables | b. | primary table | c. | neither primary nor
related tables | d. | related table |
|
|
|
20.
|
In the Relationships window, what symbol or character signifies the
“many” side of a one-to-many relationship?
a. | the infinity symbol (¥) | b. | the number one (1) | c. | an exclamation point
(!) | d. | the number one thousand (1,000) |
|
|
|
21.
|
In one-to-many relationships, the ____ is identified as the “one”
and the ____ is identified as the “many.”
a. | primary key; foreign key | b. | smaller field; larger field | c. | larger field;
smaller field | d. | foreign key; primary key |
|
|
|
22.
|
To display subdatasheets for all the records in your primary table, begin by
clicking the
a. | expand indicator for the first record in the table. | b. | More button in the
Records group in the Home tab. | c. | Filter button in the Sort & Filter group in
the Home tab. | d. | Table tab in the work area. |
|
|
|
23.
|
 This image is part of
a. | a Table Design view. | b. | the Relationships window. | c. | the Edit
Relationships dialog box. | d. | a subdatasheet. |
|
|
|
24.
|
 What type of relationship is
illustrated in this picture?
a. | one-to-many | b. | one-to-one | c. | many-to-many | d. | indeterminate |
|
|
|
25.
|
 Which field in this illustration would
be considered the foreign key?
a. | ClientNumber in the Clients table | b. | Client in the
Clients table | c. | ClaimNumber in the Claims
table | d. | ClientNumber in the Claims table |
|