Question 1

When a calculated expression is longer than the size of the control,you can use the Expression Builder or Zoom window to see the entire expression.

Accepted Answer

A) True 
 B)False

Question 2

What is an aggregate function? How do you aggregate over a group of records?

Accepted Answer

The answer of What is an aggregate function? How do...

Question 3

Which of the following must you use at the beginning of each calculated expression?

Accepted Answer

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

Question 4

Because the subform uses a datasheet layout,it is possible to customize the font characteristics of individual fields on the subform.

Accepted Answer

A) True 
 B)False

Question 5

The Image button inserts an embedded image.

Accepted Answer

A) True 
 B)False

Question 6

In which of the following can you see the expression inside of a control?

Accepted Answer

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

Question 7

Why is it important to know about tab controls and navigation forms?

Accepted Answer

The answer of Why is it important to know about...

Question 8

After the form has been created and the query has been updated,you need to write the macro code that is attached to the form buttons.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following creates a layered area on a form?

Accepted Answer

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

Question 10

Most forms used to capture parameters have an OK button and a Cancel button.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following should you do if the formula doesn't provide the correct answer?

Accepted Answer

A)  Review the structure of the formula. 
B)  Make sure that you have used the correct fields in the formula. 
C)  Make sure that you have used the correct aggregate function. 
D)  all of the above

Question 12

When using a form,which key moves the insertion point from one control to another?

Accepted Answer

A)  Enter 
B)  Tab 
C)  Shift 
D)  both A and B

Question 13

Which of the following form sections displays the fields from each record and can also contain buttons and other controls?

Accepted Answer

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

Question 14

Which of the following choices in the Scroll Bars property displays a vertical scroll bar as needed on a form?

Accepted Answer

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

Question 15

If you are unable to reduce the height of a section or the width of the form,it is because a control somewhere in the form requires the space.

Accepted Answer

A) True 
 B)False

Question 16

The order that Access navigates from one control to another is determined by the value in the Tab Stop property.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

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

Question 18

Which of the following must you use to see an entire expression when it is longer than the size of the control?

Accepted Answer

A)  Design view 
B)  Expression Builder 
C)  Zoom window 
D)  both B and C

Question 19

When using a form,what are tab properties? Why is it sometimes necessary to modify tab properties?

Accepted Answer

The answer of When using a form,what are tab properties?...

Question 20

The linking fields are typically the primary key in the "one" table and the foreign key in the "many" table.

Accepted Answer

A) True 
 B)False

Exam 4: Creating and Using Forms and Reports

When a calculated expression is longer than the size of the control,you can use the Expression Builder or Zoom window to see the entire expression.

What is an aggregate function? How do you aggregate over a group of records?

Which of the following must you use at the beginning of each calculated expression?

Because the subform uses a datasheet layout,it is possible to customize the font characteristics of individual fields on the subform.

The Image button inserts an embedded image.

In which of the following can you see the expression inside of a control?

Why is it important to know about tab controls and navigation forms?

After the form has been created and the query has been updated,you need to write the macro code that is attached to the form buttons.

Which of the following creates a layered area on a form?

Most forms used to capture parameters have an OK button and a Cancel button.

Which of the following should you do if the formula doesn't provide the correct answer?

When using a form,which key moves the insertion point from one control to another?

Which of the following form sections displays the fields from each record and can also contain buttons and other controls?

Which of the following choices in the Scroll Bars property displays a vertical scroll bar as needed on a form?

If you are unable to reduce the height of a section or the width of the form,it is because a control somewhere in the form requires the space.

The order that Access navigates from one control to another is determined by the value in the Tab Stop property.

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

Which of the following must you use to see an entire expression when it is longer than the size of the control?

When using a form,what are tab properties? Why is it sometimes necessary to modify tab properties?

The linking fields are typically the primary key in the "one" table and the foreign key in the "many" table.