Exam 3: Access Lesson 3: Creating Queries

Another type of condition that you can create causes a record to be displayed in the query datasheet when the record matches a range of values. This is called a ____.

(Multiple Choice)

4.8/5

(33)

Question 41

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

A calculation of more than one field is called a(n) ____.

Calculated field

Menu that opens when you click the arrow on the right side of a field selector.

Total row

When a field displays a value that is calculated using other fields in the query, it is called a(n) ____.

Foreign key

Correct Answer:

Verified

A calculation of more than one field is called a(n) ____.

Menu that opens when you click the arrow on the right side of a field selector.

When a field displays a value that is calculated using other fields in the query, it is called a(n) ____.

When you are viewing a table or query datasheet, you can use the ____ to count the number of values in a column.

The common field in the related table is called a(n) ____ when it is used in a relationship.

(Matching)

4.9/5

(39)

Question 42

Case AC 3-2 Eric is learning how to create calculated fields. Eric notices that Access named the first expression in his query "Expr" and a number (in this case, 1) to indicate the first expression in the query. What can Eric do to change this name?

(Multiple Choice)

4.8/5

(34)

Question 43

A relationship is a way of telling the query which data you are interested in seeing.

(True/False)

4.9/5

(39)

Question 44

To use____, click the Advanced button in the Sort & Filter group on the Home tab. In the menu that opens, click Filter By Form.

(Multiple Choice)

4.8/5

(31)

Question 45

A query can contain ____ of the fields in the table.

(Multiple Choice)

4.9/5

(41)

Question 46

Showing 41 - 46 of 46

Another type of condition that you can create causes a record to be displayed in the query datasheet when the record matches a range of values. This is called a ____.

Case AC 3-2 Eric is learning how to create calculated fields. Eric notices that Access named the first expression in his query "Expr" and a number (in this case, 1) to indicate the first expression in the query. What can Eric do to change this name?

A relationship is a way of telling the query which data you are interested in seeing.

To use____, click the Advanced button in the Sort & Filter group on the Home tab. In the menu that opens, click Filter By Form.

A query can contain ____ of the fields in the table.

Access Lesson 1: Microsoft Access Basics

Access Lesson 2: Creating a Database

Access Lesson 4: Creating and Modifying Forms

Access Lesson 5: Creating and Modifying Reports

Access Lesson 6: Integrating Access

Excel Lesson 1: Microsoft Excel Basics

Excel Lesson 2: Changing the Appearance of a Worksheet

Excel Lesson 3: Organizing the Worksheet

Excel Lesson 4: Entering Worksheet Formulas

Excel Lesson 5: Using Functions

Excel Lesson 6: Enhancing a Worksheet

Excel Lesson 7: Working With Multiple Worksheets and Workbooks

Excel Lesson 8: Working With Charts

Microsoft Office 2010 Basics and the Internet

Outlook Lesson 1: Outlook Basics and E-Mail

Outlook Lesson 2: Calendar

Outlook Lesson 3: Working With Other Outlook Tools

Powerpoint Lesson 1: Microsoft Powerpoint Basics

Powerpoint Lesson 2: Creating Enhancing Powerpoint Presentations

Powerpoint Lesson 3: Working With Visual Elements

Powerpoint Lesson 4: Expanding on Powerpoint Basics

Publisher Lesson 1: Microsoft Publisher Basics

Publisher Lesson 2: Enhancing Publisher Documents

Introduction Lesson 1: Microsoft Windows 7 Basics

Word Lesson 1: Microsoft Word Basics

Word Lesson 2: Basic Editing

Word Lesson 3: Helpful Word Features

Word Lesson 4: Formatting Text

Word Lesson 5: Formatting Paragraphs and Documents

Word Lesson 6: Working With Graphics

Word Lesson 7: Working With Documents

Word Lesson 8: Increasing Efficiency Using Word

Filters