Microsoft KB Archive/283698

= &quot;Understanding Relational Database Design&quot; document is available in Download Center =

Article ID: 283698

Article Last Modified on 6/23/2006

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q283698



Novice: Requires knowledge of the user interface on single-user computers.



For a Microsoft Access 97 version of this article, see 164172.



For a Microsoft Access 2000 version of this article, see 234208.



SUMMARY
The Reldes.doc Word document shows you how to plan and design a database from the ground up. For practical examples, it uses the database design of the Northwind Traders sample database included in Microsoft Access 2002.

The following file is available for download from the Microsoft Download Center:

Download DBDesign.exe now

The DBDesign.exe file contains the following file:   Reldes.doc    A Microsoft Word document For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Note To see this information for earlier versions of Microsoft Access, please see the following article in the Microsoft Knowledge Base:

164172 &quot;Understanding Relational Database Design&quot; document available in Download Center



MORE INFORMATION
The Table of Contents of Reldes.doc is as follows:

  Overview The database design process Steps in designing a database Common design problems Determining the purpose Determining the tables you need Determining the fields you need Tips for determining fields Primary key fields Determining the relationships Refining the design Additional reading and practice NOTE: Microsoft offers a WebCast that discusses the basics of database normalization. To view this WebCast, please visit the following Microsoft Web site:

http://support.microsoft.com/servicedesks/webcasts/wc060600/wc060600.asp?fr=1

Keywords: atdownload kbdownload kbfile kbgraphxlinkcritical KB283698

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.