Design the tables for a new database

Learn how to plan a database Learn how to use Access 2010 by designing and creating a database. You'll start by learning how to design the tables and relationships for a new database. A good design ensures your database captures all your data accurately. This is the first course in a series that teaches beginners how to use Access 2010.

Start course button

About this course

This course includes:

  • One practice session for hands-on experience. The practice requires Microsoft Access 2010.

  • A Quick Reference Card you can print at the end of the course.


After completing this course you will be able to:

  • Plan the table structure of a new database.

  • Plan the fields — the individual columns in each table.

  • Plan the primary key fields that enable the relationships among your tables.

  • Design tables for a web database — a database you publish to SharePoint.

Topics in this course

  1. Start with a plan

  2. Decide on a purpose

  3. List the data you want to store

  4. Group your data by subject

  5. From groups, fields

  6. Plan data types

  7. Plan your primary keys

  8. Plan your foreign keys

  9. Design tables for SharePoint

  10. Practice

  11. Quick Reference Card

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!