Article ID: 164172 - Last Review: January 19, 2007 - Revision: 4.3 ACC: "Understanding Relational Database Design" Document Available in Download CenterThis 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: Collapse this image  Ureldes.doc A Microsoft Word 6.0/95 document Readme.txt This Readme file 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
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)
| Article Translations
|
| United States | Change | | | All Microsoft Sites |
Help and Support
Back to the top
|
