Exam 11: Working With Data

The simplest way to create a query is to use  _____.

The tables you wish to relate must share a(n) ____ field.

You can enable a disabled database by clicking Enable Content in the Security Warning bar

Greater Than is one of the available Number Filters.

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

Explain how to capture a screen shot of a sorted table.

You have a database that contains information about all of the employees from your company.  There is a table containing basic demographic information called Employees and a table containing salary information called Pay. The two tables are related by the field called Emp ID. Your supervisor wants to see a list of employees who are making over $25,000.00 and have a last name of a "Wilson". Describe how to accomplish this.

When a filter is applied to a table, the word "Filtered" appears in the record navigation bar

In the accompanying figure, item 6 points to the ____ list arrow.

In Query Design view, the lower pane is called the ____.

When sorting on more than one field, the field that is the secondary sort field, is called the ____ sort field.

You have a database that contains information about all of the employees from your company.  There is a table containing basic demographic information called Employees and a table containing salary information called Pay. The two tables are related by the field called Emp ID. The database contains multiple tables, which have not been used together up to this point. How do you create the relationship between employees and their pay?

You work at a retail store that uses a small database to track customers. Your supervisor asks you to perform a series of tasks with the database. The database contains one table with fields for Customer Name, City, and State. Your supervisor would like you to remove a sort and revert the fields to their original listing. How do you go about this?

____ are conditions that must be met for a record to be displayed.

When sorting on more than one field, the field that is the primary sort field,  is called the ____ sort field.

To specify a relationship between two tables, you must share a(n) common field and one must be the primary key field in one of the tables

In the accompanying figure, what must you do to work in this database?

You can rearrange, or ____, the records in a table in alphabetical or numerical order.

You cannot sort records using more than one field at a time.

You work at a retail store that uses a small database to track customers. Your supervisor asks you to perform a series of tasks with the database. The database contains one table with fields for Customer Name, City, and State. Describe the process of sorting your customer records in ascending order by the name of the customer in the field called "Customer Name."