Exam 15: Access: Introduction to Powerpoint

The ________ tab holds some of the more advanced features in Access.

The ________ tab is the default Access tab and contains basic editing functions.

Access speed measures the time it takes for Access to start up.

Editing a table through a query does not update the data in that table.

A(n) ________ is a collection of fields that describe a person, place, object, event, or idea.

Selecting data by means of a query:

-In the table pictured above, the column labeled Last Name is an example of a:

A complete set of data elements within a table is called a record.

A query is used to display all records in a database.

Filter by Form displays records based on single criteria.

A collection of related fields describing a person, place, object, event, or idea is called a table.

A ________ is a question you ask about data stored in a database.

If there is a power failure while you are working on a database, all your changes will be lost unless you saved them first.

Which of the following is NOT an example of an Access object?

A form can be used to make users view or edit only one record at a time.

Ryan is working in a database that organizes vendor contact information. Ryan must find vendors located in two cities. The vendors must have offices in both cities in order to meet Ryan's requirements. Ryan should use the Filter by Form ________ condition.

When making a change to an Access database, you must first save the change in order for the change to take effect.

Alice is working in a database containing the names, service locations, and services offered by landscapers. She needs to find landscapers in that offer services in the Washington area and that service rare flowers. The best way for her to search for this data is to perform a:

The ________ tab holds all of the operations necessary to carry out data import and export.

An existing query for a database can be opened by double-clicking in the ________ of the Database window.