Description

Gatlin International offers Microsoft Access training for students and professionals seeking to advance their Access skills in order to advance their careers and increase their earning potential. Our online Microsoft Access training allows participants to advance at their own pace as their schedules permit. Our anytime, anywere approach to Microsoft Access training is also extremely affordable due to the low overhead costs associated with Web-based instruction. The Microsoft Access training program from Gatlin International is a comprehensive, performance-based certification prep program designed to improve your business computer skills using Microsoft Access 2007 software. Our Microsoft Access training program is an interactive online course that will prepare you for the Microsoft Certification Exam 77-605. Students enrolled in our Microsoft Access 2007 training will not only gain basic knowledge of the software, but will also learn about information linking, how to automate data entry, and create a Search Form using a Combo Box to filter the data. The Microsoft Access 2007 training course has continuous assessment for goal-based learning. The course is comprised of three modules with multiple lessons in each. Students will be required to achieve a score of 70% correct in order to continue on to the following module. The MS Access 2007 training course also includes a final project that must be completed and submitted to the instructor in order to complete the course. Participants will need to have Microsoft Access 2007 installed on their computer prior to taking the Microsoft Access 2007 training course.

Course Objectives

By completing the Microsoft Access 2007 course, students will:
• Know how to use and design tables, forms, and queries.
• Create Queries to find and select records by criteria, and write, test, and update those queries.
• Understand how to create forms with subforms to represent one-to-many relationships.
• Learn to use criteria, parameters, concatenation, and operators in Query designs: calculate with DateDif(),Left(), and IIF(), improve report designs with Sorting and Grouping.
• Know how to link information and automate data entry.
• Create a Search Form that uses a Combo Box to filter the records.
• Know how to use Microsoft Access and Word together in a Mail Merge, as well as publish an Access report to Word, and optimize a database for multiple users.

There's never been a more convenient way to get the Microsoft Access 2007 training you need to achieve your goals and our open enrollment policy makes getting started easy so why not get started today!

Outline

The following outline highlights the major topics covered in our Microsoft Access 2007 training.

I. Beginning Guide to Microsoft Access 2007
a. Microsoft Access Database Tables
b. Microsoft Access Database Forms
c. Microsoft Access Database Queries
d. Database Maintenance
e. Microsoft Access Database Reports
f. Databases Come and Databases Go

II. Intermediate Guide to Microsoft Access 2007
a. Better Form Design
b. Form Controls and Switchboards
c. Modifying Form Properties
d. Software Testing
e. Sophisticated Queries
f. The Quest

III. Advanced Guide to Microsoft Access 2007
a. Create a Search Form
b. Synchronized Forms and Controls
c. Office Automation
d. Linked Tables
e. Links to the Internet
f. What a Long, Strange Trip It's Been

Demo

Click here to view a demo of the course.

Additional Info

Languages

English

Course Length

35.00 hours

Duration of Access

3 months

Instructor

Elizabeth Ann Nofs
Elizabeth Ann Nofs is co-founder and the Creative Director for Comma Project, LLC. Her research on how men and women approach computer learning provided the foundation for the Comma Method of training, as well as The Computer Mama Show, a pilot produced with WFUM/TV28 (PBS), Flint, Michigan.

Elizabeth is the designer and developer of the Complete Computer Guide series. The teaching methodology incorporated into the Guide is a breakthrough in producing gender balanced training with outstanding student completion, retention, and mastery rates.

She is the author of 38 computer certification Guides including: The Complete Guide to Microsoft Office 2007 (2007), The Complete Computer Guide (2005), The Comma Method of Computer Training (2003), and The Comma Teachers Edition (2003).

Elizabeth received her B.A. degree in Biology from the University of Michigan., Ann Arbor. She is a Microsoft Certified Professional.

Clair E. Dickson, Student Services
Clair earned her BS in Secondary English at Eastern Michigan University in Ypsilanti, Michigan and is certified to teach English and History at the high school level. She also met all of the standards for teaching with technology as outlined by COATT (Consortium for Outstanding Achievement in Teaching with Technology.) Clair is considered "highly qualified" to teach computer courses, including Microsoft Office® 2003 and 2007, Windows XP® and Windows Vista®.

Clair Dickson is currently working on a Master's Degree in Educational Media and Technology through Eastern Michigan University's online distance learning program. The program explores ways to infuse technology into the learning experience so that learning is interactive.

Prerequisites/Audience

Students enrolling in our Microsoft Access training should possess a basic understanding of computer skills, Internet connection, and emailing capabilities are required.

This course is intended for students who want to learn how to effectively use Microsoft Access 2007.

Requirements/Materials Included

The Microsoft Access 2007 training cannot be taken on a Mac computer. Technical requirements include but are not limited to having Internet access with a 56K modem, but it is highly recommended that you have DSL or High Speed Cable Internet Access; 64 MB system RAM; 200 MB free hard disk space memory or sufficient storage; reliable email account access, CD-ROM/DVD capabilities, and a reliable Internet provider.

You will need the following products already be loaded on the computer in order to take this course: Windows Vista Business edition or Windows XP, Microsoft Access 2007, Microsoft Word 2007, Adobe Acrobat Reader (free version), and Flash Player.

GES will provide the following materials:
• Beginning Guide to Microsoft® Access 2007
• Intermediate Guide to Microsoft® Access 2007
• Advanced Guide to Microsoft® Access 2007