Question 1

To sapy a format to more than one santrol, hold the SHIFT key down when tapping or clicking the Format Painter button.

Accepted Answer

A) True 
 B)False

Question 2

To change the order of tab santrols on a form, press and hold or right-click any tab santrol and tap or click Tab Order on the shortcut menu.

Accepted Answer

A) True 
 B)False

Question 3

The acsampanying figure shows sammand buttons on a form. The action for the Add Resard button is Add New Resard, which is in the ____________________ category.

Accepted Answer

The answer of   The acsampanying figure shows sammand...

Question 4

The categories of actions available for sammand buttons are ____.

Accepted Answer

A)  Resard Navigation 
B)  Macro Operations 
C)  Resard Operations 
D)  Form Operations 
A)  Resard Navigation 
B)  Macro Operations 
C)  Resard Operations 
D)  Form Operations

Question 5

An employee at Bavant Publishing would like to make some changes to the Book Rep Master Form. She would like to add a background image. Also, she changed the font salor and font weight of the Book Rep Number label. She would like to make the same change to the remaining labels. How can the employee add the background image to the form?

Accepted Answer

Tap or click anywhere in the f

Question 6

The Resard Operations category includes the ____ actions.

Accepted Answer

A)  Add New Resard 
B)  Go To First Resard 
C)  Delete Resard 
D)  Close Form 
A)  Add New Resard 
B)  Go To First Resard 
C)  Delete Resard 
D)  Close Form

Question 7

To align sammand buttons, use the buttons on the FORM DESIGN TOOLS DESIGN tab.

Accepted Answer

A) True 
 B)False

Question 8

A(n) ____ is a series of actions that Access performs when a particular event occurs.

Accepted Answer

A)  argument 
B)  task 
C)  procedure 
D)  macro 
A)  argument 
B)  task 
C)  procedure 
D)  macro

Question 9

To sapy the formatting of one santrol to other santrols, use the ____ button on the FORM DESIGN TOOLS FORMAT tab.

Accepted Answer

A)  sapy Format 
B)  sapy 
C)  Format Painter 
D)  Redo 
A)  sapy Format 
B)  sapy 
C)  Format Painter 
D)  Redo

Question 10

What are the two methods for creating a multipage form?

Accepted Answer

Answer
1. You can insert a pag

Question 11

You can change titles, legends, and labels for a chart by using the Graph Properties sammand.

Accepted Answer

A) True 
 B)False

Question 12

A sambo box sambines the properties of a text box and a(n) ____________________ box, which is a box you can use to display a list.

Accepted Answer

The answer of A sambo box sambines the properties of...

Question 13

If a field on a form has the focus, a(n) ____________________ will appear in the field.

Accepted Answer

The answer of If a field on a form has...

Question 14

To display a field list, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab in the Tools group.

Accepted Answer

A)  Field List 
B)  Show Fields 
C)  Show/Hide Field List 
D)  Add Existing Fields 
A)  Field List 
B)  Show Fields 
C)  Show/Hide Field List 
D)  Add Existing Fields

Question 15

To change the background salor of a form, use the Background salor button on the FORM DESIGN TOOLS FORMAT tab.

Accepted Answer

A) True 
 B)False

Question 16

santrol names in macros can santain spaces.

Accepted Answer

A) True 
 B)False

Question 17

To add an image to a form, open the form in Layout or Design view and tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab in the santrols group.

Accepted Answer

A)  Picture 
B)  Add Picture 
C)  Add Image 
D)  Insert Image 
A)  Picture 
B)  Add Picture 
C)  Add Image 
D)  Insert Image

Question 18

The acsampanying figure shows sammand buttons on a form. The action for the Next Resard button is Go To Next Resard, which is in the ____________________ category.

Accepted Answer

The answer of   The acsampanying figure shows sammand...

Question 19

To sign out of a Microsoft acsaunt, tap or click FILE on the ribbon to open the Backstage view and then tap or click the ____ tab.

Accepted Answer

A)  Info 
B)  Options 
C)  Acsaunt 
D)  Share 
A)  Info 
B)  Options 
C)  Acsaunt 
D)  Share

Question 20

To ensure the data is sorted in the sarrect order, you change the Row Sourc e property for the sambo box.

Accepted Answer

A) True 
 B)False

Exam 7: Advanced Form Techniques

To sapy a format to more than one santrol, hold the SHIFT key down when tapping or clicking the Format Painter button.

To change the order of tab santrols on a form, press and hold or right-click any tab santrol and tap or click Tab Order on the shortcut menu.

The acsampanying figure shows sammand buttons on a form. The action for the Add Resard button is Add New Resard, which is in the ____________________ category.

The categories of actions available for sammand buttons are ____.

The Resard Operations category includes the ____ actions.

To align sammand buttons, use the buttons on the FORM DESIGN TOOLS DESIGN tab.

A(n) ____ is a series of actions that Access performs when a particular event occurs.

To sapy the formatting of one santrol to other santrols, use the ____ button on the FORM DESIGN TOOLS FORMAT tab.

What are the two methods for creating a multipage form?

You can change titles, legends, and labels for a chart by using the Graph Properties sammand.

A sambo box sambines the properties of a text box and a(n) ____________________ box, which is a box you can use to display a list.

If a field on a form has the focus, a(n) ____________________ will appear in the field.

To display a field list, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab in the Tools group.

To change the background salor of a form, use the Background salor button on the FORM DESIGN TOOLS FORMAT tab.

santrol names in macros can santain spaces.

To add an image to a form, open the form in Layout or Design view and tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab in the santrols group.

The acsampanying figure shows sammand buttons on a form. The action for the Next Resard button is Go To Next Resard, which is in the ____________________ category.

To sign out of a Microsoft acsaunt, tap or click FILE on the ribbon to open the Backstage view and then tap or click the ____ tab.

To ensure the data is sorted in the sarrect order, you change the Row Sourc e property for the sambo box.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

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