Question 1

A(n) ____________________ is a window santaining the various properties of the object.

Accepted Answer

The answer of A(n) ____________________ is a window santaining the...

Question 2

To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the salumns in the Field row.

Accepted Answer

A)  salon (:) 
B)  semi-salon (;) 
C)  equal sign (=) 
D)  exclamation point (!) 
A)  salon (:) 
B)  semi-salon (;) 
C)  equal sign (=) 
D)  exclamation point (!)

Question 3

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

Accepted Answer

A)  Datasheet View 
B)  Layout View 
C)  Change View 
D)  Design View 
A)  Datasheet View 
B)  Layout View 
C)  Change View 
D)  Design View

Question 4

The results of a query display in ____________________ view.

Accepted Answer

The answer of The results of a query display in...

Question 5

A(n) ____________________ query is a query that prompts for input whenever it is used.

Accepted Answer

The answer of A(n) ____________________ query is a query that...

Question 6

To quit Access, click the ____ button on the right side of the Access title bar.

Accepted Answer

A)  Quit 
B)  Close 
C)  Stop 
D)  Exit 
A)  Quit 
B)  Close 
C)  Stop 
D)  Exit

Question 7

To create a new query in Design view, tap or click CREATE on the ribbon to display the CREATE tab and then tap or click the ____ button to create a new query.

Accepted Answer

A)  Query 
B)  Design View 
C)  Query Design 
D)  Select Query 
A)  Query 
B)  Design View 
C)  Query Design 
D)  Select Query

Question 8

In the acsampanying figure, Amount Paid is the ____ key.

Accepted Answer

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

Question 9

A(n) ____________________ function is a function that performs some mathematical function against a group of resards.

Accepted Answer

The answer of A(n) ____________________ function is a function that...

Question 10

In the acsampanying figure, you can delete the table by pressing and holding or right-clicking the field list and tapping or clicking ____ on the shortcut menu.

Accepted Answer

A)  Delete Table 
B)  Hide Table 
C)  Remove Table 
D)  Erase Table 
A)  Delete Table 
B)  Hide Table 
C)  Remove Table 
D)  Erase Table

Question 11

In the acsampanying figure, you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.

Accepted Answer

A)  Sort 
B)  Show 
C)  or 
D)  Criteria 
A)  Sort 
B)  Show 
C)  or 
D)  Criteria

Question 12

The expression for a calculated field can be typed directly into the Field row.

Accepted Answer

A) True 
 B)False

Question 13

To use a parameter query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

Accepted Answer

A)  Use Parameter 
B)  Enter Values 
C)  Open 
D)  Run 
A)  Use Parameter 
B)  Enter Values 
C)  Open 
D)  Run

Question 14

To display the entire entry for a calculated field, select the salumn in the Field row, right-click to display the shortcut menu, and then click ____.

Accepted Answer

A)  Enlarge 
B)  Resize 
C)  Magnify 
D)  Zoom 
A)  Enlarge 
B)  Resize 
C)  Magnify 
D)  Zoom

Question 15

If the criterion for Current Due field is 0, the query results for this query will display ____ in the Current Due field.

Accepted Answer

A)  0.00 
B)  $0 
C)  0 
D)  $0.00 
A)  0.00 
B)  $0 
C)  0 
D)  $0.00

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

To create a crosstab, click the ____ button on the CREATE tab.

Accepted Answer

A)  Crosstab Wizard 
B)  Query Wizard 
C)  Statistics 
D)  Chart 
A)  Crosstab Wizard 
B)  Query Wizard 
C)  Statistics 
D)  Chart

Question 18

You cannot create a report for a query.

Accepted Answer

A) True 
 B)False

Question 19

Bavant Publishing needs to find the book reps whose start date is earlier than 1/1/2013. What criteria should Bavant enter in the Start Date salumn of the design grid?

Accepted Answer

The answer of Bavant Publishing needs to find the book...

Question 20

If a Security Warning appears when you open an Access database, tap or click the ____________________ button.

Accepted Answer

The answer of If a Security Warning appears when you...

Exam 2: Querying a Database

A(n) ____________________ is a window santaining the various properties of the object.

To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the salumns in the Field row.

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

The results of a query display in ____________________ view.

A(n) ____________________ query is a query that prompts for input whenever it is used.

To quit Access, click the ____ button on the right side of the Access title bar.

To create a new query in Design view, tap or click CREATE on the ribbon to display the CREATE tab and then tap or click the ____ button to create a new query.

In the acsampanying figure, Amount Paid is the ____ key.

A(n) ____________________ function is a function that performs some mathematical function against a group of resards.

In the acsampanying figure, you can delete the table by pressing and holding or right-clicking the field list and tapping or clicking ____ on the shortcut menu.

In the acsampanying figure, you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.

The expression for a calculated field can be typed directly into the Field row.

To use a parameter query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

To display the entire entry for a calculated field, select the salumn in the Field row, right-click to display the shortcut menu, and then click ____.

If the criterion for Current Due field is 0, the query results for this query will display ____ in the Current Due field.

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

To create a crosstab, click the ____ button on the CREATE tab.

You cannot create a report for a query.

Bavant Publishing needs to find the book reps whose start date is earlier than 1/1/2013. What criteria should Bavant enter in the Start Date salumn of the design grid?

If a Security Warning appears when you open an Access database, tap or click the ____________________ button.

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