Case-Based Critical Thinking Questions
Case 12-2
Marissa's monogram business has expanded exponentially since she added an online catalog and ordering to her business. Her database needs to be expanded and changed to meet the needs of the growing business. Her database includes tables for monogram styles, catalog products, orders, billing, customers, and vendors.
-Each number in the ItemNumber field for all catalog products were created manually by Marissa. Her new assistant pointed out that she could have the database create the ItemNumber automatically by changing the field's data type to ____.
A)AutoNumber
B)Number
C)Long Integer
D)Calculated

Question

Case-Based Critical Thinking Questions
Case 12-2
Marissa's monogram business has expanded exponentially since she added an online catalog and ordering to her business.  Her database needs to be expanded and changed to meet the needs of the growing business.  Her database includes tables for monogram styles, catalog products, orders, billing, customers, and vendors.
-Each number in the ItemNumber field for all catalog products were created manually by Marissa. Her new assistant pointed out that she could have the database create the ItemNumber automatically by changing the field's data type to ____.
A)AutoNumber
B)Number
C)Long Integer
D)Calculated

Quizplus · Accepted Answer

An AutoNumber field will automatically generate a unique number for each record added to the database, which would be useful for generating unique ItemNumbers for catalog products without having to manually create them.