Deck 6: Using Form Tools and Creating Custom Formsmodule

Question 1

Tab order allows a user to navigate the label boxes in a form by pressing the Tab key on the keyboard._________________________

Answer 1

False
field value,value

Question 2

A selected column of controls may be aligned to the left or right edges of the controls using the Arrange tab on the ribbon.

Answer 2

True

Question 3

When a control is active and waiting for user action,the control has focus._________________________

Answer 3

True

Question 4

To quickly open the Property Sheet for a control in Layout view,press the F4 key on the keyboard._________________________

Question 5

A combo box control may only be modified in form Design view.

Question 6

A form may only be created from scratch in Form view.

Question 7

A control that allows users to type an entry is a(n)text box._________________________

Question 8

Access assigns names to control boxes if the Name property for the control is not set when the form is created._________________________

Question 9

Text box controls arranged vertically in Form Design view with a label control to the left of each text box control is the tabular layout.

Question 10

If a form does not need both a Form Header and a Form Footer section,the section which is not needed may be removed by setting the height of the section to zero._________________________

Question 11

Options on the Arrange tab apply only to the datasheet when the Split Form tool has been used to create the form._________________________

Question 12

When resizing controls in Design view,the user can see actual field values while resizing the controls._________________________

Question 13

Number signs indicate that a text box has been resized too small to display the contents properly.

Question 14

The record source for a subform must be a table.

Question 15

Tab order may only be changed in form Design view.

Question 16

When there is a finite number of choices for a form entry,a combo box control should be used.

Question 17

The Bound Column property specifies the default control used to display a field._________________________

Question 18

The caption that displays in a label cannot be changed in Design view when creating a form.

Question 19

The Record Source property specifies the table or query on which a form is based.

Question 20

To create a custom form,the user may modify an existing form in Form view or Design view._________________________

Question 21

A selected control will display how many sizing handles?

A)1
B)2
C)4
D)7

Question 22

Which property must be set to Yes in the Property Sheet to display a control or a section in the form?

A)Height
B)Special Effect
C)Auto Height
D)Visible

Question 23

Spacing around the text inside a control is determined using the ____ property.

A)Control Margins
B)Control Padding
C)Anchor
D)Text Format

Question 24

Only a field name or an expression may be used for the ____ property in a calculated control.

A)Source
B)Control Source
C)Visible
D)Calculate

Question 25

Which form tool displays data in both Form view and Datasheet view at the same time?

A)Multiple Items
B)Datasheet
C)Split Form
D)Standard

Question 26

To find records in a form using a Combo box,it is necessary to change the ____ form property of the form to the table or query that is the source for all the bound controls in the Detail section.

A)Record Source
B)Default View
C)Caption
D)Modal

Question 27

The number of occurrences of an expression is determined using the ____ function in a form or report.

A)Sum
B)Average
C)Count
D)Max

Question 28

The Access tool that allows the user (or designer)to create detailed documentation of all,or selected,objects in a database is the ____.

A)Documenter
B)Document Properties
C)Database Object Properties
D)Database Relationships

Question 29

To select and set properties for an entire section,click on the ____.

A)Property Sheet
B)section selector
C)section tab
D)Layout view

Question 30

The Layout view or the Design view may be used to create a ____ form.

A)control
B)tabular
C)custom
D)wizard

Question 31

A control that combines the features of a text box and a list box is a ____.

A)text box
B)lookup box
C)custom box
D)combo box

Question 32

A customizable form that displays multiple records from a source table or query in a datasheet format may be created using the ____ form tool.

A)Datasheet
B)Split Form
C)Pivot Table
D)Multiple Items

Question 33

A form created from related tables usually consists of a ____ table which is the "one" side of the one-to-many relationship with a subform.

A)secondary
B)main
C)subordinate
D)primary

Question 34

The default Form Footer section Height property is set to ____ when the Form Footer is added in Design view.

A)one inch
B)one-half inch
C)one-quarter inch
D)zero

Question 35

Text box controls arranged in a datasheet format with a label above each column indicates the ____ layout.

A)stacked
B)tabular
C)columnar
D)grid

Question 36

The label attached to a bound control displays which of the following?

A)the field value
B)the field name or Caption property
C)the field character length
D)the field data type property

Question 37

The ____ property specifies the data source for a control in a form or report or for a field in a table or query.

A)Row Source Type
B)Row Source
C)List Items Edit Form
D)Column Heads

Question 38

