This article was previously published under Q164172
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Novice: Requires knowledge of the user interface on single-user computers.
Ureldes.doc shows you how to plan and design a database from the ground up.For practical examples, it uses the database design of the NorthwindTraders sample database included in the Microsoft Access package.
The following file is available for download from the Microsoft Download Center:
The Reldesgn.exe file contains the following files:
Ureldes.doc A Microsoft Word 6.0/95 document Readme.txt This 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 Microsoft Access 2000, please see the following article in the Microsoft Knowledge Base:
234208 ACC2000: "Understanding Relational Database Design" Document Available in Download Center
The table of contents of Ureldes.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: