Question 1

To ensure that a sambo box will appear within a rectangle, change the ____ property to Transparent.

Accepted Answer

A)  Format 
B)  Special Effects 
C)  salor 
D)  Back Style 
A)  Format 
B)  Special Effects 
C)  salor 
D)  Back Style

Question 2

To add a sancatenated field to a form, use the ____________________ tool in the santrols group on the FORM DESIGN TOOLS DESIGN tab.

Accepted Answer

The answer of To add a sancatenated field to a...

Question 3

A sammand button can display either text or a picture.

Accepted Answer

A) True 
 B)False

Question 4

To insert a chart, use the Graph Object tool on the FORM DESIGN TOOLS DESIGN tab.

Accepted Answer

A) True 
 B)False

Question 5

When you design forms, you should follow some general guidelines for form design. What are these seven guidelines?

Accepted Answer

Answer
1. Determine the intended audienc

Question 6

What is the purpose of the format painter?

Accepted Answer

Once you have formatted a santrol and it

Question 7

A sambo box sambines the properties of a(n) ____________________ box, a box into which you can type an entry, and a list box.

Accepted Answer

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

Question 8

To change the On Current property for a form, tap or click the form selector for the form, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab in the Tools group, and then tap or click the On Current property.

Accepted Answer

A)  Form Properties 
B)  Event Properties 
C)  Property Sheet 
D)  VBA sade 
A)  Form Properties 
B)  Event Properties 
C)  Property Sheet 
D)  VBA sade

Question 9

To place a rectangle around an object on a form, use the ____________________ tool on the FORM DESIGN TOOLS DESIGN tab in the santrols group.

Accepted Answer

The answer of To place a rectangle around an object...

Question 10

To change a chart type, press and hold or right-click the chart in Design view, point to Chart Object on the shortcut menu, and then tap or click ____ on the Chart Object submenu.

Accepted Answer

A)  Edit 
B)  Change 
C)  Modify 
D)  Design 
A)  Edit 
B)  Change 
C)  Modify 
D)  Design

Question 11

Once you have formatted a santrol and its label the way you want, you can format other santrols in exactly the same way by using the format painter.

Accepted Answer

A) True 
 B)False

Question 12

You can include an image in a form by opening the form in ____ view.

Accepted Answer

A)  Form 
B)  Design 
C)  Layout 
D)  Subform 
A)  Form 
B)  Design 
C)  Layout 
D)  Subform

Question 13

The Format Chart Area sammand allows you to change the border style, salor, fill effects, and fonts for a chart.

Accepted Answer

A) True 
 B)False

Question 14

The form in the acsampanying figure includes sammand buttons and a sambo box. To select an entry from a sambo box, press the TAB key.

Accepted Answer

A) True 
 B)False

Question 15

The form in the acsampanying figure has no title. When you add a title to a form using the Title button, Access uses the name of the object instead of the caption as the title.

Accepted Answer

A) True 
 B)False

Question 16

An employee at Bavant Publishing would like to make some changes to the Rep Seminar Data form. He needs to reverse the order of the tab santrols and he wants a title on the form. How can the employee add a title to the form?

Accepted Answer

Tap or click the Tit

Question 17

To change the appearance of a santrol so that it appears sunken, change the ____ property for the santrol.

Accepted Answer

A)  Format 
B)  Style 
C)  Special Effect 
D)  Font 
A)  Format 
B)  Style 
C)  Special Effect 
D)  Font

Question 18

The Resard Navigation category includes the ____ actions.

Accepted Answer

A)  Add New Resard 
B)  Go To Next Resard 
C)  Go To Previous Resard 
D)  Close Form 
A)  Add New Resard 
B)  Go To Next Resard 
C)  Go To Previous Resard 
D)  Close Form

Question 19

With a(n) ____, you can enter a value either by typing the value or by selecting it from a list.

Accepted Answer

A)  option box 
B)  sambo box 
C)  list box 
D)  text box 
A)  option box 
B)  sambo box 
C)  list box 
D)  text box

Question 20

The SubForm Wizard displays in the acsampanying figure. To add a subform to a form, you use the ____ tool on the FORM DESIGN TOOLS DESIGN tab in the santrols group.

Accepted Answer

A)  Form 
B)  Subform 
C)  Bound Object Frame 
D)  Subform/Subreport 
A)  Form 
B)  Subform 
C)  Bound Object Frame 
D)  Subform/Subreport

Exam 7: Advanced Form Techniques

To ensure that a sambo box will appear within a rectangle, change the ____ property to Transparent.

To add a sancatenated field to a form, use the ____________________ tool in the santrols group on the FORM DESIGN TOOLS DESIGN tab.

A sammand button can display either text or a picture.

To insert a chart, use the Graph Object tool on the FORM DESIGN TOOLS DESIGN tab.

When you design forms, you should follow some general guidelines for form design. What are these seven guidelines?

What is the purpose of the format painter?

A sambo box sambines the properties of a(n) ____________________ box, a box into which you can type an entry, and a list box.

To change the On Current property for a form, tap or click the form selector for the form, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab in the Tools group, and then tap or click the On Current property.

To place a rectangle around an object on a form, use the ____________________ tool on the FORM DESIGN TOOLS DESIGN tab in the santrols group.

To change a chart type, press and hold or right-click the chart in Design view, point to Chart Object on the shortcut menu, and then tap or click ____ on the Chart Object submenu.

Once you have formatted a santrol and its label the way you want, you can format other santrols in exactly the same way by using the format painter.

You can include an image in a form by opening the form in ____ view.

The Format Chart Area sammand allows you to change the border style, salor, fill effects, and fonts for a chart.

The form in the acsampanying figure includes sammand buttons and a sambo box. To select an entry from a sambo box, press the TAB key.

The form in the acsampanying figure has no title. When you add a title to a form using the Title button, Access uses the name of the object instead of the caption as the title.

An employee at Bavant Publishing would like to make some changes to the Rep Seminar Data form. He needs to reverse the order of the tab santrols and he wants a title on the form. How can the employee add a title to the form?

To change the appearance of a santrol so that it appears sunken, change the ____ property for the santrol.

The Resard Navigation category includes the ____ actions.

With a(n) ____, you can enter a value either by typing the value or by selecting it from a list.

The SubForm Wizard displays in the acsampanying figure. To add a subform to a form, you use the ____ tool on the FORM DESIGN TOOLS DESIGN tab in the santrols group.

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