See how a Course Works: Intro to Online Learning
Description
Microsoft Access Training from Gatlin International
This course accurately and creatively provides an introductory audience with an understanding of the needed information to pass the Microsoft Office Specialist Certification Series. Students learn the commands in practical, real world applications. Perfect for office workers, professionals, and students who want to know both how and when to best apply Microsoft Access.
Certification proves a certain level of advanced competency with the programs in question. Employers don’t have to wonder if the skills stated on the resume are honest and without exaggeration. This can lead to further employment opportunities and increased pay.
Microsoft Approved Course Materials
When you use Approved Courseware for the Microsoft Office Specialist programs, such as Microsoft Access 2007, you know you’re using high quality study materials. 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.
This Microsoft Access 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.
Microsoft Access 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.
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 course is also an exam study guide for the following certification tests:
Exam70-605: Using Microsoft Office Access 2007
By completing the Microsoft Access 2007 program, you'll:
- Structure and Maintain Databases
- Enter and Modify Data
- Create and Modify Queries
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.
Enroll in our Microsoft Access training today for a brighter tomorrow!
Outline
Microsoft Access Training Outline
The following outline highlights the major topics covered in our Microsoft Access training.
- Beginning Access
- Getting Started: Welcome
- Now Playing: Data Entry and Data Tables
- Quiet on the Set: Form Design
- The Plot Thickens: Creating and Using Queries
- Intermission: Compact and Repair Databases
- Daily Reporter: Viewing and Sorting Record Sources
- Databases Come and Databases Go
- Intermediate Access
- Editing the Screen Play: Tables and Subforms
- Meet the Stars: Create a Switchboard
- Designing for Users: manage databases and database properties
- Dress Rehearsal: Testing the Database
- Box Office Receipts: Modify form controls
- The Quest: Databases in gaming
- Advanced Access
- Independent Investigation: Create a Search Form
- Search and Research: Filter queries and use sub-queries
- The Producers: Create and modify reports and Mail Merges
- Performance Network: optimize your database and improve performance
- Rave Reviews: archive, import and export data
Additional Info
- Languages
- English
- Course Length
- 120.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 6 months to complete it. If you need more time, three-month extensions are available.
- Instructor
Clair Dickson has a B.S. in Secondary English Education from Eastern Michigan University. She currently works as an online course facilitator in a lab setting, working with students taking courses towards their high school diploma. She also completed her Graduate Certificate in Educational Media and Technology through Eastern Michigan University Online, doing all of the work online.
She earned the Microsoft Office 2007 Master certification by passing the tests for Word, Excel, PowerPoint, and Outlook 2007. In addition, she has Microsoft Word 2003 Expert level certification. She has used every version of Office since 1995 and still enjoys finding new ways to use the software.
In her spare time, Clair writes short crime stories and chases after her young son.
Elizabeth Ann Nofs is the designer and developer of the Computer Mama guides. 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.
She’s the author of 44 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) and the Complete Computer Guides for Microsoft Office 2007 and Office 2010 (MOS) certification training
Elizabeth received her B.A. degree in Biology from the University of Michigan, Ann Arbor.
- Prerequisites/Audience
The Complete Guide to Microsoft Access 2007 is for students to improve their level and breadth of knowledge with Microsoft Access functions in preparation for taking the Microsoft Certification Exam. The course includes both recall and authentic assessments to measure student understanding at an increasingly advanced level. Students will be working hands-on with the commands and completing sample projects to reinforce learning. This course does not rely on abstract learning, but on the program in context.
The primary instruction is related to business applications of Access, as Microsoft Access is used in most workplaces. Nearly every business has a use for Microsoft Office programs, from inter-office memos composed on Microsoft Word to Sales presentations created with Microsoft PowerPoint to Budget spreadsheets compiled in Microsoft Excel. A secondary target group is teachers, who can use Microsoft Office for both teacher preparation and record-keeping as well as in student assignments. Lastly, home users may find many uses for Microsoft Office, similar to those used in the workplace. Microsoft Office is a ubiquitous product with great possibilities. This course aims to expose users to those possibilities.
Students for the certification exams should have the equivalent of six months of hands-on computer experience before taking the exam. These exam candidates should be proficient at file management. In addition, students should be able to readily identify and use the commands for at least 80% of the exam objectives in preparation for taking the timed exam. Amongst the skills necessary, students should be especially effective at entering information and analyzing data. Successful students will have mastered how to create and edit formulas, audit equations, insert and format visual data presentations and present information in charts and tables.
- Requirements/Materials Included
Students who enroll in the Complete Guide to Microsoft Access 2007 should have basic computer skills, including how to turn on the computer, how to use an Internet browser, and how to select commands from a menu or toolbar. Students should know how to save files and send attachments by email as well.
In order to take our online programs, you must have access to a computer and the Internet (high-speed Internet access is recommended). You can access the program contents from any Web-enabled computer.
You will need the following Microsoft products already installed on your computer in order to take this program: Word, Excel, PowerPoint and Outlook 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
- 128 MB of graphics memory
- DVD-ROM drive
- Audio output
- Adobe Acrobat Reader
- Flash Player
- Certification
This course is an exam study guide for the following certification test:
