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

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

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.

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

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

A selected control will display how many sizing handles?

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

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.

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

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. 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?

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

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

Tab order may only be changed in form Design view.

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.

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

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