Question 1

Some database designers prefer to create their own form to collect the parameters and then pass those along to the query or report.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is an error message that indicates that Access can't evaluate the expression that provides the control's value?

Accepted Answer

A)  #Name? 
B)  #Error 
C)  #Wrong 
D)  #Change 
A)  #Name? 
B)  #Error 
C)  #Wrong 
D)  #Change

Question 3

Why is it sometimes necessary to change the size of form sections?

Accepted Answer

Many times the default size of a section

Question 4

Which of the following properties determines whether a control can have the focus?

Accepted Answer

A)  Locked property 
B)  Enabled property 
C)  Cycle property 
D)  Border Color property 
A)  Locked property 
B)  Enabled property 
C)  Cycle property 
D)  Border Color property

Question 5

Which of the following views will you use the most when editing a form?

Accepted Answer

A)  Design view 
B)  Layout view 
C)  Print Preview view 
D)  both A and B 
A)  Design view 
B)  Layout view 
C)  Print Preview view 
D)  both A and B

Question 6

Which of the following properties determines whether a user can change the contents in a field?

Accepted Answer

A)  Locked property 
B)  Enabled property 
C)  Cycle property 
D)  Border Color property 
A)  Locked property 
B)  Enabled property 
C)  Cycle property 
D)  Border Color property

Question 7

Which of the following colors implies "go" or "continue"?

Accepted Answer

A)  red 
B)  green 
C)  yellow 
D)  black 
A)  red 
B)  green 
C)  yellow 
D)  black

Question 8

Which of the following statements is true about modifying a navigation form?

Accepted Answer

A)  When a navigation form is created,it includes an Auto_Header()label added into the Form Header section. 
B)  Edit the contents of the Caption property to change the wording of the label at the top of the navigation form. 
C)  By default,the navigation tab displays as a rectangle. 
D)  all of the above 
A)  When a navigation form is created,it includes an Auto_Header()label added into the Form Header section. 
B)  Edit the contents of the Caption property to change the wording of the label at the top of the navigation form. 
C)  By default,the navigation tab displays as a rectangle. 
D)  all of the above

Question 9

You can include navigation forms in databases that you publish to a SharePoint server to make them available on the web.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following properties controls what happens when the user tabs out of the last field in a record?

Accepted Answer

A)  Tab Index property 
B)  Tab Stop property 
C)  Cycle property 
D)  focus 
A)  Tab Index property 
B)  Tab Stop property 
C)  Cycle property 
D)  focus

Question 11

Why might you want to enhance the design of a basic form?

Accepted Answer

A)  to make the form more visually appealing 
B)  to make the form easier to use 
C)  to make the form more helpful for users 
D)  all of the above 
A)  to make the form more visually appealing 
B)  to make the form easier to use 
C)  to make the form more helpful for users 
D)  all of the above

Question 12

Which of the following lets you add a subform into a main form?

Accepted Answer

A)  Subform Wizard 
B)  Subreport Wizard 
C)  Subform/ Subreport Wizard 
D)  Mainform Wizard 
A)  Subform Wizard 
B)  Subreport Wizard 
C)  Subform/ Subreport Wizard 
D)  Mainform Wizard

Question 13

The #Error error indicates that Access can't evaluate the expression that provides the control's value.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following color properties sets a different background color for alternating rows in form layouts that show multiple records?

Accepted Answer

A)  Back Color 
B)  Alternate Back Color 
C)  Border Color 
D)  Fore Color 
A)  Back Color 
B)  Alternate Back Color 
C)  Border Color 
D)  Fore Color

Question 15

After applying a new theme,you can modify any parts that you don't like.

Accepted Answer

A) True 
 B)False

Question 16

If Access was not able to determine the correct linking fields between the subform and the main form or if you created an incorrect link,you can manually establish the link.

Accepted Answer

A) True 
 B)False

Question 17

When you create a form in Design view,all sections,including the Detail section,are automatically added to the form.

Accepted Answer

A) True 
 B)False

Question 18

The Page Footer form section displays information when a form is printed,and is only visible in Design or Print Preview view.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is an error message that means that you have used an invalid name for a field,control,form,or function?

Accepted Answer

A)  #Name? 
B)  #Error 
C)  #Wrong 
D)  #Change 
A)  #Name? 
B)  #Error 
C)  #Wrong 
D)  #Change

Question 20

The Insert Image button inserts an embedded image.

Accepted Answer

A) True 
 B)False

Some database designers prefer to create their own form to collect the parameters and then pass those along to the query or report.

Which of the following is an error message that indicates that Access can't evaluate the expression that provides the control's value?

Why is it sometimes necessary to change the size of form sections?

Which of the following properties determines whether a control can have the focus?

Which of the following views will you use the most when editing a form?

Which of the following properties determines whether a user can change the contents in a field?

Which of the following colors implies "go" or "continue"?

Which of the following statements is true about modifying a navigation form?

You can include navigation forms in databases that you publish to a SharePoint server to make them available on the web.

Which of the following properties controls what happens when the user tabs out of the last field in a record?

Why might you want to enhance the design of a basic form?

Which of the following lets you add a subform into a main form?

The #Error error indicates that Access can't evaluate the expression that provides the control's value.

Which of the following color properties sets a different background color for alternating rows in form layouts that show multiple records?

After applying a new theme,you can modify any parts that you don't like.

If Access was not able to determine the correct linking fields between the subform and the main form or if you created an incorrect link,you can manually establish the link.

When you create a form in Design view,all sections,including the Detail section,are automatically added to the form.

The Page Footer form section displays information when a form is printed,and is only visible in Design or Print Preview view.

Which of the following is an error message that means that you have used an invalid name for a field,control,form,or function?

The Insert Image button inserts an embedded image.

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters

Exam 4: Creating and Using Forms and Reports

Some database designers prefer to create their own form to collect the parameters and then pass those along to the query or report.

Which of the following is an error message that indicates that Access can't evaluate the expression that provides the control's value?

Why is it sometimes necessary to change the size of form sections?

Which of the following properties determines whether a control can have the focus?

Which of the following views will you use the most when editing a form?

Which of the following properties determines whether a user can change the contents in a field?

Which of the following colors implies "go" or "continue"?

Which of the following statements is true about modifying a navigation form?

You can include navigation forms in databases that you publish to a SharePoint server to make them available on the web.

Which of the following properties controls what happens when the user tabs out of the last field in a record?

Why might you want to enhance the design of a basic form?

Which of the following lets you add a subform into a main form?

The #Error error indicates that Access can't evaluate the expression that provides the control's value.

Which of the following color properties sets a different background color for alternating rows in form layouts that show multiple records?

After applying a new theme,you can modify any parts that you don't like.

If Access was not able to determine the correct linking fields between the subform and the main form or if you created an incorrect link,you can manually establish the link.

When you create a form in Design view,all sections,including the Detail section,are automatically added to the form.

The Page Footer form section displays information when a form is printed,and is only visible in Design or Print Preview view.

Which of the following is an error message that means that you have used an invalid name for a field,control,form,or function?

The Insert Image button inserts an embedded image.

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters