Exam 4: Access: Querying a Database

The special criteria that can be used in queries are ____.

If the TAB key is used to move from field to field in a record, press F2 to produce an insertion point in a field.

The ____ operator allows you to search for a range of values in one field.

A(n)____________________ query is a query that prompts for input whenever it is used.

To combine criteria with ____________________, the criteria must go on separate lines in the Criteria area of the grid.

You can convert a Number field to a Currency field but you cannot convert a Currency field to a Number field.

A(n)____ query adds records from an existing table to a new table, that is, a table that has not yet been created.

To find all clients whose names begin with Gr, enter Gr* in the Criteria row of the design grid.

To find the largest amount paid amount for a client, select _____ as the entry in the Total row for the Amount Paid column.

To clear a filter, click the ____ button on the Home tab and then click Clear All Filters.

To find all clients whose names begin with Gr, enter _____ in the Criteria row of the Client Name field.

Camashaly has just realized that they need to make some additional changes to the Client table shown in Design view in the accompanying figure.They have asked you to make these changes. Camashaly would like to move the Client Type field in the Client table.The field should appear before the Business Analyst Number field.What do you need to do to move the field?

You can use a make-table query to create an archive table.

A(n)_________________________ is a field in one table whose values are required to match a primary key in another table.

To create a top-values query, use the Top Values box on the Design tab to change the number of records to be included from All to the desired number.

To order the records in the Client table in reverse alphabetical order by City, click the ____ button.

A(n)_____ field is a field that can be computed from other fields.

The accompanying figure shows a join of the Business Analyst and Client tables.____________________ joins are used to show all the records in one table as well as the common records; that is, the records that share the same value in the join field.