Chapter 14. Power Table Techniques

Working with the design of tables is not as simple as adding a field, naming it, and selecting the field type. You can do a lot more than that to customize what you store in a table and how it behaves. In this hour you'll learn the following:

  • How to refine field and table properties

  • How to work with the powerful Lookup Wizard

  • How to use indexes to improve performance

Working with Field Properties

After you have added fields to a table, you need to customize their properties. Field properties let you control how Access stores data as well as what data the user can enter into a field. The available properties differ depending on which field type you select. You can find a comprehensive list of properties under the ...

Get Sams Teach Yourself Microsoft® Office Access 2003 in 24 Hours 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.