Microsoft Office Tutorials and References
In Depth Information
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
7. Determine a location for the database. The database you have designed will be stored in
a single ﬁ le. You need to determine a location in which to store the ﬁ le.
When necessary, more speciﬁ 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
For more information on
database design methods
and for techniques
for identifying and
visit the Access 2007
Database Design Web
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 ﬁ 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 ﬁ 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 ﬁ elds: Product Code,
Description, On Hand, and Price. The Product Code ﬁ eld is the primary key.
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
ﬁ nancial information.