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

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.