Page 1 of 13PREVNEXT

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.

About this course

This course includes:

  • One self-paced lesson.
  • One practice session for hands-on experience. The practice requires Microsoft Access 2010.
  • A short test at the end of the lesson. The test is not scored.
  • 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.
Page 1 of 13PREVNEXT