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.
|
Access is part of the Microsoft Office ____ suite of programs.
a. | Basic | b. | Professional | c. | Student and
Teacher | d. | All of the above |
|
|
|
3.
|
What picture is associated with the Access program in the Start pop-up
menu?
a. | a magnifying glass | b. | an exclamation point | c. | an uppercase
A | d. | a key |
|
|
|
4.
|
A database is made up of a collection of
a. | text files. | b. | workbooks. | c. | objects. | d. | records. |
|
|
|
5.
|
What is displayed when you first start Microsoft Office 2007?
a. | the Getting Started with Microsoft Office Access screen | b. | the last database
you had open | c. | a database template | d. | a new, blank
database |
|
|
|
6.
|
To open an Access database, you can click a file name in the Open Recent
Database section of the Getting Started with Microsoft Access screen, or you can click
____ and then click Open at the drop-down list.
a. | the Office button | b. | anywhere on the desktop | c. | the Start
button | d. | Any of the above |
|
|
|
7.
|
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 |
|
|
|
8.
|
You can close Access by clicking the Close button that appears in the ____
corner of the Access screen.
a. | lower left | b. | upper left | c. | lower
right | d. | upper right |
|
|
|
9.
|
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. |
|
|
|
10.
|
The Title bar portion of the Access screen displays
a. | buttons for commonly-used commands. | b. | tabs and commands. | c. | the Zoom slider
bar. | d. | the database name followed by the program name. |
|
|
|
11.
|
Opened objects display in this part of the Access screen.
a. | work area | b. | Navigation pane | c. | ribbon | d. | message bar |
|
|
|
12.
|
If you open a database that contains potentially unsafe content, where will the
security alert display?
a. | in the Navigation pane | b. | in the Message bar | c. | in the Title
bar | d. | as a pop-up window in the middle of the screen |
|
|
|
13.
|
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 |
|
|
|
14.
|
Which of the following is not one of the types of objects contained in an
Access database?
a. | worksheet | b. | form | c. | report | d. | table |
|
|
|
15.
|
A database must contain as least one
a. | form. | b. | table. | c. | report. | d. | query. |
|
|
|
16.
|
How do you control what is displayed in the Navigation pane?
a. | by choosing an option from the drop-down list on the Menu bar | b. | by right-clicking
anywhere in the Navigation pane | c. | by clicking and dragging objects to and from
the work area | d. | by hiding or displaying individual database objects |
|
|
|
17.
|
Can the Navigation pane be closed? If so, how?
a. | Yes, by clicking the Shutter Bar Open/Close button | b. | No, the Navigation
pane is always open | c. | Yes, by clicking the Close button in the upper
right corner of the Access screen | d. | Yes, by double-clicking anywhere in the
Navigation pane |
|
|
|
18.
|
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 |
|
|
|
19.
|
With a table open in Datasheet view, the first line below the Object tab will
display the
a. | table’s field names. | b. | record navigation bar. | c. | first record of the
table. | d. | horizontal scroll bar. |
|
|
|
20.
|
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. |
|
|
|
21.
|
The process of defining a table’s structure involves
a. | assigning a data type to the table’s fields. | b. | designating a
primary key. | c. | determining the fields to be included. | d. | All of the
above |
|
|
|
22.
|
What is the first step in creating a table?
a. | name the table | b. | define a primary key | c. | determine the
fields | d. | assign a data type to each field |
|
|
|
23.
|
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. |
|
|
|
24.
|
Each field in a table must contain
a. | a name that is composed only of letters. | b. | a unique
name. | c. | data. | d. | All of the
above |
|
|
|
25.
|
How many characters can a field name contain?
|
|
|
26.
|
Which of the following characters cannot appear in a field name?
a. | grave accent (`) | b. | period (.) | c. | exclamation point
(!) | d. | All of the above |
|
|
|
27.
|
What data type should you use for a field that will store telephone
numbers?
a. | Date/Time | b. | Number | c. | Yes/No | d. | Text |
|
|
|
28.
|
How many characters can be stored in a field of the Text data type?
|
|
|
29.
|
Datasheet view is used primarily for
a. | entering data. | b. | reports. | c. | sorting
data. | d. | presenting data. |
|
|
|
30.
|
Which view do you use to define fields, data types, and descriptions?
a. | Datasheet view | b. | PivotTable view | c. | Design
view | d. | Any of the above |
|
|
|
31.
|
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 |
|
|
|
32.
|
Access automatically saves the active database
a. | on a periodic basis. | b. | when you close the table. | c. | when you close the
database. | d. | All of the above |
|
|
|
33.
|
When entering data into a table in Datasheet view, you can press ____ to move to
the next field or ____ to move to the previous field.
a. | Tab; Shift + Tab | b. | Up Arrow; Down Arrow | c. | Ctrl; Ctrl +
Tab | d. | F1; F2 |
|
|
|
34.
|
By default, what is displayed in a field that has been assigned the Yes/No data
type?
a. | an underscore (_) | b. | a square | c. | an
“X” | d. | a circle, or “radio” button |
|
|
|
35.
|
With a table open, what happens when you click the Quick Print button?
a. | The table is printed in a “shrink to fit” mode so that all the
information is contained on one page. | b. | The information in the table is sent to the
printer without any formatting changes. | c. | You are asked to choose a printer, and then the
information is sent directly to that printer. | d. | You are prompted to specify margins, page
orientation, and other formatting options. |
|
|
|
36.
|
To display a table in Print Preview, begin by clicking
a. | the Quick Print button. | b. | the Open button. | c. | the Office
button. | d. | anywhere on the table. |
|
|
|
37.
|
By default, Access prints a table
a. | in Portrait orientation. | b. | with a width of 8.5 inches. | c. | with 1 inch margins
on all sides. | d. | All of the above |
|
|
|
38.
|
If you wanted to print your table without the table name, date and page number
appearing, you would
a. | decrease the top and bottom margins. | b. | uncheck the Print Headings option at the Page
Setup dialog box. | c. | increase the top and bottom
margins. | d. | check the Print Headings option at the Page Setup dialog
box. |
|
|
|
39.
|
In Datasheet view, what happens when you select a column and double-click the
right column boundary?
a. | The column is moved to the left-most position. | b. | The data in the
column is sorted in ascending order. | c. | The column is hidden. | d. | The column is
resized to accommodate the longest entry in the field. |
|
|
|
40.
|
Which of the following is the keyboard shortcut for adding a new record to a
table?
a. | Ctrl + A | b. | Ctrl + C | c. | Ctrl + Shift +
+ | d. | Ctrl + N |
|
|
|
41.
|
What happens when you select a record and select Delete Record from the
drop-down list on the Delete button?
a. | The record is dimmed and will not appear in queries, reports, or forms, but is not
removed from the table. | b. | A message displays asking you to confirm that
you want to delete the record. | c. | The record is deleted
immediately. | d. | The record is dimmed and will be deleted when the table is
closed. |
|
|
|
42.
|
What is the keyboard shortcut for saving a database?
a. | Ctrl + S | b. | Ctrl + V | c. | Ctrl +
O | d. | Ctrl + + |
|
|
|
43.
|
The New and Delete buttons are found in the ____ group in the ____ tab.
a. | Records; Home | b. | Views; Home | c. | Other;
Create | d. | Page Layout; Print Preview |
|
|
|
44.
|
Which Quick Access toolbar button features an icon of a diskette?
a. | Save | b. | Print | c. | Open | d. | None of the
above |
|
|
|
45.
|
 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. |
|
|
|
46.
|
 Which of the fields shown here most
likely is assigned the wrong data type? a. | Postal_Code | b. | Street_Address | c. | E-Mail_Address | d. | Supplier_Number |
|
|
|
47.
|
 Which view is represented by this icon
on the drop-down list on the View button? a. | Datasheet view | b. | PivotTable view | c. | PivotChart
view | d. | Design view |
|
|
|
48.
|
 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. |
|
|
|
49.
|
 Even without seeing this table in
Design view, you can tell that the ____ field is not of either the Text or Number data type.
a. | Discontinued | b. | Units_in_Stock | c. | Product | d. | Product_Number |
|
|
|
50.
|
 Clicking the button with this icon
will allow you to
a. | print your information in Landscape orientation. | b. | change the header
and footer on your page. | c. | change the margins for your print
job. | d. | send your print job directly to your default printer. |
|