Deck 4: Creating and Using Forms and Reports

Question 1

Setting the Enabled property to No does not affect the way the label displays.

Answer 1

False

Question 2

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.

Answer 2

True

Question 3

Design view provides you with the most flexibility in creating forms.

Answer 3

True

Question 4

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

Question 5

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.

Question 6

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

Question 7

The Image button inserts an embedded image.

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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.

Question 13

By default,the tab order is initially set based on the order that fields have been added to the form.

Question 14

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

Question 15

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

Question 16

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

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.

Question 18

Navigation buttons can be removed from any form.

Question 19

If you switch to Form view after adding the aggregate function onto the subform,you will not see any differences in the form.

Question 20

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

Question 21

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.

Question 22

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

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

Question 23

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

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

Question 24

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

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 25

Which of the following form sections appears once at the top of the screen in Form view and at the top of the first page when the form is printed?

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

Question 26

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

Question 27

When you click a tab in a navigation form,the most current data is loaded.

Question 28

The Insert Image button inserts an embedded image.

Question 29

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

Question 30

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

Question 31

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?

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

Question 32

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

Question 33

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

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

Question 34

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

Question 35

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

Question 36

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

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

Question 37

Which of the following determines the order that Access navigates from one control to another?

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

Question 38

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

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

Question 39

You can attach a table to a navigation form.

Question 40

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

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

Question 41

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

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

Question 42

Which of the following Cycle property settings causes Access to move to the first field of the current record when the user tabs out of the last field?

A) All Records
B) Current Record
C) Current Page
D) none of the above

Question 43

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

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

Question 44

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

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

Question 45

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

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 46

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

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

Question 47

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

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

Question 48

Which of the following properties should you do to prevent a user from accessing a form field?

A) Locked property
B) Enabled property
C) Cycle property
D) both A and B

Question 49

Which of the following is a common modification that users need to make to forms?

A) adjust the size and spacing of the text box and label controls
B) modify the font characteristics of the text boxes
C) change the border property
D) all of the above

Question 50

Which of the following statements is true of the Locked property?

A) If the Locked property is set to Yes,a user can tab into that field and also change the field.
B) If the Locked property is set to Yes,a user can still tab into that field,but not change the field.
C) If the Locked property is set to Yes,a user can't tab into that field.
D) none of the above

Question 51

Which of the following statements about subforms is true?

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 52

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

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

Question 53

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

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 54

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

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

Question 55

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

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 56

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

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

Question 57

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

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

Question 58

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

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

Question 59

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

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

Question 60

In which of the following do users most commonly insert calculated controls?

A) text box
B) main form
C) subform
D) form header

Question 61

Which of the following does the Image button insert?

A) embedded image
B) shared image
C) conditional formatting
D) tab control

Question 62

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

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

Question 63

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

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

Question 64

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

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

Question 65

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

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 66

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

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 67

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

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

Question 68

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

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

Question 69

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

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

Question 70

Which of the following statements is true about using the Insert Image button?

A) Using images that are added to the Image Gallery conserves file space in the database.
B) Using images that are added to the Image Gallery makes it easier to update shared images.
C) Making a single change updates the image in all forms or reports where the image is used.
D) all of the above

Question 71

Which of the following rules should you consider when adding a calculated control to a form?

A) Enter the expression directly into the Control Source property.
B) If you need more space to enter the expression,you can open the Expression Builder or Zoom window.
C) Assign a name to the control in the Name property.
D) all of the above

Question 72

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

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

Question 73

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

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 74

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

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

Question 75

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

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

Question 76

Which of the following is not a design consideration when changing colors or fonts in a 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 77

Which of the following should you do if the formula doesn't provide the correct 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 78

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

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

Question 79

Which of the following statements is true about images inserted using the Insert Image button?

A) The image file is not stored as part of each form or report to which it is added.
B) By using the Insert Image button instead of the Image button,the overall size of your database is reduced.
C) The image file is stored once in the Image Gallery of the database.
D) all of the above

Question 80

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

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