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

Quizplus · Accepted Answer

The Datasheet tool would be the best choice for Carlos to use because he wants to display all fields from the table using a datasheet layout. This tool will allow him to easily enter data into the form and view all of the fields in a table-like format. The Split Form tool would not be the best choice because it would display the form as a split form and show only one record at a time. The Multiple Items tool would not be the best choice because it is intended for displaying multiple records at once, whereas Carlos wants to display all fields from one record. The Controls Gallery is not a tool for creating forms, but rather a collection of controls that can be used on forms.