FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Access: Querying a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 101

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 102

Matching

Review LaterAdd Note

Review Later

Identify the letter of the choice that best matches the phrase or definition.

Premises

Responses

Either individual criterion must be true in order for the compound criterion to be true.

*

BETWEEN

VAR

NOT

(?)

/

AND criterion

OR criterion

Total

IN

Premises

Either individual criterion must be true in order for the compound criterion to be true.

Responses

*

BETWEEN

VAR

NOT

(?)

/

AND criterion

OR criterion

Total

IN

Show Answer

Correct Answer

Premises

Responses

*

BETWEEN

VAR

NOT

(?)

/

AND criterion

OR criterion

Total

IN

Premises

*

BETWEEN

VAR

NOT

(?)

/

AND criterion

OR criterion

Total

IN

Responses

Question 103

Short Answer

Review LaterAdd Note

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

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

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

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

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

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

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

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

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?

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 clear a filter, click the ____ button on the Home tab and then click Clear All Filters.

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.

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

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

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.

Identify the letter of the choice that best matches the phrase or definition.

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

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