Page 37 - Computer - 8

Field Names
Each field in a table is given a unique name. A field name should be descriptive to identify the content
and purpose of the field. A field name in Access can:
• be upto 64 characters.
• include letters, numbers, spaces, and special characters.
• be in uppercase, lowercase, or mixed case.
• not include a period ( . ), exclamation mark ( ! ), bracket ( [ ] ), or accent grave ( ` ).
• not start with a blank space.
Data Types
Each field in a table has a data type associated with it. A data type specifies the type of values that the
field can contain. The given table describes the data types available in Access 2019.

Data Type Description Example
Lets you store alpha-numeric data up to 255 Name: Lakshya
Short Text
characters. Address: 23-A, Rajnagar Extn
Lets you store a large amount of alpha-numeric data Comments: He has to appear
Long Text
with the first 64000 characters visible on the screen. for his interview on Jan 30.
Lets you store numeric data that can be used in Age: 30
Number
mathematical calculations. Experience: 5 years

Date of Interview: 30-Jan-2023
Date/Time Lets you store date and/or time values.
Time of Interview: 10:30 AM
Lets you store currency values that can be displayed
Currency Salary Expected: ` 45000
in different formats.

Lets you store integers that increment automatically
when a new record is added to the table. By default,
AutoNumber Candidate ID: CD0024
each new table in Access contains an AutoNumber
field ID used as the primary key.

Yes/No Lets you store logical values – Yes/No or True/False. Reference: Yes
Lets you store files from Windows-based programs,
OLE Object Photo of candidate
such as Word documents and Excel Spreadsheets.
Lets you store links to websites or files on a network
Hyperlink Email address
or on your computer.
Lets you store files such as images and supported file
Attachment Scanned documents
formats, similar to email attachments.
Lets you store the result of a calculation based on Max Salary Offered:
Calculated
other fields within the same table. Salary Expected + 10000

Knowledge Discovery Subject Enrichment

Some datatypes available in Access 2019 are not applicable on older versions of Access. When you select
such a data type for a field, Access displays a warning message about the incompatibility of the data type.

35