Question 1

Match between columns
                        Premises: Other tab
Event tab
Data tab
Format tab
All tab

Accepted Answer

The Answer of Properties not included elsewhere and All properties is...

Question 2

Bound forms can be used to specify parameters,create buttons to print reports,provide navigation menus,and other similar operations.

Accepted Answer

A) True 
 B)False

Question 3

The Miscellaneous tab of the property sheet contains all other properties that are not on one of the other tabs,such as name or datasheet caption.

Accepted Answer

A) True 
 B)False

Question 4

A ________ is a form embedded in a form.

Accepted Answer

The answer of A ________ is a form embedded in...

Question 5

If the ________ property is No,the data cannot be entered or copied.

Accepted Answer

A) locked 
B) editing 
C) tab 
D) enabled 
A) locked 
B) editing 
C) tab 
D) enabled

Question 6

Which of the following is true regarding calculated controls?

Accepted Answer

A) Expressions for a calculated control can only be created in the Expression Builder. 
B) A calculated control is a control whose source of data is an expression rather than a field. 
C) Not all expressions are available for use on a form. 
D) Access limits the amount of calculated controls that can be placed on a form. 
A) Expressions for a calculated control can only be created in the Expression Builder. 
B) A calculated control is a control whose source of data is an expression rather than a field. 
C) Not all expressions are available for use on a form. 
D) Access limits the amount of calculated controls that can be placed on a form.

Question 7

Which of the following is NOT true in regard to tabs on a form?

Accepted Answer

A) The tab order is based on the initial location of the control on the form. 
B) When you add a new field to the form,unless it is placed after all the other controls,you will have to adjust the tab order. 
C) Moving a control to a new spot on the form does not change the tab order of the control. 
D) The tab order is changed in the Tab Order dialog box that is accessed from Design view. 
A) The tab order is based on the initial location of the control on the form. 
B) When you add a new field to the form,unless it is placed after all the other controls,you will have to adjust the tab order. 
C) Moving a control to a new spot on the form does not change the tab order of the control. 
D) The tab order is changed in the Tab Order dialog box that is accessed from Design view.

Question 8

A control is an object on a form or report that displays data,performs actions,and lets you view and work with information.

Accepted Answer

A) True 
 B)False

Question 9

________ forms can be created by using either the Page Break tool or the Tab Control tool.

Accepted Answer

The answer of ________ forms can be created by using...

Question 10

Which of the following is NOT true regarding bound forms?

Accepted Answer

A) The field lengths are defined as you progress through the wizard. 
B) When you create a form from a table using the wizard,the form is bound to the table you used to run the wizard. 
C) The field labels are the captions defined for the fields in the table design. 
D) The formatting for the fields is based upon the field definitions in the table design. 
A) The field lengths are defined as you progress through the wizard. 
B) When you create a form from a table using the wizard,the form is bound to the table you used to run the wizard. 
C) The field labels are the captions defined for the fields in the table design. 
D) The formatting for the fields is based upon the field definitions in the table design.

Question 11

When you add an existing field to a form,Access adds two controls.Which of the following is NOT true regarding these two controls?

Accepted Answer

A) The large grey handle in the top-left corner is called the sizing handle.The smaller orange handles are move handles.Sizing handles are used to resize the control. 
B) One is the bound control (a text box)tied to a database field.The second is an unbound control that labels the text box. 
C) The two controls are attached to each other.They can be moved as a pair or separately. 
D) When a control is selected,Access outlines the control in orange. 
A) The large grey handle in the top-left corner is called the sizing handle.The smaller orange handles are move handles.Sizing handles are used to resize the control. 
B) One is the bound control (a text box)tied to a database field.The second is an unbound control that labels the text box. 
C) The two controls are attached to each other.They can be moved as a pair or separately. 
D) When a control is selected,Access outlines the control in orange.

Question 12

The large grey handle in the top-left corner is called the ________.

Accepted Answer

A) sizing handle 
B) resizing handle 
C) delete handle 
D) move handle 
A) sizing handle 
B) resizing handle 
C) delete handle 
D) move handle

Question 13

The ________ is used for creation of the form.

Accepted Answer

The answer of The ________ is used for creation of...

