Microsoft® Access® 2010 Plain & Simple

Chapter 5. 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 Access 2010 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 2010 applied to the table, you can change a field’s properties so it stores data efficiently and interacts well with other fields in the ...