Deck 8: Advanced Forms and Reports

Question 1

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

Answer 1

C

Question 2

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.

Answer 2

D

Question 3

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

Answer 3

A

Question 4

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 5

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 6

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 7

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 8

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.

Question 9

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 10

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 11

Subforms are often laid out in what type of fashion?

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

Question 12

How does a Combo Box control appear to a user?

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

Question 13

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 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

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 16

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 17

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 18

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 19

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

Question 20

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 21

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

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

Question 22

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 23

What word would not describe an unbound control?

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

Question 24

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 25

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 26

Where do you typically put a page break?

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

Question 27

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 28

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 29

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 30

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 31

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 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

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 34

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 35

A section ________ marks the top boundary of a section.

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

Question 36

Which of the following marks the top of a section?

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

Question 37

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 38

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 39

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 40

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

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

Question 41

Subforms always display all the fields from the underlying table.

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

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 47

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

Question 48

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

Question 49

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

Question 50

The tab order can be set manually if necessary.

Question 51

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

Question 52

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

Question 53

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

Question 54

Group headers and footers cannot be added to a form.

Question 55

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

Question 56

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

Question 57

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

Question 58

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 59

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

Question 60

A tab stop should always be set for AutoNumber fields.

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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 68

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

Question 69

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 70

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

Question 71

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

Question 72

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 73

A graphic line can be considered a form control.

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

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 80

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