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. How to find information about designing a database in Access 2000

How to find information about designing a database in Access 2000

View products that this article applies to.

This article was previously published under Q288947
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

For a Microsoft Access 97 version of this article, see 288949� (http://support.microsoft.com/kb/288949/ ) .
For a Microsoft Access 2002 version and a Microsoft Office Access 2003 version of this article, see 289533� (http://support.microsoft.com/kb/289533/ ) .
For a Microsoft Access 97 version of this article, see 288949� (http://support.microsoft.com/kb/288949/ ) .
For a Microsoft Access 2002 version and a Microsoft Office Access 2003 version of this article, see 289533� (http://support.microsoft.com/kb/289533/ ) .

↑ Back to the top

Summary

If you decide to store the data for your solution in an Access database or in another relational database, designing the database structure is likely to be the most challenging part of building the solution. Although it is fairly easy to modify the data model while you are developing the solution, it is much more difficult once you have started to build other database objects. Therefore, you should put as much effort as possible into designing the data model before you begin to create any objects in the database. Developing a solution based on a well-designed data model will make it much easier for you to develop the solution.

↑ Back to the top

More information

If you are new to relational database design, start by using the following resources:
  • For an overview of relational database design, click the following article number to view the article in the Microsoft Knowledge Base:
    209534� Description of the database normalization basics in Access 2000
  • Download the "Understanding Relational Database Design" document. This document shows you how to plan and design a database from the ground up. To download this document, click the following article number to view the article in the Microsoft Knowledge Base:
    234208� "Understanding Relational Database Design" document available in Download Center
  • Analyze your tables by using the Table Analyzer Wizard. For more information about the Table Analyzer Wizard, click the following article number to view the article in the Microsoft Knowledge Base:
    208679� How the Table Analyzer Wizard works
  • You can download database templates that may be used for many common purposes from the following Microsoft Web site:

    http://office.microsoft.com/en-us/templates/default.aspx
  • Read one of the following books:
    • Hernandez, Michael. Database Design for Mere Mortals. Reading, MA: Addison-Wesley Developers Press, 1997.

↑ Back to the top

Keywords: KB288947, kbhowto, kbdesign, kbdatabase

↑ Back to the top

Article Info
Article ID : 288947
Revision : 7
Created on : 5/9/2005
Published on : 5/9/2005
Exists online : False
Views : 303