Question 1

Match between columns
                        Premises: When a field displays a value that is calculated using other fields in the query, it is called a(n) ____.
Menu that opens when you click the arrow on the right side of a field selector.
When you are viewing a table or query datasheet, you can use the ____ to count the number of values in a column.
A calculation of more than one field is called a(n) ____.
The common field in the related table is called a(n) ____ when it is used in a relationship.

Accepted Answer

The Answer of Calculated field and Total row and Foreign is...

Question 2

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

Accepted Answer

A)  one 
B)  some 
C)  all 
D)  all of the above 
A)  one 
B)  some 
C)  all 
D)  all of the above

Question 3

A(n) ____________________ query lets you summarize relevant data, such as adding the field values in a column that stores price data.

Accepted Answer

The answer of A(n) ____________________ query lets you summarize relevant...

Question 4

You can use Filter By Selection when you need to display records that contain one or more values based on the values stored in one or more fields.

Accepted Answer

A) True 
 B)False

Question 5

Sorting a field in ____________________ order arranges records from A to Z, or smallest to largest.

Accepted Answer

The answer of Sorting a field in ____________________ order arranges...

Question 6

Case AC 3-2 Eric is learning how to create calculated fields. Eric is typing one of his expressions and notices that Excel only displays the first 20 characters. What can Eric do to display the entire field?

Accepted Answer

A)  Click the empty Field box in the design grid, and then click Zoom on the shortcut menu. 
B)  Click the empty Field box in the design grid, and then click Show All on the Ribbon. 
C)  Either a. or b. 
D)  Neither a. nor b. 
A)  Click the empty Field box in the design grid, and then click Zoom on the shortcut menu. 
B)  Click the empty Field box in the design grid, and then click Show All on the Ribbon. 
C)  Either a. or b. 
D)  Neither a. nor b.

Question 7

The ____ operator selects records that match at least one of two or more conditions in a query.

Accepted Answer

A)  Or 
B)  And 
C)  Plus 
D)  Either 
A)  Or 
B)  And 
C)  Plus 
D)  Either

Question 8

After you add two related tables to the query design, a ____ shows the relationship between the tables.

Accepted Answer

A)  relationship line 
B)  help line 
C)  join line 
D)  match line 
A)  relationship line 
B)  help line 
C)  join line 
D)  match line

Question 9

An easy method to change the way data is sorted is to click any field value in the field you want to sort, and then click the Ascending or Descending buttons in the ____ group on the Home tab.

Accepted Answer

A)  Data 
B)  Formulas 
C)  Query 
D)  Sort & Filter 
A)  Data 
B)  Formulas 
C)  Query 
D)  Sort & Filter

Question 10

Briefly describe Filter by Selection and Filter by Form. Imagine that you are searching for songs in a database. Give an example of a situation where you would use Filter by Selection and a situation where you would use Filter by Form.

Accepted Answer

- When you use Filter By Selection , you

Question 11

When you use ____, you select a field value (or part of a field value) in a datasheet, and then click the Selection button in the Sort & Filter group on the Home tab.

Accepted Answer

A)  Filter By Selection 
B)  Filter By Form 
C)  Filter by Query 
D)  Filter by Value 
A)  Filter By Selection 
B)  Filter By Form 
C)  Filter by Query 
D)  Filter by Value

Question 12

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 ____.

Accepted Answer

A)  complex condition 
B)  multi-field condition 
C)  simple condition 
D)  range-of-values condition 
A)  complex condition 
B)  multi-field condition 
C)  simple condition 
D)  range-of-values condition

Question 13

In the Query Design window, you build and change the query using the query design grid.

Accepted Answer

A) True 
 B)False

Question 14

To create a(n) ____________________ between two tables, you must design the tables so they contain a common field.

Accepted Answer

The answer of To create a(n) ____________________ between two tables,...

Question 15

Case AC 3-1 Danielle is a Sales Manager and is troubleshooting why profits are down. Danielle wants to see which items are the least profitable. She chooses the Profitability field of her product datasheet and clicks the ____ button.

Accepted Answer

A)  Ascending 
B)  Descending 
C)  Selection 
D)  Advanced 
A)  Ascending 
B)  Descending 
C)  Selection 
D)  Advanced

Question 16

Sorting a field in ascending order arranges records from Z to A, or largest to smallest.

Accepted Answer

A) True 
 B)False

Question 17

When you open a query object, you ____ the query.

Accepted Answer

A)  save 
B)  run 
C)  move 
D)  engage 
A)  save 
B)  run 
C)  move 
D)  engage

Question 18

To create a relationship between tables, click the ____ tab on the Ribbon. In the Relationships group, click the Relationships button.

Accepted Answer

A)  Database Tools 
B)  Relationship 
C)  Data 
D)  Format 
A)  Database Tools 
B)  Relationship 
C)  Data 
D)  Format

Question 19

A(n) AutoFilter is a menu that opens when you click the arrow on the right side of a field selector. The menu contains options for sorting data and clearing any filters that you have already applied.

Accepted Answer

A) True 
 B)False

Question 20

An easy way to create a query is to use the ____, which asks you what data you want to see by letting you select options in dialog boxes.

Accepted Answer

A)  Create Query Wizard 
B)  Easy Query Wizard 
C)  Simple Query Wizard 
D)  Complex Query Wizard 
A)  Create Query Wizard 
B)  Easy Query Wizard 
C)  Simple Query Wizard 
D)  Complex Query Wizard

Exam 3: Creating Queries

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

A(n) ____________________ query lets you summarize relevant data, such as adding the field values in a column that stores price data.

You can use Filter By Selection when you need to display records that contain one or more values based on the values stored in one or more fields.

Sorting a field in ____________________ order arranges records from A to Z, or smallest to largest.

Case AC 3-2 Eric is learning how to create calculated fields. Eric is typing one of his expressions and notices that Excel only displays the first 20 characters. What can Eric do to display the entire field?

The ____ operator selects records that match at least one of two or more conditions in a query.

After you add two related tables to the query design, a ____ shows the relationship between the tables.

An easy method to change the way data is sorted is to click any field value in the field you want to sort, and then click the Ascending or Descending buttons in the ____ group on the Home tab.

Briefly describe Filter by Selection and Filter by Form. Imagine that you are searching for songs in a database. Give an example of a situation where you would use Filter by Selection and a situation where you would use Filter by Form.

When you use ____, you select a field value (or part of a field value) in a datasheet, and then click the Selection button in the Sort & Filter group on the Home tab.

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 ____.

In the Query Design window, you build and change the query using the query design grid.

To create a(n) ____________________ between two tables, you must design the tables so they contain a common field.

Case AC 3-1 Danielle is a Sales Manager and is troubleshooting why profits are down. Danielle wants to see which items are the least profitable. She chooses the Profitability field of her product datasheet and clicks the ____ button.

Sorting a field in ascending order arranges records from Z to A, or largest to smallest.

When you open a query object, you ____ the query.

To create a relationship between tables, click the ____ tab on the Ribbon. In the Relationships group, click the Relationships button.

A(n) AutoFilter is a menu that opens when you click the arrow on the right side of a field selector. The menu contains options for sorting data and clearing any filters that you have already applied.

An easy way to create a query is to use the ____, which asks you what data you want to see by letting you select options in dialog boxes.

Microsoft Access Basics

Creating a Database

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

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