ACC: Understanding Relational Database Design Available in Download Center

ID: Q164172

The information in this article applies to:

Microsoft Access versions 7.0, 97

SUMMARY

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

The following file is available for download from the Microsoft Download Center. Click the file name below to download the file:

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 more information about how to download files from the Microsoft Download Center, please visit the Download Center at the following Web address

http://www.microsoft.com/downloads/search.asp

and then click How to use the Microsoft 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

Additional query words:

Keywords : kbfile Softlib
Version : WINDOWS:7.0,97
Platform : WINDOWS
Issue type : kbinfo