FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 12: Access_Module_2

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Essay

Review LaterAdd Note

Review Later

The ____________________ function finds the smallest value in a group of records.

Correct Answer

verified

Show Answer

Question 42

Essay

Review LaterAdd Note

Review Later

The ____________________ wildcard represents any individual character.

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

Less than (<) , greater than (>) , and NOT (not equal to) are examples of ____.

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

Case 2-2 PrattLast Associates needs to find the account managers whose start date is earlier than 1/1/2015. -What criteria should PrattLast enter in the Start Date column of the design grid?

A query that prompts for input whenever it is run is a dialog query.

In ____________________ files, the width of any field is the same on every record.

A(n) ____________________ is a window containing the various properties of the object.

In fixed-width files, each record is on a separate line and the fields are separated by a special character.

A question that is asked of Access or any other database management system is called a(n) ____________________.

You cannot create a report for a query.

When you enter text data in a criterion, you must enclose the text in quotation marks.

Wildcards are symbols that represent any character or combination of characters. ____________________

To combine criteria with ____________________, place the criteria on the same row.

To use the Report Wizard to create a report for a query, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Report Wizard button.