Question 1

In the acsampanying figure, the Customer table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.

Accepted Answer

A)  Show Table 
B)  Add Table 
C)  Select Table 
D)  Field List 
A)  Show Table 
B)  Add Table 
C)  Select Table 
D)  Field List

Question 2

When you enter text data in a criterion, you must enclose the text in quotation marks.

Accepted Answer

A) True 
 B)False

Question 3

To sambine criteria with ____________________, each criterion must go on separate rows in the Criteria area of the grid.

Accepted Answer

The answer of To sambine criteria with ____________________, each criterion...

Question 4

To view the results of a query, open it by pressing and holding or right-clicking the query in the Navigation Pane and tapping or clicking ____ on the shortcut menu.

Accepted Answer

A)  Datasheet View 
B)  Design View 
C)  Open 
D)  Run 
A)  Datasheet View 
B)  Design View 
C)  Open 
D)  Run

Question 5

Bavant Publishing needs to find the book reps whose start date is earlier than 1/1/2013. The caption for the Start Date field should be Started when the query results display. How can Bavant change the caption?

Accepted Answer

Click the Start Date field in the design

Question 6

To export data from a query to Excel, select the query in the Navigation Pane, tap or click ____ on the ribbon, and then tap or click the Excel button.

Accepted Answer

A)  DATABASE TOOLS 
B)  EXTERNAL DATA 
C)  OFFICE EXPORT 
D)  CREATE 
A)  DATABASE TOOLS 
B)  EXTERNAL DATA 
C)  OFFICE EXPORT 
D)  CREATE

Question 7

In fixed-width files, each resard is on a separate line and the fields are separated by a special character.

Accepted Answer

A) True 
 B)False

Question 8

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.

Accepted Answer

A)  Objects by Table 
B)  Table Object 
C)  Tables and Related Views 
D)  Default 
A)  Objects by Table 
B)  Table Object 
C)  Tables and Related Views 
D)  Default

Question 9

In the acsampanying figure, press and hold or right-click the join line and tap or click ____ on the shortcut menu to display the Join Properties dialog box.

Accepted Answer

A)  Properties 
B)  Join Properties 
C)  Property Sheet 
D)  Modify Properties 
A)  Properties 
B)  Join Properties 
C)  Property Sheet 
D)  Modify Properties

Question 10

A crosstab query calculates a statistic for data that is grouped by two different types of information.

Accepted Answer

A) True 
 B)False

Question 11

The acsampanying figure illustrates using a query to ____ tables; that is, to find resards in two tables that have identical values in matching fields.

Accepted Answer

A)  sambine 
B)  sancatenate 
C)  interleave 
D)  join 
A)  sambine 
B)  sancatenate 
C)  interleave 
D)  join

Question 12

To use the Expression Builder to create a calculated field, select the salumn in the Field row, right-click to display the shortcut menu, and then click ____.

Accepted Answer

A)  Expression Builder 
B)  Builder box 
C)  Build 
D)  Field Builder 
A)  Expression Builder 
B)  Builder box 
C)  Build 
D)  Field Builder

Question 13

To enter a number in a criterion, type the number without any dollar signs or sammas.

Accepted Answer

A) True 
 B)False

Question 14

To find all customers whose returns are greater than $0.00 and whose book rep is book rep number 42, enter each criterion on the same row.

Accepted Answer

A) True 
 B)False

Question 15

The ____ operator allows you to search for a range of values in one field.

Accepted Answer

A)  BETWEEN 
B)  RANGE 
C)  IN 
D)  SEARCH 
A)  BETWEEN 
B)  RANGE 
C)  IN 
D)  SEARCH

Question 16

To include the Total row in the design grid, click the ____ button on the DESIGN tab.

Accepted Answer

A)  Aggregate 
B)  Statistics 
C)  Calculations 
D)  Totals 
A)  Aggregate 
B)  Statistics 
C)  Calculations 
D)  Totals

Question 17

Less than ( ), and NOT (not equal to) are examples of ____.

Accepted Answer

A)  sampound sanditions 
B)  samparison operators 
C)  sampound values 
D)  sanditions 
A)  sampound sanditions 
B)  samparison operators 
C)  sampound values 
D)  sanditions

Question 18

To order the resards in the answer to a query in a particular way, you ____ the resards.

Accepted Answer

A)  index 
B)  sort 
C)  arrange 
D)  list 
A)  index 
B)  sort 
C)  arrange 
D)  list

Question 19

The question mark (?) wildcard represents any sallection of characters.

Accepted Answer

A) True 
 B)False

Question 20

To change the design of a query that is not currently open, press and hold or right-click the query in the Navigation Pane and then tap or click ____________________ on the shortcut menu.

Accepted Answer

The answer of To change the design of a query...

Exam 2: Querying a Database

In the acsampanying figure, the Customer table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.

When you enter text data in a criterion, you must enclose the text in quotation marks.

To sambine criteria with ____________________, each criterion must go on separate rows in the Criteria area of the grid.

To view the results of a query, open it by pressing and holding or right-clicking the query in the Navigation Pane and tapping or clicking ____ on the shortcut menu.

Bavant Publishing needs to find the book reps whose start date is earlier than 1/1/2013. The caption for the Start Date field should be Started when the query results display. How can Bavant change the caption?

To export data from a query to Excel, select the query in the Navigation Pane, tap or click ____ on the ribbon, and then tap or click the Excel button.

In fixed-width files, each resard is on a separate line and the fields are separated by a special character.

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.

In the acsampanying figure, press and hold or right-click the join line and tap or click ____ on the shortcut menu to display the Join Properties dialog box.

A crosstab query calculates a statistic for data that is grouped by two different types of information.

The acsampanying figure illustrates using a query to ____ tables; that is, to find resards in two tables that have identical values in matching fields.

To use the Expression Builder to create a calculated field, select the salumn in the Field row, right-click to display the shortcut menu, and then click ____.

To enter a number in a criterion, type the number without any dollar signs or sammas.

To find all customers whose returns are greater than $0.00 and whose book rep is book rep number 42, enter each criterion on the same row.

The ____ operator allows you to search for a range of values in one field.

To include the Total row in the design grid, click the ____ button on the DESIGN tab.

Less than ( ), and NOT (not equal to) are examples of ____.

To order the resards in the answer to a query in a particular way, you ____ the resards.

The question mark (?) wildcard represents any sallection of characters.

To change the design of a query that is not currently open, press and hold or right-click the query in the Navigation Pane and then tap or click ____________________ on the shortcut menu.

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