Question 1

When a control is active and waiting for user action, the control has focus .

Accepted Answer

A) True 
 B)False  True

Question 2

Text box controls arranged in a datasheet format with a label above each column indicates the ____ layout.

Accepted Answer

A)  stacked 
B)  tabular 
C)  columnar 
D)  grid 
A)  stacked 
B)  tabular 
C)  columnar 
D)  grid B

Question 3

Describe at least five of the nine form design guidelines presented in the text that should be followed when planning a form.

Accepted Answer

1. Determine the fields and record source needed. 
2. Group related fields and position them in a meaningful and logical order. 
3. Design the form to match the source document closely if the user will refer to the source document while working with the form. 
4. Identify each field value with a label that names the field and align field values and labels so they are easy to read. 
5. Set text box widths to display an entire value and to provide a visual cue to the user about the length of the value. 
6. Prevent users from changing and updating calculated fields and display them in a distinctive way. 
7. Use control properties and other options, such as default values and list boxes, to minimize user error and limit entries as well as to minimize keystrokes. 
8. Design forms to be uncluttered by using colors, fonts, and graphics sparingly. Also, use white space to make the controls easier to find and read. 
9. Use a consistent form style for all forms in a database to enhance the user interface with forms.,

Question 4

Case Based Critical Thinking Questions Case 6-2
Janise's College Pet Sitting business is growing rapidly. She has expanded to include more pet sitters and is creating forms for the sitters to enter information in the business database. She is creating only custom forms. Determine the best methods, features, and tools for Janise to use when creating her custom forms.
Janise will now add selected fields from the Customer table to her form. Which section of the form will contain the fields from the selected table?

Accepted Answer

A)  Properties 
B)  Detail 
C)  Header 
D)  Footer 
A)  Properties 
B)  Detail 
C)  Header 
D)  Footer

Question 5

A selected column of controls may be aligned to the left or right edges of the controls using the ARRANGE tab on the ribbon.

Accepted Answer

A) True 
 B)False

Question 6

____________________ is the default name for the first form created in a database using Design view.

Accepted Answer

The answer of ____________________ is the default name for the...

Question 7

To find records in a form using a Combo box, it is necessary to change the ____ form property of the form to the table or query that is the source for all the bound controls in the Detail section.

Accepted Answer

A)  Record Source 
B)  Default View 
C)  Caption 
D)  Modal 
A)  Record Source 
B)  Default View 
C)  Caption 
D)  Modal

Question 8

To create a custom form, the user may modify an existing form in Form view or Design view.

Accepted Answer

A) True 
 B)False

Question 9

The ____________________ property for a control will automatically resize the control and place it in the same relative position on the screen regardless of monitor size and screen resolution.

Accepted Answer

The answer of The ____________________ property for a control will...

Question 10

To increase an object's window size to view more of the vertical contents of the object, collapse the ____.

Accepted Answer

A)  Object Tabs 
B)  Property Sheet 
C)  Ribbon 
D)  Navigation Pane 
A)  Object Tabs 
B)  Property Sheet 
C)  Ribbon 
D)  Navigation Pane

Question 11

To avoid typing errors when creating a more advanced expression for a calculated control, it is a good idea to use this Access feature.

Accepted Answer

A)  Property Sheet 
B)  Controls group on the ribbon 
C)  Form view 
D)  Expression Builder 
A)  Property Sheet 
B)  Controls group on the ribbon 
C)  Form view 
D)  Expression Builder

Question 12

Case Based Critical Thinking Questions Case 6-1
Carlos has created several tables for his Organic Produce farm database including Customers, Vendors, and Products. Now he wants to create forms that will make it easier to enter data in the database. Determine the best methods for Carlos to use when creating forms for his specific needs.
After reviewing the simple form, Carlos decides that he needs a form which is customized to make data entry more accurate and less cumbersome. Because most of his products are already in the database, he would like to use a list to choose the product during data entry. However, there are times that a product might not be available in the database, and it needs to be added. What is the best type of control for Carlos to use in his custom form to meet this requirement?

Accepted Answer

A)  Combo box 
B)  List box 
C)  Text box 
D)  Calculated box 
A)  Combo box 
B)  List box 
C)  Text box 
D)  Calculated box

Question 13

The caption that displays in a label cannot be changed in Design view when creating a form.

Accepted Answer

A) True 
 B)False

Question 14

List five suggestions that help prevent common problems and recover from errors while building forms.

Accepted Answer

1. Use the Undo button one or more times

Question 15

A(n) ____________________ is an unbound control that displays text.

Accepted Answer

The answer of A(n) ____________________ is an unbound control that...

Question 16

Controls placed at the top of a form in the ____________________ remain on the screen when the form is displayed in Form view or Layout view and do not change when the contents of the Detail section are changed or when navigating from one record to another record.

