Microsoft Office Specialist (MOS) certification for Access helps validate your proficiency in using Microsoft Office Access. Candidates must pass one certification exam in order to earn this MOS certification.
Scroll down to view Access 2010, 2007 and 2003 certification requirements and the ONLC classes that will help you prepare for Microsoft Office Specialist (MOS) Access certification.
Note: The Microsoft Office Specialist (MOS) certification now extends to all versions of Microsoft Office, which were previously known as Microsoft Certified Application Specialist (MCAS) certifications.
(Previously earned MCAS certifications are still valid. Contact Microsoft to have your transcript and certificate updated with the Microsoft Office Specialist title.)
Attend the
hands-on, instructor-led training classes at ONLC's more than 250 locations. Not near one of our locations? Attend these same
live classes from your home/office PC via our Remote
Classroom Instruction (RCI) technology.
CERTIFICATIONS
Click on the certification title
within the table or scroll down to view
the associated courses and required exams.
Microsoft
Office Specialist (MOS) Certification: Access 2010 (First series certification)
To
achieve this certification you must pass the designated exam. You can help prepare
for the exam by attending the courses listed.
Certification
Exam
77-885: Microsoft Access 2010
For this exam you need to be able to create and maintain a basic Access database, create, modify, and extend functionality of basic database objects, including tables, queries, forms, and reports. You should also be able to construct and modify basic relationships among database entities and be able to instruct others in basic Access functionality and usage. View skills measured in Microsoft Exam 77-885.
Courses
(click
course title for outline & dates)
Microsoft Access 2010 Introduction (2
Days)
During this two-day course you will create and modify new databases and their various objects. This Level 1 course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as maintaining databases and using programming techniques that enhance Access applications. View
outline & dates
Microsoft Access 2010 Advanced (2
Days)
In this course, you will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft Office Access 2010 with other applications. View
outline & dates.
Microsoft
Office Specialist (MOS) for Access 2007
To
achieve this certification you must pass the designated exam. You can help prepare
for the exam by attending the courses listed.
Certification
Exam
77-605: MOS: Using Microsoft Office Access 2007
Candidates for this exam should have the equivalent of six months to one year of hands-on experience using Microsoft Office Access 2007 and might have experience using previous versions of Microsoft Access. They are especially effective and efficient at structuring databases, creating and formatting database elements, entering and modifying data, creating and modifying queries, presenting and sharing data, and managing and maintaining the overall database. View skills measured in Microsoft Exam 77-605.
Preparation Courses
(click course title for outline &
dates)
Microsoft Access 2007 Introduction (2
Days)
In this course you will learn the basic operations of the Microsoft Access database application to perform day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to business processes. Thiscourse is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. View
outline & dates
Microsoft Access 2007 Advanced (2
Days)
In this course, you will learn how to maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft Office Access 2007 with other applications. View
outline & dates
Microsoft
Office Specialist (MOS) Certification: Access 2003 (First series certification)
To
achieve this certification you must pass the designated exam. You can help prepare
for the exam by attending the courses listed.
Certification
Exam
Microsoft Office Specialist: Access 2003
For this exam you should be able to navigate Microsoft Office Access 2003 software at the feature and functionality level. You should be familiar with and know how to use at least 80% of the features and capabilities of Microsoft Office Access 2003. View skills measured in Microsoft Excel 2003 Exam.
Courses
(click
course title for outline & dates)
Microsoft Access 2003 Introduction (2
Days)
During this one-day course you will create and edit basic Microsoft Office Access 2003 databases including working with queries, forms, tables and reports. View
outline & dates
Microsoft Access 2003 Advanced (2
Days)
In this course, apply advanced techniques including validating data, enhance queries and forms, plus create advanced reports, create macros, use multi-table forms, PivotTable and PivotCharts. View
outline & dates
Click the title of the classes marked with the green flag () to see specific locations and dates of "Ready to Run" classes. Click the title of the classes marked with the yellow flag () to see specific locations and dates of Early Notice classes.
Microsoft Office Migrations for Corporations ONLC is a leader in migration training.
We have been awarded major contracts to migrate thousands of users to Office
2007 and Microsoft Office 2010. Organizations can select from our innovative training options like product
demos & overviews, single-topic workshops, hands-on sessions, and more. These are private
sessions and can be customized to specifically address the needs of your organization.
Companies
with multiple branch locations that are looking to do a software migration especially appreciate our Remote
Classroom Instruction (RCI™) technology. It allows us to deliver live, instructor-led
training to each of their locations simultaneously, thereby ensuring consistent training for all
employees. It also lets the company avoid incurring travel expenses. See info about Office Migration training
Save
on Microsoft Office Training
Our 5/4 Office saver lets you attend
5 days of Office training for the price of 4. Just $1195 gives you your choice
of Excel, Word, PowerPoint, Visio and/or Outlook training. Find
out more
Questions? To
learn more about ONLC's classes or in the event of questions contact our Education
Advisors at:
1.800.288.8221
ONLC TRAINING
CENTERS
800-288-8221 (USA) / 302-225-4470 (Other)
www.onlc.com
ONLC Training Centers has grown to be the largest IT training company in the US with over 250 classroom training locations. Click the links below to learn why so many people are selecting us as their training provider.
•U.S. Locations
Over 250 sites across North America...
Alabama
Birmingham, AL
Huntsville, AL
Mobile, AL
Montgomery, AL
Arizona
Phoenix, AZ
Scottsdale, AZ
Tucson, AZ
Arkansas
Bentonville, AR
Little Rock, AR
California
Bakersfield, CA
El Segundo, CA
Elk Grove, CA
Fresno, CA
Glendale, CA
Irvine, CA
Los Angeles, CA
Orange, CA
Pleasanton, CA
Redwood City, CA
Riverside, CA
Sacramento, CA
San Diego, CA
San Francisco, CA
San Jose, CA
Walnut Creek, CA
Colorado
Boulder, CO
Centennial, CO
Colorado Springs, CO
Denver, CO
Grand Junction, CO
Loveland, CO
Massachusetts
Andover, MA
Beverly, MA
Boston, MA
Braintree, MA
Mansfield, MA
Norewell, MA
Springfield, MA
Taunton, MA
Waltham, MA
Westborough, MA
Woburn, MA
Worcester, MA
Michigan
Detroit, MI
Grand Rapids, MI
Kalamazoo / Portage, MI
Lansing, MI
Novi, MI
Troy, MI
New Jersey
Bridgewater, NJ
Iselin, NJ
Jersey City, NJ
Morristown, NJ
Mt. Laurel, NJ
Paramus, NJ
Princeton, NJ
Red Bank, NJ
New Mexico
Albuquerque, NM
New York
Albany, NY
Bohemia, NY
Buffalo, NY
Harrison / Rye, NY
Manhattan, NY
Mt. Kisco, NY
New York City, NY
Poughkeepsie, NY
Rochester, NY
Syracuse, NY
Uniondale, NY
Oregon
Beaverton, OR
Bend, OR
Eugene, OR
Medford, OR
Portland, OR
Roseburg, OR
Salem, OR
Pennsylvania
Allentown, PA
Erie, PA
Exton, PA
Harrisburg, PA
Lancaster, PA
Malvern, PA
Mechanicsburg, PA
Monroeville, PA
Morgantown, PA
Philadelphia, PA
Pittsburgh, PA
State College, PA
Wayne, PA
Wexford, PA
Wilkes-Barre, PA
York, PA
Rhode Island
Warwick / Providence, RI
South Carolina
Charleston, SC
Columbia, SC
Greenville, SC
South Dakota
Sioux Falls, SD
Tennessee
Chattanooga, TN
Franklin, TN
Johnson City, TN
Knoxville, TN
Memphis, TN
Nashville, TN
Texas
Abilene, TX
Addison, TX
Amarillo, TX
Austin, TX
Bryan / College Station, TX
Corpus Christi, TX
Dallas, TX
El Paso, TX
Fort Worth, TX
Houston, TX
Irving, TX
League City, TX
Midland, TX
Plano / Frisco, TX
Round Rock, TX
San Antonio, TX
Spring / The Woodlands, TX
Sugar Land, TX
Trophy Club, TX
Waco, TX
Wichita Falls, TX
Utah
Provo, UT
Salt Lake City, UT
Vermont
Burlington/Shelburne, VT
Virginia
Alexandria, VA
Arlington, VA
Charlottesville, VA
Fairfax, VA
Fredericksburg, VA
Glen Allen, VA
Lynchburg, VA
Manassas, VA
McLean, VA
Newport News, VA
Norfolk, VA
Reston, VA
Richmond, VA
Roanoke, VA
Virginia Beach, VA
Washington
Bellevue, WA
Bellingham, WA
Bothell / Redmond, WA
Kennewick / Pasco, WA
Mukilteo / Everett, WA
Olympia / Lacey, WA
Puyallup, WA
Seattle, WA
Tacoma / Federal Way, WA
Spokane, WA
West Virginia
Martinsburg, WV
Wisconsin
Brookfield, WI
Glendale, WI
Green Bay, WI
Madison, WI
Milwaukee, WI
Wyoming
Casper, WY
Cheyenne, WY
•U.S. Locations by City
Attend hands on, instructor-led computer classes at our more than 250 classroom locations in these cities...
Abilene, TX
Addison, TX
Akron, OH
Albany, NY
Albuquerque, NM
Alexandria, LA
Alexandria, VA
Allentown, PA
Alpharetta, GA
Amarillo, TX
Andover, MA
Annapolis, MD
Arlington, VA
Atlanta, GA
Auburn, AL
Austin, TX
Bakersfield, CA
Baltimore, MD
Baton Rouge, LA
Beachwood, OH
Beaverton, OR
Bend, OR
Bedford, NH
Bellevue, WA
Bellingham, WA
Bentonville, AR
Bethesda, MD
Bettendorf, IA
Beverly, MA
Birmingham, AL
Boca Raton, FL
Bohemia, NY
Boise, ID
Boston, MA
Boulder, CO
Bradenton / Sarasota, FL
Braintree, MA
Bridgewater, NJ
Brookfield, WI
Bryan / College Station, TX
Buckhead, GA
Buffalo, NY
Canton, OH
Casper, WY
Cedar Rapids, IA
Champlin, MN
Charleston, SC
Charlotte, NC
Chattanooga, TN
Centennial, CO
Cheyenne, WY
Chicago, IL
Cincinnati, OH
Cleveland, OH
Columbia, MD
Columbia, MO
Columbia, SC
Columbus, GA
Columbus, OH
Corpus Christi, TX
Dallas, TX
Danbury, CT
Dayton, OH
Deerfield, IL
Des Moines, IA
District of Columbia
Dublin, OH
Duluth, GA
Dunwoody, GA
Edina, MN
El Paso, TX
El Segundo, CA
Elk Grove, CA
Erie, PA
Erlanger, KY
Eugene, OR
Evansville, IN
Exton, PA
Fairfax, VA
Fayetteville, NC
Folsom, CA
Fort Worth, TX
Fort Lauderdale, FL
Fort Myers, FL
Fort Wayne, IN
Franklin, TN
Frederick, MD
Fredericksburg, VA
Fresno, CA
Frisco, TX
Glendale, CA
Glendale, WI
Grand Junction
Grand Forks, ND
Grand Rapids, MI
Great Falls, MT
Green Bay, WI
Greenbelt, MD
Greensboro, NC
Greenville, SC
Gurnee, IL
Harrisburg, PA
Harrison, NY
Hartford, CT
Henderson, NV
Hickory, NC
Houston, TX
Huntsville, AL
Independence, OH
Indianapolis, IN
Irvine, CA
Irving, TX
Iselin, NJ
Jackson, MS
Jacksonville, FL
Jersey City, NJ
Johnson City, TN
Joliet, IL
Kalamazoo / Portage, MI
Kansas City, MO
Kearney, MO
Kennesaw, GA
Kennewick, WA
Kissimmee, FL
Knoxville, TN
Lafayette, LA
Lancaster, PA
Las Vegas, NV
League City, TX
Lee's Summit, MO
Lenexa, KS
Lexington, KY
Lincoln, NE
Little Rock, AR
Londonderry, NH
Los Angeles, CA
Louisville, KY
Loveland, CO
Lynchburg, VA
Macon, GA
Madison, WI
Manchester, NH
Mandeville, LA
Manhattan, NY
Mansfield, MA
Martinez, GA
Martinsburg, WV
McAllen, TX
McLean, VA
Medford, OR
Memphis, TN
Miami, FL
Midland, TX
Milford, CT
Milwaukee, WI
Minneapolis, MN
Miramar Beach, FL
Mobile, AL
Montgomery, AL
Monroeville, PA
Morristown, NJ
Mount Laurel, NJ
Mukilteo, WA
Naperville, IL
Naples, FL
Nashua, NH
Nashville, TN
New Orleans, LA
New York City, NY
Newington, CT
Newport News, VA
Norfolk, VA
Norwell, MA
Novi, MI
Oakbrook Terrace, IL
Oklahoma City, OK
Olympia / Lacey, WA
Omaha, NE
Orange, CA
Orlando, FL
Overland Park, KS
Owings Mills, MD
Palm Beach, FL
Paramus, NJ
Peoria, IL
Philadelphia, PA
Phoenix, AZ
Pittsburgh, PA
Plano, TX
Plantation, FL
Pleasanton, CA
Portland, ME
Portland, OR
Poughkeepsie, NY
Princeton, NJ
Provo, UT
Puyallup, WA
Quad Cities, IA IL
Raleigh, NC
Red Bank, NJ
Redmond, WA
Redwood City, CA
Reno, NV
Reston, VA
Richmond, VA
Riverside, CA
Roanoke, VA
Rochester, NH
Rochester, MN
Rochester, NY
Rockford, IL
Rockville, MD
Rolling Hills, CA
Roseburg, OR
Rosemont, IL
Round Rock, TX
Ruston /Grambling, LA
Rye, NY
Sacramento, CA
Salem, OR
Salt Lake City, UT
San Antonio, TX
San Diego, CA
San Francisco, CA
San Jose, CA
Sarasota / Bradenton, FL
Savannah, GA
Schaumburg, IL
Scottsdale, AZ
Seattle, WA
Shelburne, VT
Shelton, CT
Shreveport, LA
Sioux Falls, SD
South Bend, IN
South Burlington, VT
St. Louis, MO
St. Paul, MN
St. Petersburg, FL
Spokane, WA
Spring / The Woodlands, TX
Springfield, MA
Springfield, MO
Stamford, CT
State College, PA
Sugar Land, TX
Syracuse, NY
Tacoma / Federal Way, WA
Tallahassee, FL
Tampa, FL
Taunton, MA
Toledo, OH
Troy, MI
Tucson, AZ
Tulsa, OK
Uniondale, NY
Virginia Beach, VA
Wallingford, CT
Walnut Creek, CA
Waltham, MA
Warrenville, IL
Warwick / Providence, RI
Washington, DC
Waterbury / Cheshire, CT
Wayne, PA
West Dundee
Westborough, MA
Wexford, PA
Wichita, KS
Wichita Falls, TX
Wilkes-Barre, PA
Williston, ND
Wilmington, DE
Wilmington, NC
Woburn, MA
Worcester, MA
Youngstown, OH
•Canada Locations
You can attend any ONLC class right from your PC via RCI™ including these areas in Canada...
Alberta
Calgary, AB
Edmonton, AB
Grande Prairie, AB
Lethbridge, AB
Lloydminster, AB
Medicine Hat, AB
Red Deer, AB
Wood Buffalo, AB
British Columbia
Abbotsford, BC
Burnaby, BC
Campbell River, BC
Chilliwack, BC
Clayoquot, BC
Coldstream, BC
Comox, BC
Courtenay, BC
Cranbrook, BC
Duncan, BC
East Kootenay, BC
Fort St. John, BC
Kamloops, BC
Kelowna, BC
Maple Ridge, BC
Nanaimo, BC
New Westminster
North Cowichan, BC
Okanagan, BC
Parksville, BC
Peace River, BC
Penticton, BC
Port Alberni, BC
Port Coquitlam
Prince George, BC
Qualicum Beach, BC
Richmond, BC
Saanich, BC
Strathcona, BC
Surrey, BC
Vancouver, BC
Vernon, BC
Victoria, BC
Manitoba
Brandon, MB
Winnipeg, MB
New Brunswick
Bathurst, NB
Beresford, NB
Dieppe, NB
Fredericton, NB
Miramichi, NB
Moncton, NB
North Esk, NB
Quispamsis, NB
Riverview, NB
Saint John, NB
Newfoundland & Labrador
Conception Bay, NL
Corner Brook, NL
Mount Pearl, NL
St. John's, NL
Ontario
Augusta, ON
Barrie, ON
Belleville, ON
Brampton, ON
Brant, ON
Brantford, ON
Brockville, ON
Burlington, ON
Cambridge, ON
Centre, ON
Chatham, ON
Clarington, ON
Cornwall, ON
Elizabethtown, ON
Ennismore, ON
Frontenac, ON
Georgian Bluffs, ON
Guelph, ON
Hamilton, ON
Innisfil, ON
Kawartha Lakes, ON
Kent, ON
Kingston, ON
Kingsville, ON
Kitchener, ON
Kitley, ON
Lakefield, ON
Lakeshore, ON
LaSalle, ON
Leamington, ON
London, ON
Laurentian Valley, ON
Midland, ON
Mississauga, ON
Niagara, ON
Niagara Falls, ON
Norfolk, ON
North Bay, ON
Orillia, ON
Oshawa, ON
Ottawa, ON
Owen Sound, ON
Pembroke, ON
Penetanguishene, ON
Peterborough, ON
Quinte, ON
Ramara, ON
Sarnia, ON
St. Catharines, ON
St. Clair, ON
Sault Ste. Marie, ON
Smith, ON
South Stormont, ON
Stratford, ON
Sudbury, ON
Tay, ON
Tecumseh, ON
Thunder Bay, ON
Timmins, ON
Toronto, ON
Vaughan, ON
Waterloo, ON
Welland, ON
Wellington, ON
Whitby, ON
Windsor, ON
Woodstock, ON
Prince Edward Island
Charlottetown, PE
Stratford, PE
Top of page
) to see specific locations and dates of "Ready to Run" classes. Click the title of the classes marked with the yellow flag (
) to see specific locations and dates of Early Notice classes.
