Access Tutorial 6

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

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

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

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

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 form may only be created from scratch in Form view.

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

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

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

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

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

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?

Tab order may only be changed in form Design view.

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

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

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

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

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 combo box control may only be modified in form Design view.

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

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

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

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

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

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?

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

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?

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

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

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

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

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

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 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 selected control will display how many sizing handles?

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.

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

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

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.

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

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

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

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?

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

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

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

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.

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?

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.

The record source for a subform must be a table.

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

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

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?

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?

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

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

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

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?

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

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

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.