- Differentiate among field properties
- Discuss field name requirements
- Discuss types of data used in Microsoft Access
If tables are the building blocks of databases, fields are the key component of tables. We will explore field properties which tells Access what type of data will be entered into a specific field. Then we will discuss the importance of assigning names to each field and the rules for ensuring a valid field name. Finally we will get into more detail regarding data types and field properties.
What are field properties?
You can view the transcript for “What are Field Properties in MS Access ?” here (opens in new window).
Naming rules
You can view the transcript for “Rules of writing a field name in access” here (opens in new window).