Help and Support

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

Article ID:164172
Last Review:January 19, 2007
Revision:4.3
This article was previously published under Q164172
Novice: Requires knowledge of the user interface on single-user computers.

SUMMARY

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 Northwind Traders sample database included in the Microsoft Access package.

The following file is available for download from the Microsoft Download Center:
Download Reldesgn.exe now (http://download.microsoft.com/download/access97/white3/1/win98/en-us/reldesgn.exe)
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 (http://support.microsoft.com/kb/119591/EN-US/) 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 (http://support.microsoft.com/kb/234208/EN-US/) ACC2000: "Understanding Relational Database Design" Document Available in Download Center

MORE INFORMATION

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:
http://support.microsoft.com/servicedesks/webcasts/wc060600/wc060600.asp?fr=1 (http://support.microsoft.com/?scid=http%3a%2f%2fsupport.microsoft.com%2fservicedesks%2fwebcasts%2fwc060600%2fwc060600.asp%3ffr%3d1)

APPLIES TO
Microsoft Access 95 Standard Edition
Microsoft Access 97 Standard Edition

Back to the top

Keywords: 
kbdownload kbfile kbgraphxlinkcritical kbinfo KB164172

Article Translations

 

Related Support Centers

Other Support Options

  • Contact Microsoft
    Phone Numbers, Support Options and Pricing, Online Help, and more.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.