Exam 2: Access 2: Using Form Tools and Creating Custom Forms

Case Based Critical Thinking Questions Case 6-1 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?

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

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

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

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 number of occurrences of an expression is determined using the ____ function in a form or report.

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.

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 Access tool that allows the user (or designer)to create detailed documentation of all, or selected, objects in a database is the ____.

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

Options on the Arrange tab apply only to the datasheet when the Split Form tool has been used to create the 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.

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

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

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

Case Based Critical Thinking Questions Case 6-1 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.

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

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

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

Case Based Critical Thinking Questions Case 6-1 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?