Microsoft Access is the powerful relational database program within Microsoft Office. Users can easily create tables, queries, forms and reports, and connect them together with macros. Advanced users can use VBA to write rich solutions with advanced data manipulation and user control.
Microsoft Access 2013, the newest version, has several additions features and introduces apps. An Access web app is a new type of database that you build in Access, then use and share with others as a SharePoint app in a web browser. To build an app, you just select the type of data you want to track. Access creates the database structure.
ONLC offers training classes for Access version 2013, 2010, 2007 and 2003 and at skill levels for those new to Access on up through Access Programming with Visual Basic for Applications (VBA).
Attend the
hands-on, instructor-led training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same
live classes from your home/office PC via our Remote
Classroom Instruction (RCI) technology.
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.
Certification for this version is no longer available. MOS 2003 certification exams were retired December 31, 2012.
Microsoft
Office Specialist (MOS) Certification: Access 2013 (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-424: Microsoft Access 2013
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. Learn more about Exam 77-424.
Courses
(click
course title for outline & dates)
Microsoft Access 2013 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 2013 Advanced (2
Days)
In this course, you will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft Office Access 2013 with other applications. View
outline & dates.
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 Migrations for Corporations ONLC is a leader in migration training.
We have been awarded major contracts to migrate thousands of users from earlier versions of Office to the latest version of Microsoft Office. 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 travel expenses. See info about Office Migration training.
MCAS and Office 2003 Certification
The Microsoft Office Specialist (MOS) certification extends to all versions of Microsoft Office, including those which were previously the Microsoft Certified Application Specialist (MCAS) certifications.
Please note that all MOS 2003 certification exams were retired as of December 31, 2012.
ONLC Training Centers has grown to be the largest IT training company in the US with over 300 classroom training locations. Click the links below to learn why so many people are selecting us as their training provider.
•U.S. Locations
Over 300 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
Fresno, CA
Glendale / Burbank, CA
Irvine, CA
Los Angeles, CA
Manhattan Beach, CA
Orange, CA
Petaluma, CA
Pleasanton, CA
Redwood City, CA
Riverside, CA
Sacramento, CA
San Diego, CA
San Francisco, CA
San Jose, CA
Walnut Creek, CA
Woodland Hills, CA
Colorado
Boulder, CO
Centennial, CO
Colorado Springs, CO
Denver, CO
Grand Junction, CO
Loveland, CO
Massachusetts
Andover, MA
Boston, MA
Braintree, MA
Danvers, MA
Mansfield, MA
Norwell, MA
Springfield, MA
Taunton, MA
Waltham, MA
Westborough, MA
Woburn, MA
Worcester, MA
Michigan
Ann Arbor, MI
Detroit, MI
Grand Rapids, MI
Kalamazoo / Portage, MI
Lansing, MI
Novi, MI
Traverse City, 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
Henrietta, 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
Tualatin, 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
Columbia, SC
Greenville, SC
Mt. Pleasant / Charleston, SC
South Dakota
Sioux Falls, SD
Tennessee
Chattanooga, TN
Franklin, TN
Johnson City, TN
Knoxville, TN
Memphis, TN
Nashville, TN
Texas
Amarillo, TX
Austin, TX
Bryan / College Station, TX
Corpus Christi, TX
Dallas, TX
El Paso, TX
Fort Worth, TX
Grapevine, TX
Houston, TX
Irving / Las Colinas, TX
Katy, TX
Keller, 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 300 classroom locations in these cities...
Akron, OH
Albany, NY
Albuquerque, NM
Alexandria, VA
Allentown, PA
Alpharetta, GA
Amarillo, TX
Andover, MA
Ann Arbor, MI
Annapolis, MD
Arlington, VA
Atlanta, GA
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
Birmingham, AL
Bloomington, MN
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
Carson City, NV
Casper, WY
Cedar Rapids, IA
Champlin, MN
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
Danvers, MA
Dayton, OH
Des Moines, IA
District of Columbia
Dublin, OH
Duluth, GA
East Granby, CT
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
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, CO
Grand Forks, ND
Grand Rapids, MI
Grapevine, TX
Great Falls, MT
Green Bay, WI
Greenbelt, MD
Greensboro, NC
Greenville, SC
Gurnee, IL
Harrisburg, PA
Harrison, NY
Hartford, CT
Henderson, NV
Henrietta, NY
Hickory, NC
Houston, TX
Huntsville, AL
Independence, OH
Indianapolis, IN
Irvine, CA
Irving / Las Colinas, TX
Iselin, NJ
Jackson, MS
Jacksonville, FL
Jersey City, NJ
Johnson City, TN
Joliet, IL
Kalamazoo / Portage, MI
Kansas City, MO
Katy, TX
Keller, TX
Kennesaw, GA
Kennewick, WA
Kissimmee, FL
Knoxville, TN
Lafayette, LA
Lancaster, PA
Land O' Lakes, FL
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
Manhattan Beach, CA
Mansfield, MA
Martinez, GA
Martinsburg, WV
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
Morrisville, NC
Mount Laurel, NJ
Mount Pleasant, SC
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
Orange Park, FL
Orlando, FL
Overland Park, KS
Owings Mills, MD
Palm Beach, FL
Paramus, NJ
Petaluma, CA
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
Round Rock, TX
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
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
Traverse City, MI
Troy, MI
Tualatin, OR
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 Chester, OH
Westborough, MA
Wexford, PA
Wichita, KS
Wichita Falls, TX
Wilkes-Barre, PA
Williston, ND
Wilmington, DE
Wilmington, NC
Woburn, MA
Woodland Hill, CA
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