Dina created a database related to essential oils and their uses. For every oil, she wants to enter a unique code number. Which data type would be suitable for entering this data? A. boolean
b. autonumber
c. bloB
d. memo
e. null

The answer to this question is given below in the explanation section.

Explanation:

The correct answer to this question is b: autonumber.

Because the autonumber is a type of data used in Microsoft Access tables to

create or generate an automatically incremented numeric number. It may be used to create an identity column that uniquely identifies each record of a table in MS Access. Only one AutoNumber is allowed in each table.

Basically, autonumber is like a primary key in a table that uniquely identifies the record in the database.

So, for Dina, she needs to use the autonumber to store a unique code number for each oil.

While the other options are not correct because:

boolean data types represent true or false, 0 or 1 values in the database. It is noted that many records may have boolean data type in a table. while the memo is a formal model to represent metabolomic and its associated data. Blob (binary large object) is a collection of binary data stored as a single entity in a database management system. Null represents an empty value in the column.

answerthetitle bar displays the title of the document which you are currently working;