ACC: Where to find information about designing a database in Access

Article translations Article translations
Article ID: 288949 - View products that this article applies to.
This article was previously published under Q288949
This article has been archived. It is offered "as is" and will no longer be updated.
Novice: Requires knowledge of the user interface on single-user computers.

For a Microsoft Access 2000 version of this article, see Q288947
Expand all | Collapse all


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.

More information

If you are new to relational database design, start by using the following resources:
  • For an overview of relational database design, see the following Knowledge Base article:
    100139 ACC: Database normalization basics
  • View the Database Normalization Basics WebCast.
  • 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, see the following article in the Microsoft Knowledge Base:
    164172 ACC: "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, see the following Knowledge Base article:
    140636 ACC: How the Table Analyzer Wizard works
  • Visit the Access Database Table Design (microsoft.public.access.tablesdbdesign) peer-to-peer newsgroup. You can interact with other users of Access, including Microsoft Most Valuable Professionals (MVPs). You can use any newsreader software to access these newsgroups.
  • Read one of the following books:
    • Hernandez, Michael. Database Design for Mere Mortals. Reading, MA: Addison-Wesley Developers Press, 1997.
    • Riordan, Rebecca. Designing Relational Database Systems


Article ID: 288949 - Last Review: October 26, 2013 - Revision: 5.0
Applies to
  • Microsoft Access 97 Standard Edition
kbnosurvey kbarchive kbhowto KB288949

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from