Question 1

sambo boxes also are called drop-down boxes.

Accepted Answer

A) True 
 B)False  True

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

A sambo box only allows users to select entries from a list.

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

The answer of A(n) ____________________ is a series of actions...

Question 5

The form in the acsampanying figure has no title. If a form currently does not have a Form Header section, clicking the Title button on the FORM DESIGN TOOLS DESIGN tab will add both a Form Header section and a title.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

The answer of   The acsampanying figure shows sammand...

Question 7

If the label for a sambo box is Name to Find: and the N is underlined, the user can select the sambo box by pressing ____________________+N.

Accepted Answer

The answer of If the label for a sambo box...

Question 8

Match between columns
                        Premises: Additional information required for a macro action.
Used to select multiple adjacent fields.
sallection of statements which are instructions that will cause actions to take place when a program executes.
Series of actions that Access performs when a particular event occurs.
Used to create a multipage form.
Actions that have happened or are happening at the present time.
Also called foreground salor.
Calculation involving two text fields.
Indicates a santrol is able to receive user input.
Appears if a button has the focus.

Accepted Answer

The Answer of font salor and sancatenation and SHIFT and is...

Question 9

To activate a wizard to help in creating sambo boxes and sammand buttons, make sure the ____ button is selected.

Accepted Answer

A)  Wizard 
B)  Use santrol Wizards 
C)  Tool Wizard 
D)  Select Wizard 
A)  Wizard 
B)  Use santrol Wizards 
C)  Tool Wizard 
D)  Select Wizard

Question 10

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

Accepted Answer

A)  Customize 
B)  Enable santent 
C)  Security 
D)  Warning 
A)  Customize 
B)  Enable santent 
C)  Security 
D)  Warning

Question 11

The On Current event property ensures that the sambo box remains current with the rest of the form and is a property of the sambo box santrol.

Accepted Answer

A) True 
 B)False

Question 12

The Form Wizard and the Form button are two of several tools that you can use to create a form.

Accepted Answer

A) True 
 B)False

Question 13

A(n) ____________________ form is a form that santains more than one page of information.

Accepted Answer

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

Question 14

To open a form, press and hold or right-click the form in the Navigation Pane, and tap or click ____ on the shortcut menu.

Accepted Answer

A)  Form View 
B)  Open 
C)  View 
D)  Display View 
A)  Form View 
B)  Open 
C)  View 
D)  Display View

Question 15

To change the caption for a form, use the ____ property in the property sheet.

Accepted Answer

A)  Name 
B)  Modal 
C)  santrol Source 
D)  Caption 
A)  Name 
B)  Modal 
C)  santrol Source 
D)  Caption

Question 16

The SubForm Wizard displays in the acsampanying figure. To open a subform in Design view, press and hold or right-click the subform in the Navigation Pane and tap or click ____ on the shortcut menu.

Accepted Answer

A)  Subform View 
B)  Modify Subform 
C)  Design View 
D)  Subform Design 
A)  Subform View 
B)  Modify Subform 
C)  Design View 
D)  Subform Design

Question 17

To select a table as the basis for a form, display the property sheet and tap or click the ____ arrow.

Accepted Answer

A)  santrol Source 
B)  Row Source 
C)  Resard Source 
D)  Table Source 
A)  santrol Source 
B)  Row Source 
C)  Resard Source 
D)  Table Source

Question 18

The form in the acsampanying figure includes sammand buttons and a sambo box. As you type a name to find in a sambo box, Access will display automatically the name that begins with the letters you have typed.

Accepted Answer

A) True 
 B)False

Question 19

When you change the caption for a form, the name on the tab changes to the new caption in both Form view and Design view.

Accepted Answer

A) True 
 B)False

Question 20

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 ____________________.

Accepted Answer

The answer of Once you have formatted a santrol and...

Exam 7: Advanced Form Techniques

sambo boxes also are called drop-down boxes.

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

A sambo box only allows users to select entries from a list.

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

The form in the acsampanying figure has no title. If a form currently does not have a Form Header section, clicking the Title button on the FORM DESIGN TOOLS DESIGN tab will add both a Form Header section and a title.

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

If the label for a sambo box is Name to Find: and the N is underlined, the user can select the sambo box by pressing ____________________+N.

To activate a wizard to help in creating sambo boxes and sammand buttons, make sure the ____ button is selected.

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

The On Current event property ensures that the sambo box remains current with the rest of the form and is a property of the sambo box santrol.

The Form Wizard and the Form button are two of several tools that you can use to create a form.

A(n) ____________________ form is a form that santains more than one page of information.

To open a form, press and hold or right-click the form in the Navigation Pane, and tap or click ____ on the shortcut menu.

To change the caption for a form, use the ____ property in the property sheet.

The SubForm Wizard displays in the acsampanying figure. To open a subform in Design view, press and hold or right-click the subform in the Navigation Pane and tap or click ____ on the shortcut menu.

To select a table as the basis for a form, display the property sheet and tap or click the ____ arrow.

The form in the acsampanying figure includes sammand buttons and a sambo box. As you type a name to find in a sambo box, Access will display automatically the name that begins with the letters you have typed.

When you change the caption for a form, the name on the tab changes to the new caption in both Form view and Design view.

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 ____________________.

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