ACC2000: "Understanding Relational Database Design" Document Available in Download Center

This article was previously published under Q234208
This article has been archived. It is offered "as is" and will no longer be updated.
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 2002 version of this article, see 283698.
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 2000.

The following file is available for download from the Microsoft Download Center:
The DBDesign.exe file contains the following file:
   Reldes.doc    A Microsoft Word document   Readme.txt    A Readme file				
For additional 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 to 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 ACC: "Understanding Relational Database Design" Document Available in Download Center
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:

Article ID: 234208 - Last Review: 12/05/2015 14:49:31 - Revision: 1.0

Microsoft Access 2000 Standard Edition

  • kbnosurvey kbarchive kbinfo kbdownload kbgraphxlinkcritical kbfile KB234208