Deck 8: Advanced Forms and Reports

Question 1

When setting up a Combo Box, what property is used to pick the field in the table which will be used to generate the menu?

A) Row Source
B) Column Source
C) Field Source
D) Record Source

Answer 1

A

Question 2

Which of the following is not true about what restrictions can be set for a form?

A) A user cannot delete a record.
B) A user cannot view a record.
C) A user cannot add a record.
D) A user cannot change a record.

Answer 2

B

Question 3

Subforms are often laid out in what type of fashion?

A) Grid
B) Tabular
C) Form
D) Nested

Answer 3

B

Question 4

Which of the following is not true about making a table the source data for a Combo Box?

A) It is quicker for Access to index the data.
B) The data is then in an easy-to-edit location.
C) The user can be forced to choose from only those records in the table.
D) New records can be added or existing records deleted very easily.

Question 5

Which of the following are not customizations you can make to a form?

A) Change the tab order
B) Convert a form to a report
C) Convert a text box to a menu
D) Make a form read-only

Question 6

What type of control is created if you create a form based on a table with a lookup field?

A) Check Box
B) Option button
C) Combo Box
D) Lookup Box

Question 7

To make sure that a user can only pick from an item on the list in a Combo Box, what property must be enabled?

A) Limit to List
B) Restrict to List
C) Limit to Menu
D) Restrict to Menu

Question 8

How does Access let you know that a form is set as read-only?

A) A notice will appear on the Status Bar while the form is open.
B) A pop-up message will appear when the form is opened.
C) The form fields will be grayed out.
D) No indication is given that a form is read-only.

Question 9

What is one way the user can tell that new records cannot be created in a form?

A) The New command is grayed out.
B) The New command is removed.
C) The New command has a line through it.
D) There is no way to tell that new records cannot be created.

Question 10

What is the name of the button/command in the Tab Order dialog box that allows Access to reorder your tabs as it sees fit?

A) Tab Order
B) Custom Order
C) Auto Order
D) Auto Tabs

Question 11

How does a Combo Box control appear to a user?

A) Menu of options
B) Option button
C) Check Box
D) Legacy control

Question 12

Creating a Combo Box is perfect when data ________.

A) repeats often
B) is always unique
C) entry requires more than one answer
D) will not be deleted

Question 13

Which of the following is a recommended way of informing users that a form is read-only?

A) Include a note in the form title.
B) Have a message box appear any time the form is opened.
C) There is no need to inform the user.
D) There is never a need to make a form read-only.

Question 14

Which of the following is not true about Combo Boxes?

A) They are not good for repetitive data.
B) They should not be used if the menu would become too long.
C) They can reference data in other tables.
D) They can make data entry more reliable.

Question 15

What key is often used in a form to advance from one field to another?

A) Right Arrow key
B) Shift Tab
C) Space bar
D) Tab

Question 16

Which of the following is not a reason to restrict who can edit data in a form?

A) Data can become unreliable.
B) Data can become hard to maintain.
C) The wrong people might be able to delete the records.
D) The file will get too large.

Question 17

A form that enables users to view but not change data is what type of form?

A) Restrict-only
B) DataView-only
C) Read-only
D) DataView

Question 18

What is one way the user can tell that records cannot be deleted in a form?

A) The Delete command is not visible.
B) The Delete command has a line through it.
C) The Delete command is grayed out.
D) There is no way to tell if records cannot be deleted.

Question 19

When might you not want to skip a tab stop?

A) Calculated field
B) AutoNumber field
C) Combo Box field
D) Any time the field requires no data entry

Question 20

When editing a subform, it is almost always easier to do it in what view because you can see the data as it appears in the subform?

A) Design
B) Layout
C) Form
D) Report

Question 21

Which of the following statements is not true about sections?

A) Forms and reports display the Detail section by default.
B) The Detail section cannot be turned off.
C) Reports display the page header/footer by default.
D) Forms hide the footer section by default.

Question 22

Where do you typically put a page break?

A) Page footer
B) Group footer
C) Group header
D) Section footer

Question 23

What is the name of the section that displays the data in a form or report?

A) Footer
B) Header
C) Detail
D) Content

Question 24

In what section is the field which calculates the total number of pages in the document, normally put?

A) Report header
B) Report footer
C) Page header
D) Page footer

Question 25

What word would not describe an unbound control?

A) Static
B) Unchanging
C) Dynamic
D) Decorative

Question 26

Where does a form header appear?

A) At the top of each page
B) At the left of each page
C) Once, at the left of the form
D) Once, at the top of the form

Question 27

Which of the following views is not used with forms or reports?

A) Form
B) Design
C) Layout
D) SQL

Question 28

Adding which control will insure that your reports are paginated correctly?

A) Line Break
B) Page Break
C) Pagination
D) Section Break

Question 29

Which of the following statements is true about changing the width of sections?

