Share this Page URL

Part: I The Basics of Access Development > What Every Developer Needs to Know A... - Pg. 30

30 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 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 of table design in Access 2003. After reading this chapter, you will be ready to build the other components of your application, knowing that the tables you design provide the application with a strong foundation. Creating a New Database In generic terms, a database stores a collection of information. Access databases are composed of tables, queries, forms, reports, data access pages, macros, and modules. Each table within a da- tabase should contain information about a particular subject. You use queries to extract specific information from one or more tables. The forms, reports, and data access pages provide a means of displaying your data. Finally, macros and modules allow you to build an integrated application.