Exam 6: Using Form Tools and Creating Custom Formsmodule

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.

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.

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?

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

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

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.

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 tool used to form a group of related controls or to separate the group from other controls is the ____ tool.

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

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

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

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

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

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?

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 subform may be added to a main form by using the Subform/Subreport tool or by using the ____.

The record source for a subform must be a table.

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

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

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?