Chapter 1

Question 1

The Filter functions enable you to organize your data. (T/F)

Answer 1

False

Question 2

What is a collection of integrated and related tables?

Answer 2

Database

Question 3

It is not possible to change the order of fields in a database. (T/F)

Answer 3

False

Question 4

When you add a filter to a second field, where the results must reflect all of the criteria values, what type of condition have you created?

Answer 4

And

Question 5

Gridlines visually frame the rows and columns in a datasheet with a border. (T/F)

Answer 5

True

Question 6

When you double-click a table name in the Navigation Pane, the default view is Design view. (T/F)

Answer 6

False

Question 7

Alignment changes to a field are applied to one cell. (T/F)

Answer 7

False

Question 8

What is the first step to delete a record from a table?

Answer 8

Click the Record Selector cell of the record

Question 9

Which of the following options is not a basic field property?

Answer 9

Default Value

Question 10

Which of the following statements is not true regarding the Navigation Pane?

Answer 10

The Navigation Pane cannot be customized.

Question 11

Which of the following tabs is used to initially create all the objects in a database?

Answer 11

Create

Question 12

Design view enables you to enter, modify, delete, or view the data records. (T/F)

Answer 12

False

Question 13

Which of the following statements is not true for adding a total row?

Answer 13

A Total row is added above the append row.

Question 14

When working with a new table, save it by clicking the File tab and clicking the Save button. (T/F)

Answer 14

True

Question 15

Which of the following data types would you use to display a spreadsheet object in a field?

Answer 15

OLE Object

Question 16

Which of the following statements is not true when adding records in a table?

Answer 16

Press Shift+Tab to move to the next field.

Question 17

In Access, it is not possible to delete fields after you have added data to the field. (T/F)

Answer 17

False

Question 18

The Back Up Database option creates a copy of your database. (T/F)

Answer 18

True

Question 19

In a table, which of the following must be identified as the primary key?

Answer 19

Field

Question 20

To edit field properties in Datasheet view, what must you click after selecting the cell containing the field name you wish to change?

Answer 20

Name & Caption button