—•— MS Access —•

—•—

Course Description: MS Access - Paul Houston

$25.00

This course is aimed at those wishing to create a relational database using MS Access version 97 or greater. Ideally you should be comfortable with using a Windows based PC, although no prior knowledge of Access is required.

You will learn how to create the database structure, create queries to sort and extract information from the database, set up forms to input and view data, and generate reports from the tables and queries you have created.

The course will consist of six weekly lessons with a 7th week wrap up and summary.

Prerequisites:

Working knowledge of your PC and Windows
Microsoft Access installed on your PC (at least version 97)
The time and commitment to complete the six assignments. Access is very much a package with which you will only get out of it what you put into it!

Lessons

Week 1
What is a database?
Creating a database using the Wizard
Navigating the database
Entering and Finding records
Creating a Table using the Wizard

Week 2
Creating a Table using Design view
Field Types
Creating a Form
Filtering the database
Form Layout

Week 3
More on Creating Tables
Setting up relationships
Creating subforms
Adding Command Buttons
Form Properties and Controls

Week 4
Creating Queries using
Sorting records
Searching for records using Criteria
Modifying the query
Calculated Fields on a Query

Week 5
Creating a Report
Sorting and Grouping Records
Report Summaries
Customising the Report Design
Formatting the Report

Week 6
Input Masks
Expression Builder
Creating a Switchboard
Editing Switchboard items
Switchboard Design View

Week 7
Database design tips
Questions and Answers
Wrap up and Summary

Students Please Note:
At this time we do not offer support for software incompatiblity problems with Vista nor can we assist you with any Vista operating system problems. Microsoft and/or your software manufacturer should be able to advise you.

Links