Alison Balter’s Mastering Microsoft Access 2002 Desktop Development

Chapter 2. What Every Developer Needs to Know About Tables

<feature><title>In This Chapter</title>

• Building a New Table 40

• Selecting the Appropriate Field Type for Your Data 44

• Working with Field Properties 50

• The All-Important Primary Key 62

• Working with the Lookup Feature 63

• Working with Table Properties 65

• Using Indexes to Improve Performance 67

• Access Tables and the Internet 67

• Working with PivotTable and PivotChart Views 72

</feature>

Why This Chapter Is Important

It is useful to think of table design as similar to the process of building a foundation for your house. Just as a house with a faulty foundation will fall over, an application with a poor table design will be difficult to build, maintain, and use. This chapter covers all of the ins and outs ...