Question 14

The Default Value,an option on the Data tab in the Property Sheet pane,allows you to define a value that will automatically appear in a new blank record.

Accepted Answer

A) True 
 B)False

Question 15

A footer can be added in ________ view.

Accepted Answer

The answer of A footer can be added in ________...

Question 16

Which of the following is NOT true about adding and stacking fields?

Accepted Answer

A) When a control is selected,Access outlines the control in yellow. 
B) When you add an existing field,Access adds two controls. 
C) If you use your pointer to move the control,without clicking on the move handle,you will move both controls at the same time. 
D) If you click the move handle,you will move just one control. 
A) When a control is selected,Access outlines the control in yellow. 
B) When you add an existing field,Access adds two controls. 
C) If you use your pointer to move the control,without clicking on the move handle,you will move both controls at the same time. 
D) If you click the move handle,you will move just one control.

Question 17

A ________ is created when fields from two or more related tables are used to create a form.

Accepted Answer

A) footer 
B) subform 
C) header 
D) detail section 
A) footer 
B) subform 
C) header 
D) detail section

Question 18

When you create a form from a table using the wizard,the form is bound to the table you used to run the wizard.

Accepted Answer

A) True 
 B)False

Question 19

The ________ tab is where properties that change the display of a field or form part are listed.

Accepted Answer

A) Macro 
B) Event 
C) Data 
D) Format 
A) Macro 
B) Event 
C) Data 
D) Format

Bound forms can be used to specify parameters,create buttons to print reports,provide navigation menus,and other similar operations.

The Miscellaneous tab of the property sheet contains all other properties that are not on one of the other tabs,such as name or datasheet caption.

A ________ is a form embedded in a form.

If the ________ property is No,the data cannot be entered or copied.

Which of the following is true regarding calculated controls?

Which of the following is NOT true in regard to tabs on a form?

A control is an object on a form or report that displays data,performs actions,and lets you view and work with information.

________ forms can be created by using either the Page Break tool or the Tab Control tool.

Which of the following is NOT true regarding bound forms?

When you add an existing field to a form,Access adds two controls.Which of the following is NOT true regarding these two controls?

The large grey handle in the top-left corner is called the ________.

The ________ is used for creation of the form.

The Default Value,an option on the Data tab in the Property Sheet pane,allows you to define a value that will automatically appear in a new blank record.

A footer can be added in ________ view.

Which of the following is NOT true about adding and stacking fields?

A ________ is created when fields from two or more related tables are used to create a form.

When you create a form from a table using the wizard,the form is bound to the table you used to run the wizard.

The ________ tab is where properties that change the display of a field or form part are listed.

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 4: Access Information From an Access Database

Workshop 5: Advanced Tables

Workshop 6: Pattern Matching and Functions in Queries

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters

Exam 10: Workshop 10: Advanced Form Settings and Form Types

Bound forms can be used to specify parameters,create buttons to print reports,provide navigation menus,and other similar operations.

The Miscellaneous tab of the property sheet contains all other properties that are not on one of the other tabs,such as name or datasheet caption.

A ________ is a form embedded in a form.

If the ________ property is No,the data cannot be entered or copied.

Which of the following is true regarding calculated controls?

Which of the following is NOT true in regard to tabs on a form?

A control is an object on a form or report that displays data,performs actions,and lets you view and work with information.

________ forms can be created by using either the Page Break tool or the Tab Control tool.

Which of the following is NOT true regarding bound forms?

When you add an existing field to a form,Access adds two controls.Which of the following is NOT true regarding these two controls?

The large grey handle in the top-left corner is called the ________.

The ________ is used for creation of the form.

The Default Value,an option on the Data tab in the Property Sheet pane,allows you to define a value that will automatically appear in a new blank record.

A footer can be added in ________ view.

Which of the following is NOT true about adding and stacking fields?

A ________ is created when fields from two or more related tables are used to create a form.

When you create a form from a table using the wizard,the form is bound to the table you used to run the wizard.

The ________ tab is where properties that change the display of a field or form part are listed.

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 4: Access Information From an Access Database

Workshop 5: Advanced Tables

Workshop 6: Pattern Matching and Functions in Queries

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters