Microsoft Office Tutorials and References
In Depth Information
Plan
Ahead
(continued)
Every employee whose department number is 12, for example, would have the same
department name. It would be better to split the table into two tables, one for Employees
and one for Department. In the Department table, the Department Name is stored
only once.
7. Determine a location for the database. The database you have designed will be stored in
a single fi le. You need to determine a location in which to store the fi le.
When necessary, more specifi c details concerning the above guidelines are presented at
appropriate points in the chapter. The chapter also will identify the actions performed and
decisions made regarding these guidelines during the creation of the database shown in
Figure 1–1 on page AC 3.
Designing a Database
Database Design
For more information on
database design methods
and for techniques
for identifying and
eliminating redundancy,
visit the Access 2007
Database Design Web
page (scsite.com/ac2007/
dbdesign).
This section illustrates the database design process by showing how you would design
the database for JSP Recruiters from a set of requirements. In this section, you will use a
commonly accepted shorthand to represent the tables and fi elds that make up the database
as well as the primary keys for the tables. For each table, you give the name of the table
followed by a set of parentheses. Within the parentheses is a list of the fi elds in the table
separated by columns. You underline the primary key. For example,
Product (Product Code, Description, On Hand, Price)
represents a table called Product. The Product table contains four fi elds: Product Code,
Description, On Hand, and Price. The Product Code fi eld is the primary key.
Database Requirements
JSP Recruiters needs to maintain information on both clients and recruiters. It
currently keeps this data in the two Word tables and two Excel workbooks shown in
Figure 1–2. They use Word tables for address information and Excel workbooks for
fi nancial information.
Client Number
Client Name
Street
City
State
Postal Code
AC34
Alys Clinic
134 Central
Berridge
CO
80330
BH72
Berls Hospital
415 Main
Berls
CO
80349
BL12
Benton Labs
12 Mountain
Denton
CO
80412
EA45
ENT Assoc.
867 Ridge
Fort Stewart
CO
80336
FD89
Ferb Dentistry
34 Crestview
Berridge
CO
80330
FH22
Family Health
123 Second
Tarleton
CO
80409
MH56
Maun Hospital
76 Dixon
Mason
CO
80356
PR11
Peel Radiology
151 Valleyview
Fort Stewart
CO
80336
(a)
Client Address
Information
(Word Table)
TC37
Tarleton Clinic
451 Hull
Tarleton
CO
80409
WL56
West Labs
785 Main
Berls
CO
80349
Figure 1–2
Search JabSto ::




Custom Search