Access Chapter 1

Front 1

Which sequence represents the hierarchy of terms, from smallest to largest

Back 1

Field, Record, Table, Database

Front 2

You edit several records in an Access table. When should you execute the Save command?

Back 2

Records are saved automatically, the save command is not required

Front 3

Which of the following is not true of an Access database?

Back 3

Every table in a database contains the same number of records as every other table.

Front 4

Which of the following is true regarding the record selector box?

Back 4

An orange border surrounds the record selector box and the active record.

Front 5

Which of the following will be accepted as valid during data entry?

Back 5

Entering numbers into a text field

Front 6

You have finished an Access assignment and wish to turn it in to your instructor for evaluation. As you prepare to transfer the file, you discover that it has more than doubled in size. You should:

Back 6

Compact and repair the database before sending it to your instructor.

Front 7

Which of the following conditions is available through Filter by Selection?

Back 7

Equals condition

Front 8

An Employees table is open in Datasheet view. You want to sort the names alphabetically by last name and then by first name (e.g., Smith, Andrew). To do this, you must:

Back 8

First sort ascending on first name and then on last name.

Front 9

Which of the following is not true when creating relationships between tables?

Back 9

The common fields used to create a relationship must both be primary keys.

Front 10

All of the following statements are true about creating a database except

Back 10

The objects provided in a template cannot be modified.