Deck 10: Workshop 10: Advanced Form Settings and Form Types

Question 1

Which of the following is NOT true regarding the Locked property?

A)The Enabled property is not as strong as a lock.
B)A value of No means that data can be entered.
C)The Locked property determines whether data can be entered into the field on the form.
D)A value of Yes means that the field is locked and data cannot be entered.

Answer 1

A

Question 2

Which of the following is NOT true in regard to the Layout view of a form?

A)Layout view shows the form and the data.
B)Some of the form design such as field lengths and fonts can be changed in this view.
C)This is the view you use to change data in the form.
D)This view gives you an easy way to resize fields and check form appearance while you are creating the form.

Answer 2

C

Question 3

The ________ is a pop-up calendar that allows a user to enter a date by clicking a date in the calendar.

A)Calendar Form
B)Pop-up Window
C)Date Pop-up
D)Date Picker

Answer 3

D

Question 4

Which of the following is NOT true regarding dates on forms?

A)The Access function NOW automatically puts the current date based on your computer's system date in the field.
B)The function DateAdd allows you to add an interval to a date.
C)You can use Date functions and calculations as the default value in a field.
D)Using the DateAdd function is always returns a valid date.

Question 5

The ________ tab is where properties that change the display of a field or form part are listed.

A)Macro
B)Event
C)Data
D)Format

Question 6

The ________ tab contains all other properties that are not on one of the other tabs,such as name or datasheet caption.

A)Event
B)Data
C)Format
D)Other

Question 7

Which of the following is NOT true in regard to the Design view of a form?

A)Design view shows the form design but not the data.
B)Any aspect of the form design can be changed.
C)This view is used for creation of the form.
D)It is much easier to size and move controls in Design view.

Question 8

When modifying a box control on a form,which of the following cannot be resized or moved?

A)Width
B)Length
C)Top
D)Left

Question 9

If the ________ property is No,the data cannot be entered or copied.

A)locked
B)editing
C)tab
D)enabled

Question 10

________ forms can be used for operating your database by allowing you to specify parameters,create buttons to print reports,and other operations.

A)Calculated
B)Bound
C)Unbound
D)Linked

Question 11

Which of the following form sections is NOT included on the form when the form is initially created?

A)Detail section
B)Header
C)Footer
D)Design view allows you to add additional sections

Question 12

Which of the following is NOT true regarding bound forms?

A)The field lengths are defined as you progress through the wizard.
B)When you create a form from a table using the wizard,the form is bound to the table you used to run the wizard.
C)The field labels are the captions defined for the fields in the table design.
D)The formatting for the fields is based upon the field definitions in the table design.

Question 13

Which of the following is NOT true in regard to the Form view of a form?

A)This view gives you an easy way to resize fields and check form appearance while you are creating the form.
B)This is the view you use to enter or change data.
C)This is the view that employees would use when they are performing their jobs.
D)You cannot change the form design in this view.

Question 14

You can set procedures to determine what happens when a user performs an action such as clicking on a field on the ________ tab.

A)Other
B)Event
C)Data
D)Format

Question 15

The Default Value,an option on the ________ tab in the Property Sheet pane,allows you to define a value that will automatically appear in a new blank record.

A)Other
B)Event
C)Data
D)Format

Question 16

A(n)________ form is directly connected to a data source such as a table or query and can be used to enter,edit,or display data from that data source.

A)calculated
B)bound
C)unbound
D)linked

Question 17

A ________ must be created in Design view,but it can later be modified in Layout view.

A)detail section
B)header
C)subform
D)footer

Question 18

The ________ tab contains the properties including the field source and the properties that affect the values that can be entered into a field.

A)All
B)Event
C)Data
D)Format

Question 19

Which of the following is NOT true about the Property Sheet?

A)To display,click Property Sheet on the Design tab of the Ribbon.
B)To display,click Property Sheet on the Format tab of the Ribbon.
C)To display,right-click the value,and then select Properties from the shortcut menu.
D)The Property Sheet is available in Layout view and Design view.

Question 20

Every field on a form has certain characteristics about the field stored in the ________.

A)Property tab
B)property sheet
C)All sheet
D)Formatting tab

Question 21

Bound forms can be used to specify parameters,create buttons to print reports,provide navigation menus,and other similar operations.

Question 22

Which of the following is true regarding calculated controls?

A)Expressions for a calculated control can only be created in the Expression Builder.
B)A calculated control is a control whose source of data is an expression rather than a field.
C)Not all expressions are available for use on a form.
D)Access limits the amount of calculated controls that can be placed on a form.

Question 23

Which of the following is NOT true about a multiple-item form?

A)A multiple-item form can show multiple records at a time in a continuous form.
B)While the multiple-item form looks very similar to a datasheet,it can be customized as a form.
C)Graphical elements,buttons,and other controls cannot be added to a multiple-item form.
D)The data is arranged in rows and columns.

Question 24

When a control is selected,Access outlines the control in ________.

A)blue
B)green
C)orange
D)yellow

Question 25

Layout view shows the form and the data.Some of the form design such as field lengths and fonts can be changed in this view.

Question 26

Which of the following is NOT true in regard to tabs on a form?

A)The tab order is based on the initial location of the control on the form.
B)When you add a new field to the form,unless it is placed after all the other controls,you will have to adjust the tab order.
C)Moving a control to a new spot on the form does not change the tab order of the control.
D)The tab order is changed in the Tab Order dialog box that is accessed from Design view.

Question 27

Which of the following is NOT true in regard to moving controls on a form?

A)If you use your pointer to move the control now,without clicking on the move handle,you will move both controls at the same time.
B)If you click the move handle,you will move just one control.
C)You can use your mouse to move the control.
D)You can use your arrow keys on the keyboard to move the control a large distance.

