Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: "Understanding Relational Database Design" Document Available in Download Center

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

View products that this article applies to.

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 2000.

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
   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

↑ Back to the top

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

↑ Back to the top

Keywords: KB234208, kbfile, kbgraphxlinkcritical, kbdownload, kbinfo

↑ Back to the top

Article Info
Article ID : 234208
Revision : 1
Created on : 8/9/2004
Published on : 8/9/2004
Exists online : False
Views : 438