Case AC 2-2 Jennifer is creating a new inventory management table for the pet store where she works. She is spending the time upfront to make sure the data types are all assigned correctly. Jennifer's boss asks her if they can include detailed descriptions of each item in the database. The descriptions would be approximately 5000 characters. For this field she assigns the ____ data type.
A) Text
B) Memo
C) AutoNumber
D) Description

Question

Quizplus · Accepted Answer

The Memo data type is specifically designed for larger amounts of text, up to 65,536 characters. Text data type has a limit of 255 characters, so it would not be suitable for a field with a 5000-character description. AutoNumber data type is used for generating unique sequential numbers, and there is no built-in Description data type in Access.

Case AC 2-2 Jennifer Is Creating a New Inventory Management