Titles,instructions,command buttons,and other controls added to the bottom of a form and that remain on the screen when the form is displayed in Form view or Layout view are added to the ____ section of the form.

A)Form Footer
B)Form Header
C)Details
D)Form Grid

Question 39

Which view or tool allows the form designer the most control and precision when designing a form?

A)Design view
B)Layout view
C)Form Wizard
D)Split Form Tool

Question 40

A value that is the result of an expression is displayed in which type of control in a form?

A)bound control
B)unbound control
C)label
D)calculated

Question 41

A tool used to form a group of related controls or to separate the group from other controls is the ____ tool.

A)Rectangle
B)Bound Object Frame
C)Unbound Object Frame
D)Line

Question 42

The ____ refers to the order in which the focus moves from one control to another control when a user presses the Tab key.

A)tab alignment
B)tab stop
C)tab order
D)tab focus

Question 43

Carlos has created several tables for his Organic Produce farm database including Customers,Vendors,and Products.Now he wants to create forms that will make it easier to enter data in the database.Determine the best methods for Carlos to use when creating forms for his specific needs.
After reviewing the simple form,Carlos decides that he needs a form which is customized to make data entry more accurate and less cumbersome.Because most of his products are already in the database,he would like to use a list to choose the product during data entry.However,there are times that a product might not be available in the database,and it needs to be added.What is the best type of control for Carlos to use in his custom form to meet this requirement?

A)Combo box
B)List box
C)Text box
D)Calculated box

Question 44

Which button on the Format tab is used to change the background color of a control,section,or object?

A)Background Image
B)Conditional Formatting
C)Background Color
D)Shape Fill

Question 45

Set the ____ property to No to prevent users from using the Tab key to navigate to a control.

A)Tab Stop
B)On Tab
C)Tab Index
D)Text Align

Question 46

Flat,Raised,Sunken,Etched,Shadowed,and Chiseled are options for the ____ control property.

A)Visible
B)Format
C)Border Style
D)Special Effect

Question 47

The ____ option in the Tab Order dialog box allows a tab order of left-to-right or top-to-bottom.

A)Auto Order
B)Move
C)Custom Order
D)Tab Stop

Question 48

Which key on the keyboard may be used to ensure that a horizontal or vertical line is straight when adding a line to a form or report?

A)Shift
B)Ctrl
C)Alt
D)Tab

Question 49

A ____ asks a series of questions and then uses your answers to create a control in a form or report.

A)Form Wizard
B)Control Wizard
C)Report Wizard
D)Control Gallery

Question 50

To increase an object's window size to view more of the vertical contents of the object,collapse the ____.

A)Object Tabs
B)Property Sheet
C)Ribbon
D)Navigation Pane

Question 51

Carlos has created several tables for his Organic Produce farm database including Customers,Vendors,and Products.Now he wants to create forms that will make it easier to enter data in the database.Determine the best methods for Carlos to use when creating forms for his specific needs.
The new custom form meets Carlos' requirements;however,some of the labels do not clearly describe the data that needs to be entered in the form.Which label property should Carlos change to make the label more descriptive and clear to the user?

A)Content property
B)Visible property
C)Special Effect property
D)Caption property

Question 52

A subform may be added to a main form by using the Subform/Subreport tool or by using the ____.

A)Subform control
B)Subform Wizard
C)Subform/Subreport dialog box
D)Subform property

Question 53

Carlos has created several tables for his Organic Produce farm database including Customers,Vendors,and Products.Now he wants to create forms that will make it easier to enter data in the database.Determine the best methods for Carlos to use when creating forms for his specific needs.
To add the control to the form that meets his requirements,Carlos will use the ____ from the Design tab in the Forms Layout Group on the Ribbon.

A)Property Sheet
B)Design Wizard
C)Controls gallery
D)Form Properties

Question 54

The Tab Order button,which quickly displays the Tab Order dialog box,is located on the ____ tab in Form Design view.

A)Format
B)Arrange
C)Layout
D)Design

Question 55

Janise's College Pet Sitting business is growing rapidly.  She has expanded to include more pet sitters and is creating forms for the sitters to enter information in the business database.She is creating only custom forms.Determine the best methods,features,and tools for Janise to use when creating her custom forms.
Janise is planning her first custom form carefully.She knows that she wants a title for her form and several fields included in the form controls.Which feature will Janise use to add the appropriate section for a title to her form?

A)Page Header/Footer
B)Form Wizard
C)Form Header/Footer
D)Form Title

