Microsoft Office Tutorials and References
In Depth Information
Postal Codes
Some organizations
with many customers
spread throughout the
country will, in fact,
have a separate table of
postal codes, cities, and
states. If you call such an
organization to place an
order, they typically will
ask you for your postal
code (or ZIP code), rather
than asking for your city,
state, and postal code.
They then will indicate
the city and state that
correspond to that postal
code and ask you if that
is correct.
If you examine your design, you’ll see that there is one area of redundancy (see the
data in Figure 1–1 on page AC 3). Cities and states are both repeated. Every client whose
postal code is 80330, for example, has Berridge as the city and CO as the state. To remove
this redundancy, you would create a table whose primary key is Postal Code and that
contains City and State as additional fi elds. City and State would be removed from the Client
table. Having City, State, and Postal Code in a table is very common, however, and usually
you would not take such action. There is no other redundancy in your tables.
Starting Access
If you are using a computer to step through the project in this chapter, and you want your
screen to match the fi gures in this topic, you should change your screen’s resolution to
768. For information about how to change a computer’s resolution, read
Appendix E.
To Start Access
The following steps, which assume Windows is running, start Access based on a typical installation. You may
need to ask your instructor how to start Access for your computer.
Click the Start button on the
Windows taskbar to display the
Start menu.
Point to All Programs on the Start
menu to display the All Programs
Point to Microsoft Offi ce on the
All Programs submenu to display
the Microsoft Offi ce submenu
(Figure 1–5).
Offi ce
Microsoft Offi ce
Access 2007
Windows displays
commands on the
Start menu above the
Start button
Offi ce
Figure 1–5
Search JabSto ::

Custom Search