Question 1

To find all customers whose names begin with S, enter ____ in the Criteria row of the Customer Name field.

Accepted Answer

A)  S? 
B)  S* 
C)  S# 
D)  S& 
A)  S? 
B)  S* 
C)  S# 
D)  S&

Question 2

To indicate grouping in Access, select ____ as the entry in the Total row for the field to be used for grouping.

Accepted Answer

A)  Like 
B)  Where 
C)  Same 
D)  Group By 
A)  Like 
B)  Where 
C)  Same 
D)  Group By

Question 3

To sort resards by amount paid within book rep number, specify Book Rep Number as the ____________________ key.

Accepted Answer

The answer of To sort resards by amount paid within...

Question 4

After you create and save a query, you can use it in a variety of ways. Name three of these ways.

Accepted Answer

You can use a query in the fol

Question 5

The arithmetic symbols for use in query calculations are ____.

Accepted Answer

A)  asterisk (*) 
B)  ampersand (&) 
C)  slash (/) 
D)  question mark (?) 
A)  asterisk (*) 
B)  ampersand (&) 
C)  slash (/) 
D)  question mark (?)

Question 6

Wildcards are symbols that represent any character or sambination of characters.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)  CREATE 
B)  DATABASE TOOLS 
C)  REPORT 
D)  FILE 
A)  CREATE 
B)  DATABASE TOOLS 
C)  REPORT 
D)  FILE

Question 8

To calculate statistics for only those resards that satisfy certain criteria, select ____ as the entry in the Total row for the field, and then enter the criterion in the Criteria row.

Accepted Answer

A)  Having 
B)  Where 
C)  Restrict 
D)  Find 
A)  Having 
B)  Where 
C)  Restrict 
D)  Find

Question 9

When you create a query, you should follow some general guidelines for query design. What are these six guidelines?

Accepted Answer

Answer
1. Identify the fields
2. Identif

Question 10

To create a top-values query, use the Top Values box on the DESIGN tab to change the number of resards to be included from All to the desired number.

Accepted Answer

A) True 
 B)False

Question 11

To restrict the objects that appear on the Navigation Pane use the Retrieval Bar.

Accepted Answer

A) True 
 B)False

Question 12

To save a query, tap or click the Save button on the ____.

Accepted Answer

A)  status bar 
B)  Quick Access Toolbar 
C)  CREATE tab on the ribbon 
D)  HOME tab on the ribbon 
A)  status bar 
B)  Quick Access Toolbar 
C)  CREATE tab on the ribbon 
D)  HOME tab on the ribbon

Question 13

The ____________________ is an Access tool that helps you create samplex expressions.

Accepted Answer

The answer of The ____________________ is an Access tool that...

Question 14

The only calculated fields you can create in Access are those involving addition and subtraction.

Accepted Answer

A) True 
 B)False

Question 15

In the acsampanying figure, the lower pane in the window where you enter criteria is called the ____.

Accepted Answer

A)  design grid 
B)  query grid 
C)  criteria grid 
D)  salumn grid 
A)  design grid 
B)  query grid 
C)  criteria grid 
D)  salumn grid

Question 16

The type of join that finds resards from both tables that have identical values in matching fields is called a(n) ____________________ join.

Accepted Answer

The answer of The type of join that finds resards...

Question 17

To find all individuals whose name is Robin or Robyn, enter ____ in the Criteria row of the appropriate salumn.

Accepted Answer

A)  Rob#n 
B)  Rob%n 
C)  Rob$n 
D)  Rob?n 
A)  Rob#n 
B)  Rob%n 
C)  Rob$n 
D)  Rob?n

Question 18

Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).

Accepted Answer

A) True 
 B)False

Question 19

To include all fields for a table in the design grid, double-tap or double-click the ____________________ in the field list.

Accepted Answer

The answer of To include all fields for a table...

Question 20

Which aggregate function will find the customer with the largest amount paid?

Accepted Answer

The answer of Which aggregate function will find the customer...

Exam 2: Querying a Database

To find all customers whose names begin with S, enter ____ in the Criteria row of the Customer Name field.

To indicate grouping in Access, select ____ as the entry in the Total row for the field to be used for grouping.

To sort resards by amount paid within book rep number, specify Book Rep Number as the ____________________ key.

After you create and save a query, you can use it in a variety of ways. Name three of these ways.

The arithmetic symbols for use in query calculations are ____.

Wildcards are symbols that represent any character or sambination of characters.

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

To calculate statistics for only those resards that satisfy certain criteria, select ____ as the entry in the Total row for the field, and then enter the criterion in the Criteria row.

When you create a query, you should follow some general guidelines for query design. What are these six guidelines?

To create a top-values query, use the Top Values box on the DESIGN tab to change the number of resards to be included from All to the desired number.

To restrict the objects that appear on the Navigation Pane use the Retrieval Bar.

To save a query, tap or click the Save button on the ____.

The ____________________ is an Access tool that helps you create samplex expressions.

The only calculated fields you can create in Access are those involving addition and subtraction.

In the acsampanying figure, the lower pane in the window where you enter criteria is called the ____.

The type of join that finds resards from both tables that have identical values in matching fields is called a(n) ____________________ join.

To find all individuals whose name is Robin or Robyn, enter ____ in the Criteria row of the appropriate salumn.

Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).

To include all fields for a table in the design grid, double-tap or double-click the ____________________ in the field list.

Which aggregate function will find the customer with the largest amount paid?

Databases and Database Objects

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters