Exam 30: Access : Introduction to Access: Finding Your Way Through an Access Database

The navigation buttons in Access allow you to step through a table record by record,or to quickly go to the first or last record in the table.

When you are ready to sort a database,click in the field that you want to sort and click the ________ tab.

Objects that are part of an Access database are available from the ________ within Access.

A(n)________ system is a software system that offers tools needed to create,maintain,and use a database.

How is referential integrity helpful?

A number,phrase,or expression used to select records in a table is called:

A(n)________ is a collection of organized and meaningful data that can be accessed,managed,stored,queried,sorted,and reported.

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

Describe how Access sorts multiple criteria in a database.

Filter by Selection displays only records that match a criterion that you select.

A primary key:

Use ________ if you have mostly numeric data and may require complex charts and graphs.

Like Access,Excel can be used to manage large quantities of data.

Describe comparison operators in Access.

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