Microsoft® Office Access™ 2007 Plain & Simple

Chapter 6. Customizing Fields

In this section:

• Working with Tables

• Assigning a Data Type

• Viewing or Changing Field Properties

• Introducing the Expression Builder

• Formatting Field Contents

• Creating Input Masks

• Assigning Required Fields and Requiring Data Entry

• Setting Default Values

• Indexing Field Values

• Validating Data Entry

• Creating a Lookup Field

• Creating an Append-Only Memo Field

• Creating an Attachment Field

When you create a database table using a wizard, Microsoft Office Access 2007 assigns a data type and properties to each field in the table. When you create a table from scratch, or if you want to modify the settings Access applied to the table, you can change a field’s properties so it stores data efficiently and interacts well with other fields in the ...