Accepted Answer

The answer of Controls placed at the top of a...

Question 17

To improve a form's readability, group related information or underline important values using the ____________________ tool in the form's Design view.

Accepted Answer

The answer of To improve a form's readability, group related...

Question 18

The ____ option in the Tab Order dialog box allows a tab order of left-to-right or top-to-bottom.

Accepted Answer

A)  Auto Order 
B)  Move 
C)  Custom Order 
D)  Tab Stop 
A)  Auto Order 
B)  Move 
C)  Custom Order 
D)  Tab Stop

Question 19

The ____ refers to the order in which the focus moves from one control to another control when a user presses the Tab key.

Accepted Answer

A)  tab alignment 
B)  tab stop 
C)  tab order 
D)  tab focus 
A)  tab alignment 
B)  tab stop 
C)  tab order 
D)  tab focus

Question 20

The record source for a subform must be a table.

Accepted Answer

A) True 
 B)False

When a control is active and waiting for user action, the control has focus .

Text box controls arranged in a datasheet format with a label above each column indicates the ____ layout.

Describe at least five of the nine form design guidelines presented in the text that should be followed when planning a form.

A selected column of controls may be aligned to the left or right edges of the controls using the ARRANGE tab on the ribbon.

____________________ is the default name for the first form created in a database using Design view.

To find records in a form using a Combo box, it is necessary to change the ____ form property of the form to the table or query that is the source for all the bound controls in the Detail section.

To create a custom form, the user may modify an existing form in Form view or Design view.

The ____________________ property for a control will automatically resize the control and place it in the same relative position on the screen regardless of monitor size and screen resolution.

To increase an object's window size to view more of the vertical contents of the object, collapse the ____.

To avoid typing errors when creating a more advanced expression for a calculated control, it is a good idea to use this Access feature.

The caption that displays in a label cannot be changed in Design view when creating a form.

List five suggestions that help prevent common problems and recover from errors while building forms.

A(n) ____________________ is an unbound control that displays text.

Controls placed at the top of a form in the ____________________ remain on the screen when the form is displayed in Form view or Layout view and do not change when the contents of the Detail section are changed or when navigating from one record to another record.

To improve a form's readability, group related information or underline important values using the ____________________ tool in the form's Design view.

The ____ option in the Tab Order dialog box allows a tab order of left-to-right or top-to-bottom.

The ____ refers to the order in which the focus moves from one control to another control when a user presses the Tab key.

The record source for a subform must be a table.

Access: Creating Advanced Queries and Enhancing Table Design

Access: Creating Custom Reports

Access: Sharing, Integrating, and Analyzing Data

Excell: Working With Excel Tables, Pivottables, and Pivotcharts

Excell: Managing Multiple Worksheets and Workbooks

Excell: Developing an Excel Application

Excell: Working With Advanced Functions

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters

Exam 2: Access: Using Form Tools and Creating Custom Forms

When a control is active and waiting for user action, the control has focus .

Text box controls arranged in a datasheet format with a label above each column indicates the ____ layout.

Describe at least five of the nine form design guidelines presented in the text that should be followed when planning a form.

A selected column of controls may be aligned to the left or right edges of the controls using the ARRANGE tab on the ribbon.

____________________ is the default name for the first form created in a database using Design view.

To find records in a form using a Combo box, it is necessary to change the ____ form property of the form to the table or query that is the source for all the bound controls in the Detail section.

To create a custom form, the user may modify an existing form in Form view or Design view.

The ____________________ property for a control will automatically resize the control and place it in the same relative position on the screen regardless of monitor size and screen resolution.

To increase an object's window size to view more of the vertical contents of the object, collapse the ____.

To avoid typing errors when creating a more advanced expression for a calculated control, it is a good idea to use this Access feature.

The caption that displays in a label cannot be changed in Design view when creating a form.

List five suggestions that help prevent common problems and recover from errors while building forms.

A(n) ____________________ is an unbound control that displays text.

Controls placed at the top of a form in the ____________________ remain on the screen when the form is displayed in Form view or Layout view and do not change when the contents of the Detail section are changed or when navigating from one record to another record.

To improve a form's readability, group related information or underline important values using the ____________________ tool in the form's Design view.

The ____ option in the Tab Order dialog box allows a tab order of left-to-right or top-to-bottom.

The ____ refers to the order in which the focus moves from one control to another control when a user presses the Tab key.

The record source for a subform must be a table.

Access: Creating Advanced Queries and Enhancing Table Design

Access: Creating Custom Reports

Access: Sharing, Integrating, and Analyzing Data

Excell: Working With Excel Tables, Pivottables, and Pivotcharts

Excell: Managing Multiple Worksheets and Workbooks

Excell: Developing an Excel Application

Excell: Working With Advanced Functions

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters