Chapter 4. Working with Fields
Each table consists of one or more fields. In this chapter, you will learn how to set field properties and field types, and you will create input masks and validation rules to cut down on data-entry errors.
Open a Table in Design View
Rearrange Fields
Insert and Delete Fields
Understanding Data Types
Change a Field's Data Type
Understanding Field Properties
Understanding Field Sizes
Change a Field Size
Set a Field's Format
Set a Field Caption
Set a Default Value
Make a Field Required
Index a Field
Apply Smart Tags
Create an Input Mask
Create a Validation Rule
Create a Record-Level Validation Rule
Open a Table in Design View
To modify ...
Get Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
