MA1 - Introduction to Microsoft Access 2000
Thorough introduction to Microsoft Access, includes coverage of Access Objects, Creating Databases, Data Entry, Navigation, Table Manipulation, Forms, Modifying Records, Queries, Filters, Reports, and more.
"[The instructor) was absolutely fabulous! She was so dynamic! She has been the best instructor I have had so far...Great for setting up databases.." -- Jean E. from San Diego, CA
"I have to say that I have been in many classes like this but this is the first time that I wasn't bored with the class. [The instructor) is a great teacher, fun to work with and very informative. She puts things in real world perspective. I would take her classes again!." -- Candace J. from Palmdale, CA
"I would definitely recommend this course to anyone else who wants to learn Access. The cost is a SMALL price to pay for the knowledge that you receive. [The instructor) knew alot about what she was teaching. Great job!." -- Corey M. from San Diego, CA
"I would recommend this course to everyone interested in learning about creating a database. [The instructor) is fascinating and takes the student very slowly into the concepts of Access, making it fun and enjoyable. She uses group participation for Q/A which helps emphasize concepts just learned. She is very approachable and makes the class very interesting." -- Lissette Mc I. from San Diego, CA
"The speaker's presentation was very good. He (Greg Capps) kept you interested and gave many shortcut tips that I will use in the future. This is a good course to take if you have never had any experience in Access.." -- Shelley S. from San Diego, CA
Introduction
Getting Started
What is Access, starting Access, the Access application window
Working with Access menus, basic Access terminology
Examining Access objects
Resetting the database folder, displaying help information
Exiting from Access
Setting up a new database
Designing and creating a new database, creating a new table
Entering records in datasheet view
Printing the datasheet of a table
Navigating through records in datasheet view
Closing a table/closing a database
Creating a form/modifying and manipulating data
Reopening a database/reopening a table
Creating a form
Navigating through records in form view/closing a form
Reopening a form
Switching between form view and datasheet view
Entering records in form view
Editing records in datasheet view and form view
Using the find feature
Deleting records in datasheet view and form view
Modifying the datasheet view of a table
Sorting the records in a table
Displaying selected records
Creating and applying a filter
Creating and running a query, modifying a query
Including a numeric condition in a query
Including a calculated field in a query
Creating a report
Creating a simple tabular report
Creating a grouped tabular report, modifying a report
Additional Access features
Using the spelling checker
Copying, renaming and deleting database objects
Importing spreadsheet data into an Access table
Final case study