Question

what is the data type for age field​

Answer 1

Introduction to data types and field properties

Access for Microsoft 365 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007

Every table in Access is made up of fields. The properties of a field describe the characteristics and behavior of data added to that field. A field's data type is the most important property because it determines what kind of data the field can store. This article describes the data types and other field properties available in Access, and includes additional information in a detailed data type reference section.

Answer 2

$\huge \mathfrak\fcolorbox{pink}{lavenderblush}{Answer♡}$

SQL

For example, a type of INT which stands for integer in SQL server can only accept whole numbers, decimal values are not allowed. When age is defined as an integer the expectation is data are entered as whole numbers.