Exam 8: Using Advanced Queries

You can run a query by ____.

(Multiple Choice)

4.9/5

(40)

Question 41

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

These queries change records in a table based on information you enter.

action queries

Before running these queries, check the data types and fields in both tables.

parameter queries

Allow a different criterion each time the query runs.

related tables

Correct Answer:

Verified

These queries change records in a table based on information you enter.

Before running these queries, check the data types and fields in both tables.

Allow a different criterion each time the query runs.

Have a common field.

Allow you to arrange the information you want to place in the rows and columns.

(Matching)

4.8/5

(36)

Question 42

Update queries let you change ____________________ values in a table.

(Short Answer)

4.8/5

(32)

Question 43

When creating an append query, you can add all of the fields at one time to the query design by double-clicking the ____ to select all of the fields.

(Multiple Choice)

4.9/5

(38)

Question 44

A(n) ____________________ query makes changes to the records in a table.

(Short Answer)

4.9/5

(37)

Question 45

With an action query, the records in the table are changed ____.

(Multiple Choice)

4.9/5

(40)

Question 46

Showing 41 - 46 of 46

Exam 8: Using Advanced Queries

You can run a query by ____.

Update queries let you change ____________________ values in a table.

When creating an append query, you can add all of the fields at one time to the query design by double-clicking the ____ to select all of the fields.

A(n) ____________________ query makes changes to the records in a table.

With an action query, the records in the table are changed ____.

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters