MicrosoftВ® Office Access(TM) 2007 Inside Out (Microsoft Office Access Inside Out)
Overview
No matter how carefully you design your database, you can be sure that you’ll need to change it at some later date. Here are some of the reasons you might need to change your database.
-
You no longer need some of the tables.
-
You need to perform some new tasks that require not only creating new tables but also inserting some linking fields in existing tables.
-
You find that you use some fields in a table much more frequently than others, so it would be easier if those fields appeared first in the table design.
-
You no longer need some of the fields.
-
You want to add some new fields that are similar to fields that already exist.
-
You discover that some of the data you defined would be better stored as a different data type. For example, a field that you originally designed to be all numbers (such as a U.S. ZIP Code) must now contain some letters (as in a Canadian postal code).
-
You have a number field that needs to hold larger values or needs a different number of decimal places than you originally planned.
-
You can improve your database design by splitting an existing table into two or more tables using the Table Analyzer Wizard.
-
You discover that the field you defined as a primary key isn’t always unique, so you need to change the definition of your primary key.
-
You find that some of your queries take too long to run and might execute more quickly if you add an index to your table.
| Note | |
This chapter takes a look at how you can make these changes easily and relatively painlessly with Microsoft Office Access 2007. If you want to follow along with the examples in this chapter, you should first create the Contact Tracking database described in Chapter 4.
| Note | |
Категории