Design the tables for a new 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 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.
