Preparations for relational database session
We will be turning to relational databases in the next session, so do these readings to prepare yourselves.
Read
In Access 2007: The Missing Manual, 1st Edition,
read 1. Creating Your First Database.
It wouldn't hurt to read
- the Wikipedia entry on Relational Databases for background
- and Microsoft's Database design basics
- If you would like a bit more audio-visual approach, try Microsoft's online Access training course
Read this linked article twice
- Read it prior to the first relational database session so you will have an idea about why relational databases are useful.
- Then read it again after the tables session and prior to the session about relationships
Although we will not get into relationships until the third relational database session, an understanding of how to decompose your task into related tables will help you decide how to create the tables you will later need to relate.
[top]
Glance over these readings to prepare yourselves for building tables
-
In Access 2007: The Missing Manual, 1st Edition,
read 2. Building Smarter Tables. - Learn the structure of an Access database
- Create a table
To learn more about the components, glance over:
- Tech on the Net Topics: Access Tables
- consider using Leszynski Naming Conventions for your objects
If you would like a bit more audio-visual approach, try
Microsoft's online Access training course