Question 1

Match between columns
                        Premises: Identifies the purpose of the form.
Requires a professional appearance and minimal graphics.
Identifies the information in the field.
Require arrangement in a meaningful order.
Displays the actual information from the table.

Accepted Answer

The Answer of text box and form layout and form is...

Question 2

Aligning controls in a form is a complicated process.

Accepted Answer

A) True 
 B)False  False

Question 3

A(n) ____________________ is a graphic or picture that can be placed in a form.

Accepted Answer

logo

Question 4

Case AC 9-1 Sandy is the owner of a bakery specializing in healthy baked goods. As a new service for her customers, Sandy has decided to provide a public, interactive customer kiosk within her store that will allow all customers to gain information about her products. Sandy will use an Access database and present various forms on the kiosk window from which customers can select information. Due to your extensive knowledge in Access database form creation, Sandy has asked for your help in developing the forms. As you begin designing Sandy's kiosk forms, what is an initial design feature to consider before deciding on a theme?

Accepted Answer

A)  field organization 
B)  error prevention 
C)  form layout 
D)  all of the above 
A)  field organization 
B)  error prevention 
C)  form layout 
D)  all of the above

Question 5

A(n) ____________________ button is a button that users can click to perform common tasks.

Accepted Answer

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

Question 6

A(n) ____________________ displays a list of values and lets you select one from the list.

Accepted Answer

The answer of A(n) ____________________ displays a list of values...

Question 7

Most people use tables to enter and retrieve data.

Accepted Answer

A) True 
 B)False

Question 8

Consistency in form design will ____.

Accepted Answer

A)  reduce the chance of errors 
B)  increase data accuracy 
C)  simplify the data entry 
D)  all of the above 
A)  reduce the chance of errors 
B)  increase data accuracy 
C)  simplify the data entry 
D)  all of the above

Question 9

Themes are available in the Features gallery on the Ribbon.

Accepted Answer

A) True 
 B)False

Question 10

____ buttons aid in record navigation and record operation.

Accepted Answer

A)  Control 
B)  Combo 
C)  Command 
D)  Calculate 
A)  Control 
B)  Combo 
C)  Command 
D)  Calculate

Question 11

The tab order can be changed in Design view by selecting the ____ button in the Tools group of the Design tab.

Accepted Answer

A)  Change Order 
B)  Tab Order 
C)  Reorder 
D)  Reset 
A)  Change Order 
B)  Tab Order 
C)  Reorder 
D)  Reset

Question 12

Even though Access offers its own navigation buttons in the document window, ____ buttons make navigating easier.

Accepted Answer

A)  control 
B)  combo 
C)  command 
D)  calculate 
A)  control 
B)  combo 
C)  command 
D)  calculate

Question 13

To change from ascending order to descending order in any of the Wizard dialog boxes, you click the Reorder button.

Accepted Answer

A) True 
 B)False

Question 14

By selecting an option from the combo box list, instead of typing lengthy text, you ____.

Accepted Answer

A)  increase the accuracy of the information 
B)  increase security 
C)  increase color combination brightness 
D)  can link to other subforms for more options 
A)  increase the accuracy of the information 
B)  increase security 
C)  increase color combination brightness 
D)  can link to other subforms for more options

Question 15

A consistent design can be created with the use of properties .

Accepted Answer

A) True 
 B)False

Question 16

Discuss how to size and align a control.

Accepted Answer

After you add a control, such as a combo

Question 17

Record navigation refers to moving within the records in a form.

Accepted Answer

A) True 
 B)False

Question 18

With a combo box, you simply click the combo box ____ and select an option from the list.

Accepted Answer

A)  arrow 
B)  button 
C)  number 
D)  field 
A)  arrow 
B)  button 
C)  number 
D)  field

Question 19

Going to the next record or to the previous record is an example of ____.

Accepted Answer

A)  record navigation 
B)  record operation 
C)  form navigation 
D)  form operation 
A)  record navigation 
B)  record operation 
C)  form navigation 
D)  form operation

Question 20

If the values in the fields are changed, the calculated control recalculates and displays the new values.

Accepted Answer

A) True 
 B)False

Exam 9: Using Advanced Form Features

Aligning controls in a form is a complicated process.

A(n) ____________________ is a graphic or picture that can be placed in a form.

A(n) ____________________ button is a button that users can click to perform common tasks.

A(n) ____________________ displays a list of values and lets you select one from the list.

Most people use tables to enter and retrieve data.

Consistency in form design will ____.

Themes are available in the Features gallery on the Ribbon.

____ buttons aid in record navigation and record operation.

The tab order can be changed in Design view by selecting the ____ button in the Tools group of the Design tab.

Even though Access offers its own navigation buttons in the document window, ____ buttons make navigating easier.

To change from ascending order to descending order in any of the Wizard dialog boxes, you click the Reorder button.

By selecting an option from the combo box list, instead of typing lengthy text, you ____.

A consistent design can be created with the use of properties .

Discuss how to size and align a control.

Record navigation refers to moving within the records in a form.

With a combo box, you simply click the combo box ____ and select an option from the list.

Going to the next record or to the previous record is an example of ____.

If the values in the fields are changed, the calculated control recalculates and displays the new values.

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters