Exam 1: Getting Started With Excel

What is the main purpose of a form?

Which of the following tools can you use to create a query?

_____ view provides the most options for defining fields.

You might delete an employee record if the employee no longer works for the company.

You can create an Access report by selecting fields from one or more tables or _____.

When you delete a record containing an AutoNumber field, Access discards the value in the AutoNumber field and _____.

In an Employees table, what is the appropriate data type for a field that shows the hiring date?

You can use the Compact and Repair Database button on the Database Tools tab to reduce the size of the database.

Before you can rename a field, you must change its data type.

What is the result of using an Application Part to create a form?

After you create a table, you must save the entire database so you do not lose the new table.

To back up a database, you use the _____ command.

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

A field with the Currency data type contains values such as quantities, measurements, and scores.

If you want to manage lists of data about customers and the products they order, use _____ software.

Use the New (blank) record button to move the focus to the first record in a table.

Press ESC to remove editing changes you made to the previous record.

Suppose you rename a field in Table Design view. What must you do before you can view the data in the table?

Which two properties are required for every field?

Access provides a single database template for creating a blank database.