Question 1

Focus determines whether the cursor stops at a control when the user presses Tab or Enter.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following must you use to enclose fields used in an expression?

Accepted Answer

A)  + 
B)  ( 
C)  = 
D)  [ 
A)  + 
B)  ( 
C)  = 
D)  [

Question 3

Which of the following choices in the Scroll Bars property displays both horizontal and vertical scroll bars as needed on a form?

Accepted Answer

A)  Both 
B)  Neither 
C)  Horizontal Only 
D)  Vertical Only 
A)  Both 
B)  Neither 
C)  Horizontal Only 
D)  Vertical Only

Question 4

Why might you want to create a form to capture parameter data?

Accepted Answer

If a query or report needs multiple para

Question 5

After you create a form,which of the following tasks can you perform in Design view?

Accepted Answer

A)  add fields 
B)  add labels 
C)  add other controls 
D)  all of the above 
A)  add fields 
B)  add labels 
C)  add other controls 
D)  all of the above

Question 6

Which of the following color properties changes the font color of text that displays in a control?

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 7

Which of the following statements about subforms is true?

Accepted Answer

A)  The subform uses a datasheet layout. 
B)  It is not possible to customize the font characteristics of individual fields on the subform. 
C)  All fields on the subform use the same font characteristics. 
D)  all of the above 
A)  The subform uses a datasheet layout. 
B)  It is not possible to customize the font characteristics of individual fields on the subform. 
C)  All fields on the subform use the same font characteristics. 
D)  all of the above

Question 8

Which of the following contains its own controls and is the name given to each layered area on a form?

Accepted Answer

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

Question 9

When this property is set to NO,the navigation buttons do not appear at the bottom of the 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 10

Which of the following do lines and rectangles help with on forms?

Accepted Answer

A)  separating controls 
B)  providing a logical grouping around multiple controls 
C)  differentiate areas in a form 
D)  all of the above 
A)  separating controls 
B)  providing a logical grouping around multiple controls 
C)  differentiate areas in a form 
D)  all of the above

Question 11

Which of the following refers to the ability of a control to receive input from the mouse or keyboard action?

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 12

Which of the following form sections displays information when a form is printed,and is only visible in Design or Print Preview view?

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 13

Which of the following choices in the Scroll Bars property prevents a scroll bar from ever appearing on a form?

Accepted Answer

A)  Both 
B)  Neither 
C)  Horizontal Only 
D)  Vertical Only 
A)  Both 
B)  Neither 
C)  Horizontal Only 
D)  Vertical Only

Question 14

An embedded macro is code that is attached to an event or a control of object.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following must be true about expressions that refer to controls on another form?

Accepted Answer

A)  Inside the first set of brackets,substitute the name of the subform. 
B)  Include the .Form! part of the expression exactly as written. 
C)  The expression must have the following format: =[Subform Name].Form![Control Name] 
D)  all of the above 
A)  Inside the first set of brackets,substitute the name of the subform. 
B)  Include the .Form! part of the expression exactly as written. 
C)  The expression must have the following format: =[Subform Name].Form![Control Name] 
D)  all of the above

Question 16

Which of the following is not a design consideration when changing colors or fonts in a form?

Accepted Answer

A)  Use many colors. 
B)  Avoid using too many fonts. 
C)  Select fonts that create a professional,polished look. 
D)  Verify that there is adequate contrast between the colors of the text and background on the form. 
A)  Use many colors. 
B)  Avoid using too many fonts. 
C)  Select fonts that create a professional,polished look. 
D)  Verify that there is adequate contrast between the colors of the text and background on the form.

Question 17

Provide an example of when you might want to create a one-to-many form.

Accepted Answer

Sometimes you need to create a form that

Question 18

Which of the following statements is true about a form's navigation buttons?

Accepted Answer

A)  Navigation buttons can be removed from a form. 
B)  Navigation buttons can't be removed from a form. 
C)  Navigation buttons can sometimes be removed from a form. 
D)  Navigation buttons are only included on a form is there are more than three records in a table. 
A)  Navigation buttons can be removed from a form. 
B)  Navigation buttons can't be removed from a form. 
C)  Navigation buttons can sometimes be removed from a form. 
D)  Navigation buttons are only included on a form is there are more than three records in a table.

Question 19

What rules should you follow when entering an expression into a control?

Accepted Answer

Follow these rules when you enter an exp

Question 20

Which of the following colors implies "stop" or "danger"?

Accepted Answer

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

Focus determines whether the cursor stops at a control when the user presses Tab or Enter.

Which of the following must you use to enclose fields used in an expression?

Which of the following choices in the Scroll Bars property displays both horizontal and vertical scroll bars as needed on a form?

Why might you want to create a form to capture parameter data?

After you create a form,which of the following tasks can you perform in Design view?

Which of the following color properties changes the font color of text that displays in a control?

Which of the following statements about subforms is true?

Which of the following contains its own controls and is the name given to each layered area on a form?

When this property is set to NO,the navigation buttons do not appear at the bottom of the form.

Which of the following do lines and rectangles help with on forms?

Which of the following refers to the ability of a control to receive input from the mouse or keyboard action?

Which of the following form sections displays information when a form is printed,and is only visible in Design or Print Preview view?

Which of the following choices in the Scroll Bars property prevents a scroll bar from ever appearing on a form?

An embedded macro is code that is attached to an event or a control of object.

Which of the following must be true about expressions that refer to controls on another form?

Which of the following is not a design consideration when changing colors or fonts in a form?

Provide an example of when you might want to create a one-to-many form.

Which of the following statements is true about a form's navigation buttons?

What rules should you follow when entering an expression into a control?

Which of the following colors implies "stop" or "danger"?

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

Focus determines whether the cursor stops at a control when the user presses Tab or Enter.

Which of the following must you use to enclose fields used in an expression?

Which of the following choices in the Scroll Bars property displays both horizontal and vertical scroll bars as needed on a form?

Why might you want to create a form to capture parameter data?

After you create a form,which of the following tasks can you perform in Design view?

Which of the following color properties changes the font color of text that displays in a control?

Which of the following statements about subforms is true?

Which of the following contains its own controls and is the name given to each layered area on a form?

When this property is set to NO,the navigation buttons do not appear at the bottom of the form.

Which of the following do lines and rectangles help with on forms?

Which of the following refers to the ability of a control to receive input from the mouse or keyboard action?

Which of the following form sections displays information when a form is printed,and is only visible in Design or Print Preview view?

Which of the following choices in the Scroll Bars property prevents a scroll bar from ever appearing on a form?

An embedded macro is code that is attached to an event or a control of object.

Which of the following must be true about expressions that refer to controls on another form?

Which of the following is not a design consideration when changing colors or fonts in a form?

Provide an example of when you might want to create a one-to-many form.

Which of the following statements is true about a form's navigation buttons?

What rules should you follow when entering an expression into a control?

Which of the following colors implies "stop" or "danger"?

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