Alison Balter's Mastering Access 97 Development, Second Edition

Chapter 3. What Every Developer Needs to Know About Tables

• Building a New Table

• Selecting the Appropriate Field Type for Your Data

• Working with Field Properties

• The All-Important Primary Key

• Working with the Lookup Feature

• Working with Table Properties

• Using Indexes to Improve Performance

• Access Tables and the Internet

• Practical Examples: Designing the Tables Needed for the Computer Consulting Firm's Time and Billing Application

Building a New Table

There are several ways to add a new table to an Access 97 database: using a wizard to help you with the design process, designing the table from scratch, building the table from a spreadsheet-like format, importing the table from another source, and linking to an external table. The first three methods are discussed ...