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

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

By changing the data type of the ItemNumber field to AutoNumber, the database will automatically generate a unique number for each new catalog product added to the table. This not only saves time but also reduces the chances of human error in manually assigning ItemNumbers.

Marissa's Monogram Business Has Expanded Exponentially Since She Added an Online