Question 1

Navigation buttons can be removed from any form.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following statements is true about working with main forms and subforms?

Accepted Answer

A)  When you open a main form,the subform opens automatically. 
B)  You can open the subform separately and edit just that object. 
C)  After you add the subform to the main form,you will want to customize the overall form so that it has a professional appearance. 
D)  all of the above 
A)  When you open a main form,the subform opens automatically. 
B)  You can open the subform separately and edit just that object. 
C)  After you add the subform to the main form,you will want to customize the overall form so that it has a professional appearance. 
D)  all of the above

Question 3

Which of the following should you do to correct either the #Name? error or the #Error error?

Accepted Answer

A)  Verify that names are spelled the same as they are in the actual form. 
B)  Verify that names are spelled the same as controls in the database. 
C)  Verify that the function name is spelled correctly. 
D)  all of the above 
A)  Verify that names are spelled the same as they are in the actual form. 
B)  Verify that names are spelled the same as controls in the database. 
C)  Verify that the function name is spelled correctly. 
D)  all of the above

Question 4

What are some common improvements you can make to the look of a form? What should you keep in mind as you change the look of a form?

Accepted Answer

After creating the basic form,you typica

Question 5

Which of the following form sections displays totals or other information at the bottom of the form,and often contains other controls such as buttons?

Accepted Answer

A)  Detail 
B)  Form Header 
C)  Page Header 
D)  Form Footer 
A)  Detail 
B)  Form Header 
C)  Page Header 
D)  Form Footer

Question 6

When this property is set to YES,users are required to do something with the form before they can do anything else,like click the Ribbon.

Accepted Answer

A)  Pop Up property 
B)  Modal property 
C)  Record Selectors property 
D)  Navigation Buttons property 
A)  Pop Up property 
B)  Modal property 
C)  Record Selectors property 
D)  Navigation Buttons property

Question 7

Which of the following determines whether the cursor stops at a control when the user pressed Tab or Enter?

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 8

In a one-to-many form,the main form displays data from the "one" side of the relationship.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following statements is true about changing the size of form sections?

Accepted Answer

A)  As you add controls or modify the size of controls in a section,you may need to adjust the height or width of a section. 
B)  You should pay attention to the size of the Detail section since that section shows the data about records in the database. 
C)  The control layout influences the size required for the Detail section. 
D)  all of the above 
A)  As you add controls or modify the size of controls in a section,you may need to adjust the height or width of a section. 
B)  You should pay attention to the size of the Detail section since that section shows the data about records in the database. 
C)  The control layout influences the size required for the Detail section. 
D)  all of the above

Question 10

Which of the following form sections appears at the top of every page when printed?

Accepted Answer

A)  Detail 
B)  Form Header 
C)  Page Header 
D)  Page Footer 
A)  Detail 
B)  Form Header 
C)  Page Header 
D)  Page Footer

Question 11

When linking a subform to a main form,which of the following statements is true?

Accepted Answer

A)  The linking fields are typically the primary key in the "one" table and the foreign key in the "many" table. 
B)  The linking fields are typically the foreign key in the "one" table and the primary key in the "many" table. 
C)  The linking fields are typically the primary key in the "one" table and the primary key in the "many" table. 
D)  The linking fields are typically the foreign key in the "one" table and the foreign key in the "many" table. 
A)  The linking fields are typically the primary key in the "one" table and the foreign key in the "many" table. 
B)  The linking fields are typically the foreign key in the "one" table and the primary key in the "many" table. 
C)  The linking fields are typically the primary key in the "one" table and the primary key in the "many" table. 
D)  The linking fields are typically the foreign key in the "one" table and the foreign key in the "many" table.

Question 12

You can save images as a .bmp file,which results in a smaller file size,instead of using a larger ·jpg file.

Accepted Answer

A) True 
 B)False

Question 13

In which of the following views can you change the captions in the labels on the subform?

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 14

