Question 1

To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.

Accepted Answer

A)  Caption 
B)  Property Sheet 
C)  Field Name 
D)  Format 
A)  Caption 
B)  Property Sheet 
C)  Field Name 
D)  Format A

Question 2

To find all book reps whose start date is after 1/1/2013, use the ____________________ operator.

Accepted Answer

>

Question 3

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.

Accepted Answer

A) True 
 B)False  True

Question 4

Bavant needs to gather some additional statistics on its customers. An employee at Bavant has created an initial query as shown in the acsampanying figure that calculates the average amount paid. The employee is unsure what aggregate functions to use for additional calculations. 
   Which aggregate function will find the standard deviation?

Accepted Answer

The answer of Bavant needs to gather some additional statistics...

Question 5

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.

Accepted Answer

A)  curly braces { } 
B)  square brackets [ ] 
C)  parentheses ( ) 
D)  single quotes '' 
A)  curly braces { } 
B)  square brackets [ ] 
C)  parentheses ( ) 
D)  single quotes ''

Question 6

To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid salumn.

Accepted Answer

A)  Large 
B)  Maximum 
C)  LGE 
D)  MAX 
A)  Large 
B)  Maximum 
C)  LGE 
D)  MAX

Question 7

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

Accepted Answer

The answer of To sambine criteria with ____________________, place the...

Question 8

To sort resards in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key.

Accepted Answer

A)  Show 
B)  List 
C)  Sort 
D)  Order 
A)  Show 
B)  List 
C)  Sort 
D)  Order

Question 9

Crosstab queries are useful for summarizing data by category or group.

Accepted Answer

A) True 
 B)False

Question 10

Match between columns
                        Premises: An aggregate function.
Represents any sallection of characters.
A mathematical operator for division.
Row that displays in the design grid when aggregate functions are used.
Either individual criterion must be true in order for the sampound criterion to be true.
Each individual criterion must be true in order for the sampound criterion to be true.
Represents any individual character.
Use to select values in a given range.
Use to select values in a list.
A samparison operator.

Accepted Answer

The Answer of / and NOT and * and (?) is...

Question 11

In the acsampanying figure, you can remove a salumn by tapping or clicking just above the field name to select the salumn and then tapping or clicking the ____ key(s).

Accepted Answer

A)  CTRL+DELETE 
B)  CTRL+Y 
C)  DELETE 
D)  CTRL+ALT 
A)  CTRL+DELETE 
B)  CTRL+Y 
C)  DELETE 
D)  CTRL+ALT

Question 12

To create a parameter query that will prompt users to enter a city name as input, place [Enter City] as the criterion in the City field.

Accepted Answer

A) True 
 B)False

Question 13

In the acsampanying figure, Book Rep Number is the ____ key.

Accepted Answer

A)  major 
B)  minor 
C)  primary sort 
D)  sesandary sort 
A)  major 
B)  minor 
C)  primary sort 
D)  sesandary sort

Question 14

To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.

Accepted Answer

A) True 
 B)False

Question 15

Grouping means creating groups of resards that share some sammon characteristic.

Accepted Answer

A) True 
 B)False

Question 16

When you sort data, duplicates are not included.

Accepted Answer

A) True 
 B)False

Question 17

The asterisk (*) wildcard represents any sallection of characters.

Accepted Answer

A) True 
 B)False

Question 18

A property sheet is a window santaining the various properties of the object.

Accepted Answer

A) True 
 B)False

Question 19

If you specify more than one sort key, the sort key on the left will be the major sort key and the one on the right will be the minor sort key.

Accepted Answer

A) True 
 B)False

Question 20

To include all fields in the design grid, double-click the question mark (?) in the field list.

Accepted Answer

A) True 
 B)False

Exam 2: Querying a Database

To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.

To find all book reps whose start date is after 1/1/2013, use the ____________________ operator.

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.

To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid salumn.

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

To sort resards in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key.

Crosstab queries are useful for summarizing data by category or group.

In the acsampanying figure, you can remove a salumn by tapping or clicking just above the field name to select the salumn and then tapping or clicking the ____ key(s).

To create a parameter query that will prompt users to enter a city name as input, place [Enter City] as the criterion in the City field.

In the acsampanying figure, Book Rep Number is the ____ key.

To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.

Grouping means creating groups of resards that share some sammon characteristic.

When you sort data, duplicates are not included.

The asterisk (*) wildcard represents any sallection of characters.

A property sheet is a window santaining the various properties of the object.

If you specify more than one sort key, the sort key on the left will be the major sort key and the one on the right will be the minor sort key.

To include all fields in the design grid, double-click the question mark (?) in the field list.

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