This course focuses on working with databases.
In this course, you will learn the basics of Access, which is the industry standard software for database manipulations.
You will learn how to create a database, then how to fill it with data.
Then, you will learn how to interrogate the database to produce pertinent information.
You will also learn how to make tables, reports and forms.
Everyone will have the opportunity to work hands on in building a few different databases.
At the end of the course, you will have created a complete slide presentation on a topic chosen by the class.
Everyone will have the opportunity to work hands on in building this presentation.
Prerequisites: This course is intensive.
There is no homework, but be prepared to work hard when you are in class.
This course is ONLY for people who are already comfortable with Windows environment (95, 98, ME, XP, etc.)
and who have at least basic word processing skills.
Introduction to course
Introduction to Access
Difference between Excel and Access
What is a database? Examples
Records and fields
Creating a database
Create a new query
Print the results of the query
Save the query
Create a table
Add data to the table
Print the contents of a table
Create more tables
Create a form
Create a report
Maintaining a database
Adding records to a table
Adding a field
Modifying a field
Deleting a field
Specifying required fields, a range, default value, etc.
Last update: March 2005 (next update to be determined)