If you make changes to the properties of a form,be sure to save the form after you make the changes.

Accepted Answer

A) True 
 B)False

Question 15

The #Error error means that you have used a name for a field,control,form,or function that is not valid.

Accepted Answer

A) True 
 B)False

Question 16

When this property is set to YES,the form opens as a pop up box instead of a full size form.

Accepted Answer

A)  Pop Up property 
B)  Modal property 
C)  Record Selectors property 
D)  Navigation Buttons property 
A)  Pop Up property 
B)  Modal property 
C)  Record Selectors property 
D)  Navigation Buttons property

Question 17

To aggregate over a group of records on the subform,you must place the aggregate function calculation in the Detail section of the subform.

Accepted Answer

A) True 
 B)False

Question 18

When aggregating over a group of records on the subform,where must you place the aggregate function?

Accepted Answer

A)  Form Header section 
B)  Form Footer section 
C)  Page Header section 
D)  either A or B 
A)  Form Header section 
B)  Form Footer section 
C)  Page Header section 
D)  either A or B

Question 19

Which of the following is a special type of form that contains tabs?

Accepted Answer

A)  tab control 
B)  page 
C)  navigation form 
D)  parameter 
A)  tab control 
B)  page 
C)  navigation form 
D)  parameter

Navigation buttons can be removed from any form.

Which of the following statements is true about working with main forms and subforms?

Which of the following should you do to correct either the #Name? error or the #Error error?

What are some common improvements you can make to the look of a form? What should you keep in mind as you change the look of a form?

Which of the following form sections displays totals or other information at the bottom of the form,and often contains other controls such as buttons?

When this property is set to YES,users are required to do something with the form before they can do anything else,like click the Ribbon.

Which of the following determines whether the cursor stops at a control when the user pressed Tab or Enter?

In a one-to-many form,the main form displays data from the "one" side of the relationship.

Which of the following statements is true about changing the size of form sections?

Which of the following form sections appears at the top of every page when printed?

When linking a subform to a main form,which of the following statements is true?

You can save images as a .bmp file,which results in a smaller file size,instead of using a larger ·jpg file.

In which of the following views can you change the captions in the labels on the subform?

If you make changes to the properties of a form,be sure to save the form after you make the changes.

The #Error error means that you have used a name for a field,control,form,or function that is not valid.

When this property is set to YES,the form opens as a pop up box instead of a full size form.

To aggregate over a group of records on the subform,you must place the aggregate function calculation in the Detail section of the subform.

When aggregating over a group of records on the subform,where must you place the aggregate function?

Which of the following is a special type of form that contains tabs?

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

Navigation buttons can be removed from any form.

Which of the following statements is true about working with main forms and subforms?

Which of the following should you do to correct either the #Name? error or the #Error error?

What are some common improvements you can make to the look of a form? What should you keep in mind as you change the look of a form?

Which of the following form sections displays totals or other information at the bottom of the form,and often contains other controls such as buttons?

When this property is set to YES,users are required to do something with the form before they can do anything else,like click the Ribbon.

Which of the following determines whether the cursor stops at a control when the user pressed Tab or Enter?

In a one-to-many form,the main form displays data from the "one" side of the relationship.

Which of the following statements is true about changing the size of form sections?

Which of the following form sections appears at the top of every page when printed?

When linking a subform to a main form,which of the following statements is true?

You can save images as a .bmp file,which results in a smaller file size,instead of using a larger ·jpg file.

In which of the following views can you change the captions in the labels on the subform?

If you make changes to the properties of a form,be sure to save the form after you make the changes.

The #Error error means that you have used a name for a field,control,form,or function that is not valid.

When this property is set to YES,the form opens as a pop up box instead of a full size form.

To aggregate over a group of records on the subform,you must place the aggregate function calculation in the Detail section of the subform.

When aggregating over a group of records on the subform,where must you place the aggregate function?

Which of the following is a special type of form that contains tabs?

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