Name:     ID: 
 
Email: 

Access Chapter One

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 1. 

Access is a ____.
a.
word processing software tool
c.
workbook management system
b.
file management system
d.
database management system
 

 2. 

A(n) ____ contains information about a given person, product, or event.
a.
attribute
c.
field
b.
record
d.
column
 

 3. 

Database ____ refers to the arrangement of data into tables and fields.
a.
language
c.
design
b.
relations
d.
management
 

 4. 

A field whose data type is ____ can contain any characters.
a.
Alpha
c.
Normal
b.
Text
d.
Lookup
 

 5. 

In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a ____ .
a.
container
c.
placeholder
b.
repository
d.
database
 

 6. 

When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.
a.
Field1
c.
AutoCode
b.
ID
d.
TableCode
 

 7. 

To undo the most recent change to a table structure, click the ____ button on the Quick Access Toolbar.
a.
Cancel
c.
Back
b.
Escape
d.
Undo
 

 8. 

To delete a field in a table, right-click the column heading for the field, and then click ____ on the shortcut menu.
a.
Delete Field
c.
Delete Column
b.
Remove Field
d.
Remove Column
 

 9. 

To change the name of a field, right-click the column heading for the field, click ____ on the shortcut menu, and then type the desired field name.
a.
Rename Field
c.
Change Field
b.
Rename Column
d.
Change Column
 

 10. 

To insert a field between existing fields, right-click the column heading for the field that will follow the new field, and then click ____ on the shortcut menu.
a.
Insert Field
c.
Add Field
b.
Insert Column
d.
Add Column
 

 11. 

To open a table in Design view, right-click the table in the Navigation Pane and then click ____ on the shortcut menu
a.
Table Design
c.
Structure View
b.
Design View
d.
Layout View
 

 12. 

To delete a record, click the record selector for the record, and then press the ____ key(s).
a.
CTRL+DELETE
c.
DELETE
b.
CTRL+Y
d.
CTRL+K
 

 13. 

To change the print orientation from portrait to landscape, click the ____ button on the Print Preview tab.
a.
Portrait/Landscape
c.
Landscape
b.
Orientation
d.
Switch Orientation
 

 14. 

To import data to a table, click the ____ tab on the Ribbon.
a.
Database Tools
c.
Import
b.
File
d.
External Data
 

 15. 

To open the Navigation Pane, click the ____ Button.
a.
Open Navigation Pane
c.
Open Pane
b.
Shutter Bar Open/Close
d.
Navigation Bar Show/Hide
 

 16. 

To create a query using the Query Wizard, click ____ on the Ribbon and then click the Query Wizard button.
a.
Insert
c.
Create
b.
New Object
d.
Report
 

 17. 

To change the design of a query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.
a.
Open
c.
SQL
b.
Query Window
d.
Design View
 

 18. 

To create an initial report that can be modified in Layout view, click ____ on the Create tab.
a.
Layout
c.
Report Layout
b.
Report
d.
Simple Report
 

 19. 

To compact and repair a database, click the ___ button in the Information gallery in the Backstage view.
a.
Restore
c.
Compaction
b.
Fix
d.
Compact & Repair
 

 20. 

To back up a database, use the Back Up Database command on the ____ tab in the Backstage view.
a.
Save Object As
c.
Tools
b.
Save & Publish
d.
Options
 



 
         Start Over