Question

In the Access database, such field types are allowed:


a.
numeric, text, protected

b.
logical, date, numeric, monetary, OLE

c.
numeric, character, graphic, array

d.
table, form, query​

Answer 1

Answer:

table form query

Explanation:

option d

Answer 2

a. numeric, text, protected

In the Access database, such field types are allowed numeric, text, protected.

• Numbers are stored in database columns as numeric data types. Precise numeric kinds and values where the precision and scale need to be retained are the typical categories used to classify these data types. INTEGER, BIGINT, DECIMAL, NUMERIC, NUMBER, and MONEY are the precise numerical kinds.
• Field, control, and object names in desktop Microsoft Access databases: can include up to 64 characters.
• All of the common SQL numeric data types are supported by MySQL. There are approximate numerical data types like FLOAT, REAL, and DOUBLE PRECISION, as well as exact numerical data types like INTEGER, SMALLINT, DECIMAL, and NUMERIC.
• Short Text, Long Text, Number, Big Number, Date/Time, Currency, AutoNumber, Yes/No, Calculated, and Lookup Wizard are just a few of the data kinds that MS Access offers.
• Any type of data that is measured in a non-numerical (or word) form is referred to as non-numerical data. Letters and symbols are used. Only a word format is capable of identifying this data. For instance, the address, birthdate, and name of the employee.

#SPJ3