Question 56

The expression =Sum([InvoiceAmt])might be found in which type of control added to a form?

A)field control
B)label control
C)calculated control
D)combo control

Question 57

Text that appears in a ScreenTip when the mouse pointer is positioned above a control in a form is determined by the ____ property.

A)Control Source
B)ControlTip Text
C)Text Format
D)Visible

Question 58

To avoid typing errors when creating a more advanced expression for a calculated control,it is a good idea to use this Access feature.

A)Property Sheet
B)Controls group on the ribbon
C)Form view
D)Expression Builder

Question 59

Which symbol is used to distinguish an expression from a fieldname in a calculated control?

A)#
B)!
C)=
D)+

Question 60

Carlos has created several tables for his Organic Produce farm database including Customers,Vendors,and Products.Now he wants to create forms that will make it easier to enter data in the database.Determine the best methods for Carlos to use when creating forms for his specific needs.
Carlos is creating a simple form using the Products table and would like to include all fields from the table.He would like for the form to display all of the fields using a datasheet layout.Which tool would be best for Carlos to use?

A)Split Form tool
B)Datasheet tool
C)Multiple Items tool
D)Controls Gallery

Question 61

Janise's College Pet Sitting business is growing rapidly.  She has expanded to include more pet sitters and is creating forms for the sitters to enter information in the business database.She is creating only custom forms.Determine the best methods,features,and tools for Janise to use when creating her custom forms.
All of the fields added to the form are from the Customer table.These controls are called ____ controls because they are connected to a field in the database.

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

Question 62

The subform used to create a form from related tables represents the records in the ____________________ side of the relationship.

Question 63

Janise's College Pet Sitting business is growing rapidly.  She has expanded to include more pet sitters and is creating forms for the sitters to enter information in the business database.She is creating only custom forms.Determine the best methods,features,and tools for Janise to use when creating her custom forms.
Janise will now add selected fields from the Customer table to her form.Which section of the form will contain the fields from the selected table?

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

Question 64

Akash created a custom form for his supervisor that includes a subform based on a query for unpaid invoices.  After creating the form and viewing it in Form view,Akash needs to make some changes.  Decide which options are best for Akash to use to make the necessary changes to the custom form design.
Akash has included a calculated field in the subform which was created using a query for unpaid invoices.The calculated field should show the total amount of unpaid invoices from the InvoiceAmt field;however,the form does not show the calculation in Form view.Which expression will solve this problem?

A)Sum([InvoiceAmt])
B)=Sum([InvoiceAmt])
C)Count([InvoiceAmt])
D)=Count([InvoiceAmt])

Question 65

Controls placed at the top of a form in the ____________________ remain on the screen when the form is displayed in Form view or Layout view and do not change when the contents of the Detail section are changed or when navigating from one record to another record.

Question 66

The ____________________ function calculates the total of an expression in a form or report.

Question 67

The Control Source property for a calculated control may be either a(n)____________________ or a(n)____________________.

Question 68

A(n)____________________ is an unbound control that displays text.

Question 69

Bound controls,unbound controls,and calculated controls are placed in the ____________________ section of the Design view when creating a form.

Question 70

A(n)____________________ control in a form design is created using a field selected from the table or query used as the record source for the form.

Question 71

The ____________________ property for a control will automatically resize the control and place it in the same relative position on the screen regardless of monitor size and screen resolution.

Question 72

To improve a form's readability,group related information or underline important values using the ____________________ tool in the form's Design view.

Question 73

Akash created a custom form for his supervisor that includes a subform based on a query for unpaid invoices.  After creating the form and viewing it in Form view,Akash needs to make some changes.  Decide which options are best for Akash to use to make the necessary changes to the custom form design.
Akash used the Header section in his main form design,but he does not plan to use the Footer section.To remove the footer section,which section property should be set to zero?

A)Visible
B)Auto Height
C)Height
D)Display When

Question 74

Janise's College Pet Sitting business is growing rapidly.  She has expanded to include more pet sitters and is creating forms for the sitters to enter information in the business database.She is creating only custom forms.Determine the best methods,features,and tools for Janise to use when creating her custom forms.
Before typing the title,which tool should Janise choose from the Design tab on the Ribbon?

A)Header/Footer
B)Title
C)Logo
D)View Code

Question 75

To select an entire form and set properties for the form,click on the ____________________ at the intersection of the horizontal and vertical rulers.