Exam 11: Working With Data

The symbols >,

Sorting in order alphabetically from Z to A or numerically from 9 to 0 is known as ____ order.

You can save a filter as a database object.

To open an existing Access database, click the  ____command from the Access Start screen.

A query that retrieves or selects data from one or more tables or queries according to your criteria is known as a(n) ____ query.

In the accompanying figure, what is stopping the user from working in this database?

You can open an Access database and save it with a new name.

In the second table of two related tables, the common field shared with the first table is called the ____ key.

Explain the difference between sorting and filtering data in Access.

A calculated field is useful is you want to show the _________________ of calculations based on values in certain fields.

You can create a query in Design view

____________ fields are fields that contain a mathematical expression.

In the accompanying figure, item 2 points to the ____.

A ____ is a database object that extracts data from one or more tables in a database according to criteria that you set.

In the accompanying figure, item 4 points to the ____.

A huge benefit to using referential ___________________ is that the data in your databases is consistent.

In the accompanying figure, item 2 points to a ____.

One way to modify an existing query is to specify a sort order for a(n) field in a query

In the accompanying figure, item 5 points to the ____.