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 61

Multiple Choice

Review LaterAdd Note

Review Later

To include calculated fields in queries, enter a name for the calculated field, a(n) _____, and then the expression in one of the columns in the Field row.

A) colon (:)
B) semi-colon (:)
C) equal sign (=)
D) exclamation point (!)

E) B) and C)
F) A) and D)

Correct Answer

verified

Show Answer

Question 62

Multiple Choice

Review LaterAdd Note

Review Later

If the Client Number field in a record always should display the two characters in the client number in uppercase, then the correct format for this field is ____.

A) <
B) &
C) %
D) >

E) B) and D)
F) C) and D)

Correct Answer

verified

Show Answer

Question 63

Multiple Choice

Review LaterAdd Note

To export data from a query to Excel, select the query in the Navigation Pane, click _____ on the Ribbon, and then click the Excel button.

In the Camashaly Design database, a one-to-many relationship exists between the Business Analyst table and the Client table.

To add a record using the form shown in the accompanying figure, click the ____ button on the Navigation bar.

When an update query is created, a(n)_________________________ row displays in the design grid.

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. Because Camashaly may upsize the database to SQL Server, they have decided to delete the Services Needed field.How do you delete the field?

In the accompanying figure, the criterion for Current Due is 0.The query results for this query will display ____ in the Current Due field.

To remove a total row that appears in a datasheet, click the ____ button on the Home tab.

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

To sort records by amount paid within business analyst number, specify Business Analyst Number as the ____________________ key.

When tables are joined in a query, it is not possible to restrict retrieval by using criteria.

The ____________________ wildcard represents any individual character.

The field or fields on which records are sorted is called the sort key.

To use Filter By Form to filter records, click the ____ button on the Home tab and then click Filter By Form.

To open the Relationships window in the accompanying figure, click the _________________________ button on the Database Tools tab.

To open a form in Form view from the Navigation Pane, right-click the form and click Form View on the shortcut menu.

To create a crosstab, click the ____ button on the Create tab.

You can export to Excel but you cannot export data to a text file.

When a filter is in effect, you can redisplay all records by clicking the ____ button on the Home tab.