Exam
Name___________________________________
MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1)
To rename a table, you can
1)
A)
open Windows Explorer.
B)
click the Database Tools tab on the Ribbon.
C)
right–click the table name in the Navigation Pane.
D)
click Save As from the File menu.
Answer:
C
A)
B)
C)
D)
2)
Good database design does NOT include
2)
A)
techniques that assure accurate data entry.
B)
ensuring that the same data isn’t stored in more than one place.
C)
applying rules that ensure the database will perform as expected.
D)
accessible coding so that users can alter the structure of the database.
Answer:
D
A)
B)
C)
D)
3)
When data in a table becomes redundant,
3)
A)
it is usually an indication that you need a new table to contain information about the topic.
B)
the field sizes should be reduced.
C)
additional fields should be created in the same table.
D)
delete the redundant records.
Answer:
A
A)
B)
C)
D)
4)
One purpose of a form is to
4)
A)
organize your database objects.
B)
retrieve specific data from one or more tables.
C)
simultaneously display the fields and records from a table in an easy–to–read format.
D)
simplify data entry in a table
Answer:
D
A)
B)
C)
D)
1
5)
When importing data from an Excel workbook, you may NOT
5)
A)
append a copy of the records to an open, active table.
B)
import the data into a new table in the current database.
C)
link the data to a linked table.
D)
append a copy of the records to an existing table.
Answer:
A
A)
B)
C)
D)
6)
The Access view that displays the table data in columns and rows is called
6)
A)
Design view.
B)
Datasheet view.
C)
Database view.
D)
Data Object view.
Answer:
B
A)
B)
C)
D)
7)
A flat database
7)
A)
cannot have a primary key.
B)
has no added data.
C)
is not related to any other collection of data.
D)
must have less than five fields.
Answer:
C
A)
B)
C)
D)
8)
The process of creating a query involves
8)
A)
choosing the table(s) and selecting the fields you want to include in the query result.
B)
choosing the report(s) and selecting the fields you want to include in the query result.
C)
choosing the record(s) and selecting the fields you want to include in the query result.
D)
choosing the form(s) and selecting the fields you want to include in the query result.
Answer:
A
A)
B)
C)
D)
9)
The most common database objects are
9)
A)
tables, queries, and macros.
B)
macros, tables, and forms.
C)
tables, forms, and reports.
D)
tables, forms, and relationships.
Answer:
C
A)
B)
C)
D)
2
10)
To organize your database objects you must use the
10)
A)
object window.
B)
table template.
C)
simple select query.
D)
Navigation Pane.
Answer:
D
A)
B)
C)
D)
11)
Which of the following is NOT a benefit of avoiding redundancy in a database?
11)
A)
Prevents unauthorized manipulation of data
B)
User doesn’t have to remember where data is stored
C)
Reduces errors
D)
Conserves space
Answer:
A
A)
B)
C)
D)
12)
In Microsoft Access, all data is stored in one or more
12)
A)
tables.
B)
queries.
C)
macros.
D)
forms.
Answer:
A
A)
B)
C)
D)
13)
The table Design view shows
13)
A)
the number of records in the table.
B)
the formatting applied to the table.
C)
the relationships established for the table.
D)
the structure of the table.
Answer:
D
A)
B)
C)
D)
14)
Each table row contains all the categories of data pertaining to one entity and is called a
14)
A)
record.
B)
query.
C)
database.
D)
field.
Answer:
A
A)
B)
C)
D)
3
15)
Which of the following is a good candidate for a primary key?
15)
A)
A student ID in a college registration database.
B)
A street name in an address database
C)
A postal code in an address database
D)
A car model in a Motor Vehicle Department database
Answer:
A
A)
B)
C)
D)
16)
When you delete a field,
16)
A)
you can undo the action.
B)
if you do so by mistake, you must repopulate every record.
C)
you send the data to the Recycle Bin.
D)
Access will delete it without asking whether you are sure.
Answer:
B
A)
B)
C)
D)
17)
The Caption property
17)
A)
allows additional information to display below the field name.
B)
displays a name for a field other than the field name.
C)
alters the name used in the Query Wizard.
D)
prohibits spaces within a field name.
Answer:
B
A)
B)
C)
D)
18)
Which of the following does NOT happen when you close an Access database?
18)
A)
You’ll be prompted to save changes to table structure.
B)
The Access window will automatically close.
C)
Access will remember whether the Navigation Pane is open or closed.
D)
Records are saved automatically.
Answer:
B
A)
B)
C)
D)
19)
A database object that retrieves specific data from one or more tables is a
19)
A)
table.
B)
query.
C)
form.
D)
report.
Answer:
B
A)
B)
C)
D)
4
20)
To create a query using the Simple Query Wizard, you choose the data source and
20)
A)
records.
B)
field names.
C)
objects.
D)
data types.
Answer:
B
A)
B)
C)
D)
21)
Headers and footers for Microsoft Access tables and queries
21)
A)
contain the date and page number in the footer.
B)
contain only the object name in the header.
C)
are editable by clicking into the header/footer area while in Print Preview.
D)
are controlled by default settings and cannot be edited.
Answer:
D
A)
B)
C)
D)
22)
A query is a database object that
22)
A)
can select its data from tables, other queries, or reports.
B)
edits data.
C)
summarizes data in a professional–looking manner.
D)
retrieves specific data from one or more database tables or queries.
Answer:
D
A)
B)
C)
D)
23)
One purpose of a report is to
23)
A)
organize your database objects.
B)
display the fields and records from a table in an easy–to–read format.
C)
simplify data entry in a table.
D)
retrieve specific data from one or more tables.
Answer:
B
A)
B)
C)
D)
24)
Which view allows you to make quick changes to a report prior to printing it?
24)
A)
Layout view
B)
Print Preview
C)
Report view
D)
Final view
Answer:
A
A)
B)
C)
D)
5
25)
An Access record is saved when you
25)
A)
move to the next record.
B)
press Save on the File tab on the Ribbon.
C)
close the database.
D)
save the table in which it was created.
Answer:
A
A)
B)
C)
D)
26)
When creating a new table, Access does NOT
26)
A)
assign the ID field as the primary key.
B)
format the first field as Autonumber.
C)
create a first field called ID.
D)
prevent the user from modifying the ID field.
Answer:
D
A)
B)
C)
D)
27)
The advantage of using a template when starting a new database is that
27)
A)
little thought need go into the creation of the database.
B)
templates need no modifications to be useful.
C)
database objects are already created.
D)
formats are already set and cannot be modified.
Answer:
C
A)
B)
C)
D)
28)
Raw data that has been organized so as to become useful is also known as
28)
A)
normalized data.
B)
a query.
C)
information.
D)
facts.
Answer:
C
A)
B)
C)
D)
29)
To view a table in Design view:
29)
A)
in the Views group, click the View button and click Design View.
B)
on the Quick Access Toolbar, click Design View.
C)
in the Navigation Pane, click Design View.
D)
in the Preview group, click the View button arrow and click Design View.
Answer:
A
A)
B)
C)
D)
6
30)
Before populating a table, which is the correct sequence of steps?
30)
A)
Create the table, design the table, name the table, save and name the database.
B)
Create the database, create the table, design the table, save and name the database.
C)
Design the table, name the table, save the database.
D)
Create and name the database, save the database, create and name the table.
Answer:
D
A)
B)
C)
D)
31)
Which of the following is NOT a characteristic of the Currency data type?
31)
A)
This data type can be used in mathematical calculations.
B)
Data must be displayed with two decimal places.
C)
Access automatically displays a dollar sign ($).
D)
Data is calculated with one to four decimal places.
Answer:
B
A)
B)
C)
D)
SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question.
32)
A Microsoft Access 2010 database has the file extension ________.
32)
Answer:
.accdb
33)
In the Navigation Pane, the view that groups a query with the table on which it is based is
called ________.
33)
Answer:
Tables and Related Views
34)
Table objects are the foundation of a database because tables store the actual data in the
form of ________.
34)
Answer:
records
35)
The characteristic that defines the kind of data that can be entered into a field, such as
numbers, text, or dates, is the ________.
35)
Answer:
data type
36)
A type of query that retrieves data from one or more tables and makes it available for use
in the format of a datasheet is a(n) ________ query.
36)
Answer:
select
7