Name: 
 

Computer Literacy Module 2 Lesson 21



True/False
Indicate whether the sentence or statement is true or false.
 

 1. 

An Access table resembles a worksheet because it is set up in rows and columns.
 

 2. 

A database can contain all types of data such as lists, schedules, inventories, and addresses.
 

 3. 

Access does not have a standard document view.
 

 4. 

Everything you do in a database relies on the data stored in the tables.
 

 5. 

A database can contain only one table.
 

 6. 

Design view displays the field names and what kind of values you can enter in each field.
 

 7. 

You can define or modify field formats in Datasheet view.
 

 8. 

The field properties available depend on the data type selected.
 

 9. 

The default field size is 250 characters.
 

 10. 

Generally, once you enter data in a database, you do not have to update it.
 

 11. 

You can use the Undo command to reverse changes only until you begin editing another record.
 

 12. 

After you delete a record from an Access table, you cannot use the Undo command to restore it.
 

 13. 

You use the Save As command to save an Access database with a new filename.
 

 14. 

You can add new records anywhere in a table.
 

 15. 

When you delete a record, Access will display a message to warn you about the deletion.
 

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

 16. 

A ____ is a way to ask questions about the information stored in the table.
a.
form
c.
macro
b.
query
d.
none of the above
 

 17. 

All other database objects rely on the existence of the ____.
a.
query
c.
table
b.
form
d.
macro
 

 18. 

A ____ is an Access feature that makes it easy to enter data.
a.
form
c.
table
b.
query
d.
report
 

 19. 

A single piece of information, such as a first name, is a ____.
a.
field
c.
property
b.
data type
d.
record
 

 20. 

A ____ is a group of related fields in a database.
a.
field key
c.
record
b.
primary key
d.
datasheet record
 

 21. 

Each column in a table is labeled with a ____.
a.
column name
c.
field
b.
record header
d.
field name
 

 22. 

To move the insertion point down to the same field in the next record, press ____.
a.
PageDown
c.
End
b.
Ctrl + D
d.
down arrow key
 

 23. 

When you enter data into a cell, it is called a(n) ____.
a.
record
c.
entry
b.
field
d.
field name
 

 24. 

The Home key moves the insertion point to the ____.
a.
first cell in the table
c.
last field in the current record
b.
first field in the current record
d.
first record in the database
 

 25. 

You can add new fields to a table in ____ view
a.
Datasheet
c.
Normal
b.
Design
d.
Either a or b
 

 26. 

You can specify that the field allow up to ____ characters.
a.
50
c.
250
b.
100
d.
255
 

 27. 

When you create a new database, the first object you need to create is a ____.
a.
form
c.
query
b.
report
d.
table
 

 28. 

To select a record, click the ____.
a.
row number
c.
record selector
b.
row header
d.
field selector
 

 29. 

To remove a record, you must select the entire row and then click the ____.
a.
Remove button
c.
Clear command
b.
Delete key
d.
Esc key
 

 30. 

The default data type for a field is ____.
a.
currency
c.
dates
b.
numbers
d.
regular text
 

Completion
Complete each sentence or statement.
 

 31. 

Access refers to a database table as a(n) ____________________.
 

 

 32. 

_________________________ are specifications that allow you to customize the data type settings.
 

 

 33. 

To retrieve specific data from the database, you would use a(n) ____________________.
 

 

 34. 

A(n) ____________________ is a collection of related information organized for rapid search and retrieval.
 

 

 35. 

____________________ are the primary objects in the database.
 

 

 36. 

____________________ view displays the table data in a row-and-column format.
 

 

 37. 

The ____________________ uniquely identifies each record in a table.
 

 

 38. 

To add a record to an existing database, first click the ____________________ button.
 

 

 39. 

When you open a Database Objects window in Access, the ____________________ bar at the left of the window displays Tables, Queries, Forms, Reports, and so on.
 

 

 40. 

A group of related fields in a database table is called a(n) ____________________.
 

 

 41. 

When you create a database table using a(n) ____________________, you respond to a series of questions about how you want to set up the table.
 

 

 42. 

By default, data entered in a database cell is formatted as ____________________.
 

 

 43. 

To let Access select an appropriate column width for the data entered, use the ____________________ command.
 

 

 44. 

____________________ view provides toolbar buttons that simplify the task of adding or deleting fields in a table that contains data.
 

 

 45. 

Because it is a toggle, the View button shows ____________________ view when a table is displayed in Design view.
 

 

 46. 

To quickly move between the Field Properties pane and the Design view pane, press the ___________________ key.
 

 

 47. 

If you are at the top of a database table, you can quickly go to the end of the table by clicking the ____________________ navigation button.
 

 

 48. 

To move up to the record above the current record, click the ____________________ navigation button at the bottom of the database table.
 

 

 49. 

When you use the ____________________ command, Access automatically stores the items in the Clipboard.
 

 

 50. 

The feature on the navigation button bar at the bottom of a database table that allows you to go directly to a specific record is called the _________________________.
 

 



 
Check Your Work     Reset Help