Microsoft® Office Access 2007 on Demand

4. Working with Fields

What You’ll Do

Insert, Delete, and Reorder Fields

Specify Data Types and Field Properties

View Field Properties

Change and Update Field Properties

Set Field Size

Format Text Values and Memo Text

Format Date and Time Values

Format Numbers and Currency Values

Perform a Total Calculation

Create Input Masks and Indexed Fields

Specify Required Fields and Default Values

Add a Caption to a Field

Validate Field Values

Create a Lookup Field

Set Lookup Properties

Create a Multivalued Field

Attach Files to Field Records

Set Table Properties

Introduction

An important part of creating your own database is field design. How you design your fields determines how accurately they will be able to store data. Microsoft Office Access 2007 ...