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.

Goals

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

Applies To: Access 2010



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language