TRUE/FALSE
1. A collection of fields describing a person, a place, an object, an event, or an idea is a table.
2. A single set of field values within a table is a record.
3. A database is a collection of related tables.
4. A collection of related tables is called a relational database.
5. You connect the records in separate tables through a common field that appears in both tables.
6. A primary key in one table cannot be used as a foreign key in a different table.
7. Although a field has unique values in the table in which it is the primary key, it does not have to have unique values in the table in which it is the foreign key.
8. Like spreadsheets, a DBMS can handle massive amounts of data and can easily form relationships among multiple tables.
9. To start Access, click the Start button on the taskbar, click All Programs, click Microsoft Office, and then click Microsoft Office Access 2010.
10. The navigation buttons provide a way to move vertically through the records.
11. Query results automatically are stored in the database.
12. Primary keys uniquely identify records in a table.
13. The items marked 1 in the accompanying figure are the default property values for a Text field.
14. Click the item marked 3 in the accompanying figure to display a list of data types.
15. A primary key is allowed to have a null value.
MODIFIED TRUE/FALSE
1. Defining a(n) primary key in a second table creates a relationship between that table and the table where the primary key was first defined. _________________________
2. One benefit of a relational database management system is that it contains a built-in query language, which lets you obtain immediate answers to the questions you ask about your data. _________________________
3. The item marked 1 in the accompanying figure is the field selector. _________________________
4. The field marked 2 in the accompanying figure is the record selector.
5. The item marked 2 in the accompanying figure is the First record button. _________________________
6. The item marked 3 in the accompanying figure is the Next record button. _________________________
7. The item marked 4 in the accompanying figure is the New (blank) record button. _________________________
8. The data type determines what field values you can enter for the field and what other properties the field will have. _________________________
9. Access allows you to modify a table's structure in Datasheet view. _________________________
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a. field g. foreign key
b. table h. relational DBMS
c. field value i. report
d. relational database j. backing up
e. common field k. compact
f. primary key l. query
1. Organizes data as a collection of tables
2. A collection of related tables
3. The specific content of a field
4. Connects the records in separate tables
5. A single characteristic or attribute of a person, a place, an object, an event, or an idea
6. A primary key from one table that is used to form a relationship with a second table
7. A collection of fields that describe a person, a place, an object, an event, or an idea
8. A field or collection of fields whose values uniquely identify each record in a table
9. A question you ask about data stored in a database
10. A formatted printout (or screen display) of the contents of one or more tables
11. To rearrange the data and objects in a database file, to decrease its file size
12. The process of making a copy of the database file to protect your data against loss or damage
MULTIPLE CHOICE
1. Access assigns the default name ____ to the first new table you create.
a. NewTable c. Table
b. Table1 d. New_Table
2. The ____ is the main control center for opening and working with database objects.
a. Navigation Pane c. Control window
b. Wizard window d. Database window
3. The ____Toolbar provides one-click access to commonly used commands, such as Save.
a. Access c. Quick Access
b. Navigation d. Database
4. The ____ tab provides options for adding, removing, and formatting the fields in a table.
a. Layout c. Tabular
b. Fields d. Datasheet
5. The ____ window is the program window that appears when you create a new database or open an existing database.
a. Database c. Access
b. Tabular d. Datasheet
6. The ____ provides the main Access commands organized by task into tabs and groups.
a. Microsoft Access Help c. Ribbon
b. datasheet d. Add & Delete group
7. In the accompanying figure, each column represents a ____.
a. record c. table
b. field d. primary key
8. In the accompanying figure, Owen is a ____.
a. field c. record
b. field value d. key
9. In the accompanying figure, the last row of data shown (11053, Hwan, Tang, etc.) is a ____.
a. table c. record
b. field d. key
10. In the accompanying figure, there are ____ fields shown.
a. 3 c. 5
b. 4 d. 6
11. The first step in organizing data into a database is to identify the individual ____.
a. records c. fields
b. formats d. reports
12. The content of any given field is the ____.
a. database c. field value
b. table d. entity
13. All related fields can be grouped together as a(n) ____.
a. table c. element
b. database d. object
14. Which of the following could be defined as a field in a database?
a. customer name c. phone number
b. order number d. all of the above
15. Data from separate tables can be connected by specifying a ____.
a. common field c. field value
b. hyperlink d. primary key
16. A relational database is a collection of ____.
a. field values c. related tables
b. records d. common fields
COMPLETION
1. A set of data such as first name, last name, address, etc. for a specific person is a(n) ____________________.
2. The content of a field is the ____________________.
3. A group of related tables is called a(n) ____________________ database.
4. In the accompanying figure, ContractNum uniquely identifies each record in the Contract table; it is a(n) ____________________ key.
5. In the accompanying figure, CustomerID in the Contract table is a(n) ____________________ key.
6. In the accompanying figure, the columns in Datasheet view contain the ____________________ for each field in the table.
7. A relational DBMS provides protection of ____________________ through security, control, and recovery facilities.
8. Access has a built-in ____________________ language that allows you to ask questions and obtain answers about your data.
9. The ____________________ determines what field values you can enter for the field.
10. When you create a(n) ____________________, you tell Access which fields you need and what criteria Access should use to select the records that will answer your question.
11. You use a(n) ____________________ to enter, edit, and view records in a database.