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.
-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?
A)Combo box
B)List box
C)Text box
D)Calculated box

Question

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.
-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?
A)Combo box
B)List box
C)Text box
D)Calculated box

Quizplus · Accepted Answer

A combo box would be the best control for Carlos to use in his custom form to meet this requirement. A combo box allows the user to select items from a drop-down list, but also allows the user to enter values that are not in the list. This would allow Carlos to have a pre-populated list of products from his database, but also allow for the addition of new products as needed.