Alison Balter’s Mastering Microsoft® Office Access 2007 Development

Chapter 2. What Every Developer Needs to Know About Databases and Tables

IN THIS CHAPTER

• Why This Chapter Is Important
• Creating a New Database
• Building a New Table
• Selecting the Appropriate Field Type for Your Data
• Working with Field Properties
• Using the All-Important Primary Key
• Working with the Lookup Feature
• Working with Table Properties
• Using Indexes to Improve Performance
• Using Access Tables with the Internet
• Viewing Object Dependencies
• Examining Database Specifications and Limitations
• Examining Table Specifications and Limitations
• Practical Examples: Designing the Tables Needed for a Computer Consulting Firm’s Time and Billing Application

Why This Chapter Is Important

You might find it is useful to think of table design as similar to ...