IC3 Lesson 22 Study Guide
Indicate whether the statement is true or false.
____ 1. Access is a database program.
____ 2. The Access screen is similar to other Office 2007 applications.
____ 3. You can open multiple databases at a time in an Access window.
____ 4. Objects are organized into categories in the Navigation Pane.
____ 5. When you create a new database, the first step is to name the database file.
____ 6. You cannot use the Save As command to name and save objects in the database.
____ 7. You can create as many tables as you need to store the information for a database.
____ 8. You can only add fields in Design view.
____ 9. Unlike Word and Excel, Access does not have a standard document view.
____ 10. Once you have deleted a record, you can use the Undo command to restore it.
Indicate whether the statement is true or false. If false, change the identified word or phrase to make the statement true.
____ 11. A query is an object that organizes data in a specific layout. ____________________
____ 12. You can use the Save As command to save the entire database under a new name. ____________________
____ 13. At least one table must be created before any additional objects can be created. ____________________
____ 14. Datasheet view shows details about the structure of the object, including the data type and the field properties.
____ 15. The default Field Size property for the Text data type is 50 characters. ____________________
Complete each statement.
16. A table is often referred to as a(n) ____________________.
17. A(n) ____________________ is a collection of related information.
18. The intersection of a row and a column is called a(n) ____________________, just as in an Excel worksheet.
19. When you enter data into a cell, it is called a(n) ____________________.
20. If you make a mistake adding or editing data in a record, you can choose the ____________________
command to reverse your last action.
Identify the letter of the choice that best matches the phrase or definition.
c. field name
e. primary key
____ 21. A single piece of database information.
____ 22. A unique identifier for each record in the table.
____ 23. A group of related fields in a database.
____ 24. The primary object in the database.
____ 25. A label that helps identify the field.
IC3 Lesson 22 Study Guide
1. ANS: T PTS: 1
2. ANS: T PTS: 1
3. ANS: F PTS: 1
4. ANS: T PTS: 1
5. ANS: T PTS: 1
6. ANS: F PTS: 1
7. ANS: T PTS: 1
8. ANS: F PTS: 1
9. ANS: T PTS: 1
10. ANS: F PTS: 1
11. ANS: F, report
12. ANS: F
13. ANS: T PTS: 1
14. ANS: F, Design
15. ANS: F, 255
16. ANS: datasheet
17. ANS: database
18. ANS: cell
19. ANS: entry
20. ANS: Undo
21. ANS: B PTS: 1
22. ANS: E PTS: 1
23. ANS: D PTS: 1
24. ANS: A PTS: 1
25. ANS: C PTS: 1