A) All sections must have the same width.
B) Each section can have its own width.
C) Each section can have its own width within the limits of the width of the form/report.
D) You cannot change the width of sections.

Question 30

Which of the following statements is not true about group headers and footers?

A) They cannot be added to forms.
B) You need to use caution when adding them to forms.
C) They appear once for each unique value in the group.
D) They are named after the field on which the group is based.

Question 31

What happens to the controls in a section if you turn off the section?

A) All controls in that section are minimized.
B) All controls in that section are moved to the next higher section.
C) All controls in that section are deleted.
D) All controls in that section are hidden.

Question 32

Which view gives the database designer more control over the look of the form or report?

A) Design
B) Layout
C) Form
D) Report

Question 33

A section ________ marks the top boundary of a section.

A) bar
B) line
C) area
D) row

Question 34

Which of the following marks the top of a section?

A) Section divider
B) Section line
C) Section bar
D) Section break

Question 35

Which of the following would you typically not find in a calculated control?

A) Aggregate function
B) Simple math
C) Function using the Expression Builder
D) Image

Question 36

What does the Label control display as a default when used in a form or report?

A) Caption set for a field if there is one
B) Label name
C) Default value for the field if there is one
D) "Label"

Question 37

Which of the following is not a control that can be added to a form or report?

A) Select
B) Page Break
C) Label
D) Image

Question 38

A common control which displays the values in a field is called what type of control?

A) Label
B) Field
C) Value
D) Text Box

Question 39

Which of the following would not be an example of an unbound control?

A) Title of the report
B) Lastname field
C) Graphic line
D) Rectangle

Question 40

If you had a five-page report, which of the following statements is true?

A) The form header and/or footer would display twice; one on the first page and one on the last page.
B) The page header and/or footer would display twice; one on the first page and one on the last page.
C) The form header and/or footer would display five times.
D) The page header and/or footer would display five times.

Question 41

If you create a form based on a table with a lookup field, the lookup field becomes a Combo Box control on the new form.

Question 42

Access makes it obvious to a data entry user if a form is read-only.

Question 43

When the Allow Edits property of a form is set to No, no records can be deleted.

Question 44

As long as you have created the table relationships correctly, after you convert a text box to a Combo Box Access will make the appropriate connections in the Combo Box.

Question 45

It is possible to set up restrictions which allow records to be added, but not deleted using a form.

Question 46

When the Allow Edit property of a form is set to No, no new records can be added.

Question 47

It is possible to set up restrictions which allow records to be deleted, but not added using a form.

Question 48

If two tables are related and you use the Form Wizard, a subform will automatically be created in the main form.

Question 49

Combo Boxes must be created at the same time the source table is created.

Question 50

Setting the tab order helps prevent errors and simplifies data entry.

Question 51

Forms can be customized so that users can only view the data.

Question 52

The tab order can be set manually if necessary.

Question 53

Group headers and footers cannot be added to a form.

Question 54

Sometimes tables are created for no other purpose than to hold the values that will be used in a Combo Box.

Question 55

Subforms always display all the fields from the underlying table.

Question 56

A form that enables users to view but not change data is a restrict-only form.

Question 57

A tab stop should always be set for AutoNumber fields.

Question 58

A Combo Box allows a user to pick a combination of correct options.

Question 59

A form footer displays at the bottom of every page in a form.

Question 60

Because tables are often related in Access, one result is that forms can get more complex.

Question 61

________ can be created from tables, queries, or existing forms.

Question 62

The controls toolbar will tell you if a control is a bound or unbound control.

Question 63

A form that enables users to view but not change data is a(n) ________ form.

Question 64

When you are creating a subform, you can use existing tables and queries or you can use an existing ________.

Question 65

A form contained inside of another form is called a(n) ________.

Question 66

Subforms are generally laid out in a(n) ________ fashion.

Question 67

If you create a form based on a table with a lookup field, the lookup field becomes a(n) ________ Box control on the new form.

Question 68

The reason the value displayed in fields on a form change when the data in the table changes is that the fields on a form are bound controls.

Question 69

An object on a form or report is called a(n) ________.

Question 70

Often information such as report totals (averages, sums, etc.) are displayed in a report ________.

Question 71

Page headers and footers are turned off by default in forms.

Question 72

Text box controls cannot display numeric data, currency, or dates.

Question 73

A graphic line can be considered a form control.

Question 74

The ________ key is often used in a form to advance from one field to another.

Question 75

To make sure that a user can only pick from an item on the list in a Combo Box, the ________ to List property must be enabled.

Question 76

Subforms can be created using ________, queries, or forms.

Question 77

If a user attempts to enter a value in a Combo Box that is not present in the table, and the Limit to List property is enabled, Access will generate a(n) ________ message.

Question 78

The ________ order is the sequential advancing in a form from one field or control to the next.

Question 79

Unbound controls are connected to specific fields in a table or query.

Question 80

To display information from more than one table, forms often have ________.