Description

Master Microsoft Access 2007 with the help of this comprehensive online training. The program covers basic to advanced topics, including database maintenance, form design, creating links, and more.

The Microsoft Certified Application Specialist program is the only comprehensive, performance-based certification program approved by Microsoft to validate business computer skills using Microsoft Office 2007: Access, Excel, Word, Power Point, and Outlook.

The Microsoft Access 2007 certification training program is part of the Microsoft Business Certification program: Microsoft Certified Application Specialist (MCAS). MCAS certification is the globally recognized standard for validating expertise with the Microsoft Office 2007 suite.

Certification can help you differentiate yourself in today's competitive job market, broaden your employment opportunities, and garner greater earning potential. Certification can also help you advance in your current job. Mastering more skills increases your effectiveness and efficiency. Research indicates that Office-certified professionals are more confident and productive with Microsoft Office programs.

Many employers consider certification in determining who to hire. Certification can be the difference in whether or not you get a job, or get a better job. Students who complete Microsoft Office Specialistor MCAS certification training earn more (about 12%) than employees who are not certified. In addition, 82% of the students who get certified report getting a bonus upon receiving their certification.

Microsoft Approved Courseware

When you use Approved Courseware for the Microsoft Certified Application Specialist and Microsoft Office Specialist programs to help prepare for Microsoft Office certification exams, you know you are using the very best study materials available.

In order for courseware to receive the "Approved Courseware" distinction, it must go through a rigorous review to ensure it meets the skill standards set forth by Microsoft. Use Microsoft Business Certification Approved Courseware for the Microsoft Certified Application Specialist and Microsoft Office Specialist programs to help prepare for your next Microsoft Office certification exam.

This is the first online Microsoft Access 2007 certification training course approved by Microsoft.

By completing the Microsoft Access 2007 program, you'll:

• 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
• 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
• Be able to optimize a database for multiple users

If you wish to prepare for the Microsoft Certification Exam 77-605: Using Microsoft Office Access 2007, you'll find beginning lessons that demonstrate these required MCAS topics here.

Outline

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

1. Beginning Guide to Microsoft Access 2007
   1. Microsoft Access Database Tables
   2. Microsoft Access Database Forms
   3. Microsoft Access Database Queries
   4. Database Maintenance
   5. Microsoft Access Database Reports
2. Intermediate Guide to Microsoft Access 2007
   1. Better Form Design
   2. Form Controls and Switchboards
   3. Modifying Form Properties
   4. Software Testing
   5. Sophisticated Queries
3. Advanced Guide to Microsoft Access 2007
   1. Create a Search Form
   2. Synchronized Forms and Controls
   3. Office Automation
   4. Linked Tables
   5. Links to the Internet

Demo

Additional Info

Languages

English

Course Length

35.00 hours

Duration of Access

All of our programs are self-paced and open-enrollment. You can start and finish the program at your own pace. When you register for this program, you’re given 90 days (three months) to complete it. If you need more time, three-month extensions are available.

Instructor

Clair Dickinson earned her B.S. 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 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.

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 series is a breakthrough in producing gender-balanced training with outstanding student completion, retention, and mastery rates.

Elizabeth has been a network administrator for many businesses as well as a Microsoft course instructor. Elizabeth has taught several thousand men and women from government, manufacturing, small business, and education. She has developed Microsoft Office solutions and databases since 1993.

She's the author of several books, including: The Computer Mama Guide to Computers (2001), The Comma Method of Computer Training (2003), The Comma Teachers Edition (2003), and The Complete Computer Guide (2005).

Elizabeth received her B.A. degree in Biology from the University of Michigan, Ann Arbor.

Prerequisites/Audience

Students who enroll in the Microsoft Access 2007 program should have the equivalent of six months of hands-on computer experience. You should be able to manage files, including saving, updating, and backing up files.

This program is for you if you're an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Access skills immediately. This program is also suitable for you if you're looking to learn about this software and expand your job possibilities.

Requirements/Materials Included

You'll need the following Microsoft products already installed on your computer in order to take this program: Windows XP or Windows Vista and Microsoft Word and Access 2007.

Hardware requirements:

• IBM-compatible (PC) computer
• Processor: 1 GHz 32-bit (x86) or 64-bit (x64)
• RAM: 1 GB of system memory
• Hard Drive: 40 GB with at least 15 GB of available space
• Video: support for DirectX 9 graphics with WDDM Driver
• 128 MB of graphics memory
• Pixel Shader 2.0 in hardware
• 32 bits per pixel
• DVD-ROM drive
• Audio output

Adobe Flash Player and Adobe Acrobat Reader are required for this course.
Click here to download the Acrobat Reader.
Click here to download the Flash Player.

Internet Connectivity
You'll need Internet access. If your Internet service provider uses only dial-up, a minimum of 56K connection rate is recommended; however, high-speed access (cable or DSL) is preferred.

This program cannot be taken from a Mac computer.

Books included with this program:

• The Beginning Guide to Microsoft Access 2007
• The Intermediate Guide to Microsoft Access 2007
• The Advanced Guide to Microsoft Access 2007

This program includes: Microsoft Office Access 2007 CourseNotes from Course Technology.