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
- The All-Important Primary Key
- Working with the Lookup Feature
- Working with Table Properties
- Using Indexes to Improve Performance
- Access Tables and the Internet
- Adding Smart Tags to Your Tables
- Working with PivotTable and PivotChart Views
- Viewing Object Dependencies
- Database Specifications and Limitations
- Table Specifications and Limitations
- Practical Examples: Designing the Tables Needed for a Computer Consulting Firm's Time and Billing Application