MA2 - Microsoft Access 2000 Intermediate
Covers intermediate Microsoft Access topics, including Table Design, Primary Keys, Memo Fields, Normalization, Relating Tables, Custom Forms, Queries against Multiple Tables, Calculated Fields, Internet features, Database Maintenance, and more.
"[The instructor) is very knowledgable on the topic and he knows how to explain the concepts that make this work. Be prepared to practice a lot of new techniques and ways of doing a task in the Access 2000 enviroment.." -- Victor R. from Chula Vista, CA
"Take this course! Even if you think you are an advanced Access user, there is so much to be learned in the beginning and intermediate class. It was so worth it for me to have a sound foundation and learn the many shortcuts that will ultimately save my company time and money! [The instructor) is great. She is fun and makes learning easy.." -- Kathy R. from San Diego, CA
"Her years of experience and easy-going teaching style/personality made this a great course.." -- Kenneth Eric M. from San Diego, CA
"[The instructor) is a great instructor. She struck a balance between the advanced and the beginning intermediate students. She has great depth.." -- Doug P. from San Diego, CA
"[The instructor) was excellent! The combo of her knowledge and excitement made her a great teacher. I also have to comment on her flexability--she let us wonder from the book to get to all the questions we wanted answered.." -- Jessica M. R. from San Diego, CA
Introduction
Modifying the design of a table
Displaying a table in design view
Specifying a required field/ defining a default field value
Setting a primary key for a table
Adding a memo field to a table
Additional table design topics
Working with multiple tables
Displaying multiple tables on the Access desktop
Resizing and repositioning the table window
Relating tables
Creating a relationship between two tables
Working with a custom form
Designing a custom form
Adding a header and footer to a form
Adding a calculated control to a form
Using a custom form to enter data
Intermediate query techniques
Extracting information from multiple tables
Intermediate report techniques
Creating a report of information in multiple tables
Adding a calculated control to a report
Adding a cover sheet to a report
Creating a mailing label report
Using access Internet features
Accessing the world wide web from the Access application window
Linking an Access object to a web page
Exporting an Access object to an HTML file
Additional intermediate Access features
Using a database wizard
Compacting and repairing a database
Backing up and restoring a database
Using the office clipboard
Final case study