5.9: Field Names and Data Types
- Page ID
- 14806
\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)
Learning Objectives
- Discuss field name requirements
- Discuss types of data used in Microsoft Access
Field Names
A field name should be descriptive enough to identify the purpose of the field, without being overly long to prevent excessive typing. Enter the field name by placing the pointer in the first row of the Table Design window under the Field Name column. In order to ensure a valid field name, a field name:
- Cannot exceed 64 characters,
- Cannot include periods (.), exclamation points (!), accent grave (`), or brackets ([]),
- Cannot include spaces,
- Cannot include low-order ASCII characters,
- Cannot start with a blank space.
Practice Question
Data Types
The data type must be consistent with the data to be stored in the field. The “text” type is the most commonly used data type, including numbers that will not be added like social security or street address numbers. Here is a partial list of Access data types:
| Data Type | Description |
|---|---|
| Short text | Alphanumeric characters |
| Long text | Alphanumeric characters |
| Number | Numeric values |
| Large Number | Numeric values |
| Date/Time | Date and time data |
| Currency | Monetary data |
| AutoNumber | Automatic number increments |
| Yes/No | Logical values: Yes/No, True/False, etc. |
| OLE Objects | Pictures, graphs, sound, video |
| Hyperlink | Line to an Internet resource |
| Attachment | External files |
| Calculated | Stores calculations based on other fields |
| Lookup Wizard | Displays data from another table |
Practice Question
Contributors and Attributions
CC licensed content, Original
- Field Names. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution