True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
In an Access
database, you must determine how you want to sort data before you enter it.
|
|
|
2.
|
More than
one person can be entering, updating, and using an Access database at the same time.
|
|
|
3.
|
Excel lacks
many of the database advantages provided by Access.
|
|
|
4.
|
An Access
database may be as large as 200 gigabytes.
|
|
|
5.
|
Tables
contain all of the raw data in the database.
|
|
|
6.
|
Data is
physically stored in the form object.
|
|
|
7.
|
You can
print a form.
|
|
|
8.
|
An Access
module stores C++ programming code.
|
|
|
9.
|
Access
reports are used to provide Web page connectivity features to an Access database.
|
|
|
10.
|
In Access,
data entry screens are called forms.
|
|
|
11.
|
Access
information can be printed from forms, queries, and tables.
|
|
|
12.
|
Access data
can be entered through reports.
|
|
|
13.
|
If Access is
installed on a computer, you will always find a shortcut icon for it on the desktop.
|
|
|
14.
|
Once you
have used Access, you cannot return personalized toolbars to their original settings.
|
|
|
15.
|
The toolbars
and menus within Access modify themselves to reflect those features that you most commonly
use.
|
|
|
16.
|
There is
more than one way to start Access.
|
|
|
17.
|
The Database
title bar contains the filename of the active database.
|
|
|
18.
|
In
Navigation mode, Access assumes that you are trying to make changes to a field value.
|
|
|
19.
|
The
Navigation buttons on a datasheet display the total number of fields in the datasheet.
|
|
|
20.
|
Field names
appear in the top row of a datasheet.
|
|
|
21.
|
The purpose
for an AutoNumber field is to store information such as social security numbers or employee
numbers.
|
|
|
22.
|
Values in an
AutoNumber field cannot be edited.
|
|
|
23.
|
A new record
may be added on any row of a datasheet.
|
|
|
24.
|
You can move
datasheet columns by dragging the field name left or right.
|
|
|
25.
|
The New
record button is found in both the Table Datasheet toolbar and the Navigation buttons.
|
|
|
26.
|
The [Esc]
key will only affect the current record being edited.
|
|
|
27.
|
You cannot
undo a record deletion operation.
|
|
|
28.
|
You can Undo
up to 100 actions within a datasheet.
|
|
|
29.
|
You can
resize the width of the field in a datasheet.
|
|
|
30.
|
In a
datasheet, press [F5] to start the spell check feature.
|
|
|
31.
|
You can
temporarily hide a field in a datasheet.
|
|
|
32.
|
You can
print a datasheet.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
33.
|
Access 2003
can best be described as ____ software. a. | Spreadsheet | b. | Presentation | c. | Database | d. | Systems | | |
|
|
|
34.
|
Which is NOT
a feature of Access reports? a. | Multiple headers | b. | Multiple
footers | c. | Calculations on groups of records | d. | The ability to enter
data through a data entry screen | | |
|
|
|
35.
|
Which is NOT
true about Access? a. | It can be used to arrange data in a variety of
ways. | b. | It allows links between lists of
information. | c. | It is able to store any number of records up to 20
gigabytes. | d. | Multiple users can simultaneously enter and update data within
Access. | | |
|
|
|
36.
|
Which of the
following is NOT a benefit of managing data with Access versus Excel? a. | Better charting
features | b. | Higher data storage capabilities | c. | More reporting
features | d. | Multiuser capabilities | | |
|
|
|
37.
|
Which of the
following Access objects does NOT provide a way to enter data into the database? a. | Tables | b. | Queries | c. | Forms | d. | Macros | | |
|
|
|
38.
|
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 | | |
|
|
|
39.
|
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 | | |
|
|
|
40.
|
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 | | |
|
|
|
41.
|
Tables,
queries, and modules are examples of Access ____. a. | Entities | b. | Controls | c. | Values | d. | Objects | | |
|
|
|
42.
|
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 | | |
|
|
|
43.
|
This Access
object contains all of the raw data within the database. a. | Query | b. | Form | c. | Table | d. | Module | | |
|
|
|
44.
|
This Access
object provides an easy-to-use data entry screen. a. | Macro | b. | Module | c. | Table | d. | Form | | |
|
|
|
45.
|
An Access
module stores which type of programming code? a. | C++ | b. | Visual Basic for Applications | c. | COBOL | d. | Macros | | |
|
|
|
46.
|
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 | | |
|
|
|
47.
|
In
Navigation mode, press [Tab] or this keystroke to move to the next field within the same
record. a. | [End] | b. | [Page Down] | c. | [Down Arrow] | d. | [Enter] | | |
|
|
|
48.
|
Press this
keystroke combination to move focus to the first field of the first record. a. | [Alt][Ctrl][Up
Arrow] | b. | [Ctrl][Up Arrow] | c. | [Ctrl][Home] | d. | [Ctrl][Page Up] | | |
|
|
|
49.
|
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 | | |
|
|
|
|
|
|
50.
|
In the
figure above, how many records are visible?
|
|
|
51.
|
In the
figure above, how many fields are visible?
|
|
|
52.
|
Which
shortcut key moves focus to the last field of the current record? a. | [Home] | b. | [End] | c. | [Up Arrow] | d. | [F5] | | |
|
|
|
53.
|
Which
shortcut key moves focus to the first field of the current record? a. | [Home] | b. | [End] | c. | [F4] | d. | [F5] | | |
|
|
|
54.
|
While
editing a record, pressing [Esc] a second time ____. a. | Deletes the current
field | b. | Deletes the current datasheet | c. | Removes all data from
the current record | d. | Removes all changes made to the record you are currently
editing | | |
|
|
|
55.
|
Which of the
following keys will help you delete unwanted data in Edit mode? a. | [Insert] | b. | [Home] | c. | [Ctrl] | d. | [Backspace] | | |
|
|
|
56.
|
Which
keystroke combination inserts the data from the same field in the previous record into the current
field? a. | [Ctrl]['] | b. | [Ctrl][Home] | c. | [Alt]["] | d. | [Alt][F5] | | |
|
|
|
57.
|
While
editing a record, pressing [Esc] once ____. a. | Deletes the current record | b. | Deletes the current
field | c. | Removes the current field's editing changes | d. | Removes all changes
made to the record you are currently editing | | |
|
|
|
58.
|
Which
editing keystroke inserts the current date in a Date/Time field? a. | [Alt]['] | b. | [Ctrl][+] | c. | [Alt][+] | d. | [Ctrl][;] | | |
|
|
|
59.
|
Which
editing keystroke starts the spell check feature?
|
|
|
60.
|
Which
editing keystroke switches to Edit mode from Navigation mode? a. | [Esc] | b. | [Esc][Esc] | c. | [F2] | d. | [F7] | | |
|
|
|
61.
|
Which
editing keystroke deletes one character to the right of the insertion point? a. | [Backspace] | b. | [Delete] | c. | [F2] | d. | [F7] | | |
|
|
|
62.
|
Which of the
following is NOT an option in the Page Setup dialog box? a. | Footer
text | b. | Print
headings | c. | Page orientation options | d. | Margins | | |
|
|
|
63.
|
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 | | |
|
|
|
64.
|
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 | | |
|
Completion
Complete each sentence or
statement.
|
|
|
65.
|
____________________ software is used to manage data that can be organized into lists
of related information such as customers, products, vendors, employees, projects, or
sales.
|
|
|
66.
|
An Access
database is able to store any number of records up to ____________________ gigabytes.
|
|
|
67.
|
The
____________________ object provides Web pages connectivity features to an Access
database.
|
|
|
68.
|
The
____________________ object provides a professional printout of data.
|
|
|
69.
|
The
____________________ object is the most important because it contains all of the raw data within the
database.
|
|
|
70.
|
There are
seven types of ____________________ in an Access database including tables, queries, forms, and
reports.
|
|
|
71.
|
A group of
related fields that describe a person, place, or thing is called a(n)
____________________.
|
|
|
72.
|
A(n)
____________________ is a specific category of information in a database such as a customer's name,
city, state, or phone number.
|
|
|
73.
|
A(n)
____________________ is a collection of information associated with a topic (for example, sales of
products to customers).
|
|
|
74.
|
A(n)
____________________ field is a field that contains unique information for each record.
|
|
|
75.
|
A(n)
____________________ object provides a spreadsheet-like view of the data with a subset of fields or
records from one or more tables.
|
|
|
76.
|
A(n)
____________________ object provides an easy-to-use data entry screen.
|
|
|
77.
|
A(n)
____________________ object stores programming code.
|
|
|
78.
|
An Access
database is called a ____________________ database because more than one table can share information
through a common linked field.
|
|
|
79.
|
A(n)
____________________ object stores a collection of keystrokes or commands.
|
|
|
|
|
|
80.
|
In the
figure above, item 1 points to the ____________________ bar.
|
|
|
81.
|
In the
figure above, the ____________________ Objects button is chosen.
|
|
|
82.
|
In the
figure above, item 2 points to the ____________________ toolbar.
|
|
|
83.
|
In the
figure above, item 5 points to the types of Access ____________________.
|
|
|
84.
|
The
____________________ window provides access to the objects within the database.
|
|
|
85.
|
A(n)
____________________ is a spreadsheet-like grid that displays a table's fields and
records.
|
|
|
86.
|
When you
move around the fields and records of a datasheet but do not change data, you are working in
____________________ mode.
|
|
|
87.
|
When you
change data within a datasheet, you are working in ____________________ mode.
|
|
|
88.
|
The
____________________ name appears in the first row of a datasheet.
|
|
|
|
|
|
89.
|
____________________ total records are in the datasheet shown in the figure
above.
|
|
|
90.
|
The
____________________ field has the focus in the datasheet shown in the figure above.
|
|
|
91.
|
In the
figure above, the ____________________ table is being viewed.
|
|
|
92.
|
In the
figure above, the ____________________ object is being viewed.
|
|
|
93.
|
In the
figure above, Category ID, Category Name, and Description are examples of ____________________
names.
|
|
|
94.
|
In the
figure above, record number ____________________ is the current record.
|
|
|
|
|
|
95.
|
The name of
the table shown in the figure above is ____________________.
|
|
|
96.
|
A(n)
____________________ field automatically assigns a new number each time you add a
record.
|
|
|
97.
|
When you are
editing a record, the edit record symbol, which looks like a small ____________________, appears in
the record selector box to the left of the current record.
|
|
|
98.
|
The Hide
Columns option is found on the ____________________ menu.
|