Exam 1: Getting Started With Excel

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

What should you do when you are finished working a database?

What data type should you assign to a field that stores postal codes?

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

Which of the following are properties you can set for a field? Select all the options that apply.

In which object can you rename a field?

Which of the following are Access data types? Select all the options that apply.

Which data type is used for sequential integers controlled by Access?

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

What is the most efficient way to navigate to the last record in a table containing 100 records?

For a Comments field that contains many words,set a Long data type.

You use the Report tool to quickly create a report based on the selected table.

Which of the following are tasks you perform when creating tables? Select all the options that apply.

You can assign most but not all data types to a field in Table Datasheet view.

Compacting a database has the same result as backing up a database.

Which of the following is the fastest way to open an Access database?

A category of data such as a customer's name,city,state,or phone number is called a _____.

Which two properties are required for every field?

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

A _____ is a grid that displays fields as columns and records as rows.