Question 28

Which of the following is NOT a Record Navigation form command button?

A)Find Next
B)Find Record
C)Save Record
D)Go to Previous Record

Question 29

Property sheets have five tabs: Format,Data,Event,Macro,and Other.

Question 30

A(n)________ can help find a record based on a value you select.

A)combo box
B)unbound control
C)Date picker
D)subform

Question 31

Every field on a form has certain characteristics or properties about the field stored in the property sheet.

Question 32

Design view shows the data in the form.This is the view you use to enter or change data.

Question 33

When you create a form from a table using the wizard,the form is bound to the table you used to run the wizard.

Question 34

The large grey handle in the top-left corner is called the ________.

A)sizing handle
B)resizing handle
C)delete handle
D)move handle

Question 35

Which of the following is NOT a Form Operations form command button?

A)Open Form
B)Print Preview
C)Print a Form
D)Apply Form Filter

Question 36

When you add an existing field to a form,Access adds two controls.Which of the following is NOT true regarding these two controls?

A)The large grey handle in the top-left corner is called the sizing handle.The smaller orange handles are move handles.Sizing handles are used to resize the control.
B)One is the bound control (a text box)tied to a database field.The second is an unbound control that labels the text box.
C)The two controls are attached to each other.They can be moved as a pair or separately.
D)When a control is selected,Access outlines the control in orange.

Question 37

An unbound form is a form that it is directly connected to a data source such as a table or query and can be used to enter,edit,or display data from that data source.

Question 38

A ________ is created when fields from two or more related tables are used to create a form.

A)footer
B)subform
C)header
D)detail section

Question 39

Which of the following is NOT a Record Operations form command button?

A)Undo Record
B)Add New Record
C)Print Record
D)Find Record

Question 40

Which of the following is NOT true about adding and stacking fields?

A)When a control is selected,Access outlines the control in yellow.
B)When you add an existing field,Access adds two controls.
C)If you use your pointer to move the control,without clicking on the move handle,you will move both controls at the same time.
D)If you click the move handle,you will move just one control.

Question 41

For an unbound control,like a field label,the Data tab has only a Default Value property.

Question 42

A control is an object on a form or report that displays data,performs actions,and lets you view and work with information.

Question 43

The Format tab of the property sheet is where properties that change the display of a field or form part are listed.

Question 44

When creating calculations,you must use the field caption so Access knows which field to include in the calculation.

Question 45

Record Navigation buttons provide much of the navigation tools available on the Navigation bar.

Question 46

When you add an existing field,Access adds two controls.One is the bound control (a text box)tied to a database field.The second is an unbound control that labels the text box.The two controls are attached to each other.

Question 47

A calculated control is a control whose source of data is an expression rather than a field.

Question 48

The Date Picker is a pop-up calendar that allows users to enter dates by clicking a date in the calendar.

Question 49

Navigation buttons allow the user to add,delete,and undo a record.

Question 50

The Data tab of the property sheet contains the properties including the field source and the procedures that happen when a user performs an action.

Question 51

Forms are used to enter data and to make it easier for users to use the database.Anything you can do to make the form simpler will make it less likely that the user makes a mistake.

Question 52

Unlike the Event tab,there are many properties for an unbound control on the Data tab.That is because labels are displayed on the form,and so the properties related to the field display are relevant.

Question 53

The Miscellaneous tab of the property sheet contains all other properties that are not on one of the other tabs,such as name or datasheet caption.

Question 54

The Default Value,an option on the Data tab in the Property Sheet pane,allows you to define a value that will automatically appear in a new blank record.

Question 55

When a control is selected,Access outlines the control in yellow.

Question 56

The smaller orange handles of a control are sizing handles.Sizing handles are used to resize the control.

Question 57

Footers are not automatically created for you like headers.If you want to insert a footer on your form,you need to do so in Layout view.

Question 58

The function Current Date allows you to add an interval to a date.

Question 59

Form Operations buttons open,close,and print forms.

Question 60

The large grey handle in the top-right corner of a control is called the move handle.It is used to move the controls in the form.

Question 61

The ________ is used for creation of the form.

Question 62

________ is the view that the golf course employees would use when they are performing their jobs.

Question 63

As long as the tables in the database are related in a one-to-one relationship,you can add fields from other tables in the tab control.

Question 64

Field sizes in a form are based upon ________.

Question 65

The ________ tab on the Property Sheet contains any properties not included elsewhere.

Question 66

Every field on a form has certain characteristics about the field stored in the ________.

Question 67

The ________ tab on the Property Sheet contains all properties from the other tabs.

Question 68

The formatting for the fields is based upon the ________ in the table design.

Question 69

A(n)________ is an object used to enter new records into a table,edit or delete existing records in a table,or display existing records in a table.

Question 70

________ gives you an easy way to resize fields and check form appearance while you are creating the form.

Question 71

A(n)________ is not linked directly to a data source and can be used for operating your database by allowing you to specify parameters,create buttons to print reports,and other operations.

Question 72

You can add existing fields and other controls to the tabbed pages.

Question 73

The field labels are the ________ defined for the fields in the table design.

Question 74

The ________ tab on the Property Sheet contains properties related to the formatting and design of a field or form.

Question 75

When inserting a tab control,the control will be inserted with three tabbed pages.

Question 76

The ________ tab on the Property Sheet contains properties related to the source of a field and how the field data is entered.

Question 77

A split form is a single form that shows both Form view and Layout view at the same time.

Question 78

A(n)________ is directly connected to a data source such as a table or query and can be used to enter,edit,or display data from that data source.

Question 79

The ________ tab on the Property Sheet contains properties related to Macro procedures that should be used when a user performs an action.

Question 80

A multiple-items form shows multiple records in Datasheet view.