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

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Filter
B) Remove
C) Advanced
D) Select

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

Represents any individual character.

*

OR criterion

IN

AND criterion

/

VAR

NOT

(?)

BETWEEN

Total

Premises

Represents any individual character.

Responses

*

OR criterion

IN

AND criterion

/

VAR

NOT

(?)

BETWEEN

Total

Show Answer

Correct Answer

Premises

Responses

*

OR criterion

IN

AND criterion

/

VAR

NOT

(?)

BETWEEN

Total

Premises

*

OR criterion

IN

AND criterion

/

VAR

NOT

(?)

BETWEEN

Total

Responses

Question 103

True/False

Review LaterAdd Note

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.

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

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

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

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 find all clients whose names begin with Gr, enter Gr* in the Criteria row of the design grid.

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

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

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.

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

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

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?

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.

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

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

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

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