Free Access Class

Looking for a course on Microsoft Access 2003. Sony has a free one starting on July 17, 2006.

Course Outline

Lesson 1: Your First Database
In this lesson, you'll learn how databases work, and how to create one on your own computer. Then you'll create a table for storing data, and practice entering data into its datasheet.
Lesson ( Will be posted Monday, July 17 )
Assignment
Quiz


Lesson 2: Improving and Connecting Tables
Tables are the basis of any database. In this lesson, you'll learn how to modify and improve your tables, and how to join them together to create a relational database management system.
Lesson ( Will be posted Thursday, July 20 )
Assignment
Quiz


Lesson 3: Finding, Sorting, and Filtering Data
Data in a database isn't much good unless you can locate the exact piece of data you need at any given moment. In this lesson, you'll learn some techniques for finding, sorting, and filtering data, and then save a filter for later reuse.
Lesson ( Will be posted Monday, July 24 )
Assignment
Quiz


Lesson 4: Creating Queries
Queries enable you to store filters for later reuse, but they're much more powerful than that. In this lesson, you'll learn how to construct queries that sort and filter data, join two or more tables, and even create new fields by calculating the values in other fields.
Lesson ( Will be posted Thursday, July 27 )
Assignment
Quiz


Lesson 5: Creating Data Entry Forms
Many users find it easier to enter data into a user-friendly form than a datasheet. In this lesson, you'll learn how to create forms that contain fields, labels, headers/footers, and even subforms with information from linked tables.
Lesson ( Will be posted Monday, July 31 )
Assignment
Quiz


Lesson 6: Creating Reports
Datasheets and forms are great for onscreen use, but they're not very attractive when printed. Reports enable you to format and lay out your data attractively for distributing in hard-copy form. In this lesson, you'll learn how to create, format, and print a report.
Lesson ( Will be posted Thursday, August 3 )
Assignment
Quiz