Microsoft Office


Access - Level 2 Course

by Certstaffix® Training


Attend Our Classes From Home - No Software Needed - Learn More...

Microsoft Access Training

Length: 2 day(s)      Public Class Price: $670/person (USD)      Group Class Price: Request Quote      Course Category: Microsoft Access


This ILT Series course provides students with additional skills and concepts needed to use Microsoft Access  productively and efficiently. They will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms, and reports, insert background images and charts; and create specialized objects such as lookup fields, subforms and subreports, navigation forms, and calculated fields. This course will help students prepare for the Microsoft Office Specialist exam. For comprehensive certification training, students should complete the Level 1, 2 and 3 courses for Access.

Access Versions That Can Attend: Access 2019, 365, 2016, & 2013 (Microsoft Windows PC)
Course Taught With: Access version 2013 (Microsoft Windows PC) Software and Courseware
Not Appropriate For: Macintosh versions of Access


This is an instructor-led course. It is taught by an instructor live online or at organizations for groups.
For team training, we can teach onsite at your office or private live online.

 Register ➥   May 25, 2022     
 Register ➥   June 29, 2022     


Group Onsite Training
At Your Organization

OR

Private Online Training
Live Online Instruction

Have a group of several students needing the same training? Then onsite or private online group training is a perfect option for you. We'll either come onsite to your office or deliver a private live online class so you don't have to travel. You'll be able to fully customize a course to your needs. Lastly, you can save per student versus our public classes.


  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be fully customized to your training needs
  • Course is scheduled based on dates you provide (Subject to instructor availability)

  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Related Certifications

MOS: Microsoft Access Expert Certification


Knowledge Pre-Requisites


Suggested Follow-Ons


Course Topics

Unit 1: Relational databases
Topic A: Database normalization
Topic B: Table relationships
Topic C: Referential integrity

Unit 2: Related tables
Topic A: Creating lookup fields
Topic B: Modifying lookup fields
Topic C: Subdatasheets

Unit 3: Complex queries
Topic A: Joining tables in queries
Topic B: Using calculated fields
Topic C: Summarizing and grouping values

Unit 4: Advanced form design
Topic A: Adding unbound controls
Topic B: Graphics
Topic C: Adding calculated values
Topic D: Adding combo boxes
Topic E: Advanced form types

Unit 5: Reports and printing
Topic A: Report formatting
Topic B: Calculated values and subreports
Topic C: Printing
Topic D: Label printing

Unit 6: Charts
Topic A: Charts in forms
Topic B: Charts in reports
Course Description: Print It | Download PDF | Email It

Microsoft Access Training Reviews by Certstaffix® Training

Certstaffix® Training collects detailed class reviews via a formal post-class evaluation in all our instructor-led courses. Below are a sample of abbreviated reviews from real students from our past classes. If you would like more reviews or ones with even further detail, please contact us and we would be happy to show you the high quality of our training services.


Certstaffix® Class Reviews

Student Average:
4.87 out of 5 from 102 students

5.00 out of 5

use examples relating to tasks to do with maintaining caseloads at work


- attended our Access - Level 1 class

5.00 out of 5

This was a good course. It is obvious that the instructor is well-versed on Access and led the class in a logical/structured manner. It was easy to follow and all questions were answered.


- attended our Access 2013/16/10: Basic class

4.94 out of 5

The instructor, Ali Green, was excellent. His hands- on approach was very helpful and matched my learning he end of the class I felt confident that I will be able to use the material I learned, which was all new to me.


- attended our Access 2013/16/10: Advanced class

4.90 out of 5

The instructor was very enjoyable. He had a great attitude and was knowledgeable for the content that was taught.


- attended our Access 2013/16/10: Advanced class

5.00 out of 5

The instructor JoLynn Rihn was fantastic. I was hoping she was going to be teaching the Access 2 and 3 level.


- attended our Access - Level 1 class

5.00 out of 5

The course progressed at a comfortable speed, with plenty of time for the Instructor to help those in need of technical support or with questions.


- attended our Access - Level 1 class

4.89 out of 5

Since I have been working with Access for 9 years, this basic course was mostly just a review. I did enjoy Bill's teaching style and I look forward to the more advanced courses with him.


- attended our Access - Level 1 class

4.74 out of 5

Should require two monitors. Instructor was excellent!


- attended our Access 2013/16/10: Basic class

5.00 out of 5

None, all good, thank you!


- attended our Access - Level 2 class

4.63 out of 5

no additional comments Instructor was excellent & knowledgeable & funny when he needed to be. He went above and beyond!!!


- attended our Access 2013/16/10: Intermediate class



Q: What Is Microsoft Access Used For, and How Can You Learn It?


A: Microsoft Access is a program designed to empower individuals with minimal coding training to develop apps and create databases using templates. These custom apps and databases are then used to enter, analyze, and report data. The ability to group, modify, and access data by relationships in databases and apps increases productivity and accuracy in record-keeping. Microsoft Access's intuitive nature allows for employees to take short tutorials and learn its basics, though more advanced proficiency can be earned through courses like those at Certstaffix Training.


More Information on What Microsoft Access Is Used For and How to Learn It



Microsoft Access Online Forums

Microsoft Access User Groups

Microsoft Access Blogs

Microsoft Access Courses By City:

AL - Birmingham       GA - Augusta       NC - Greensboro       RI - Providence      
AL - Huntsville       GA - Columbus       NC - Raleigh       SC - Greenville      
AL - Mobile       GA - Savannah       NC - Winston-Salem       SC - Myrtle Beach      
AR - Bentonville       HI - Honolulu       ND - Fargo       SC - North Charleston      
BC - Vancouver       IA - Des Moines       NE - Lincoln       SD - Sioux Falls      
CA - Bakersfield       IA - Iowa City       NE - Omaha       SK - Regina      
CA - Fresno       ID - Boise       NH - Bedford       SK - Saskatoon      
CA - Los Angeles       IL - Chicago       NJ - Bridgewater       TN - Chattanooga      
CA - Modesto       IN - Fort Wayne       NM - Albuquerque       TN - Knoxville      
CA - Oakland       IN - Indianapolis       NS - Halifax       TN - Memphis      
CA - Oxnard       KS - Topeka       NV - Henderson       TN - Nashville      
CA - Rancho Cucamonga       KY - Lexington       NV - Reno       TX - Amarillo      
CA - Sacramento       KY - Louisville       NY - Albany       TX - Austin      
CA - Salinas       LA - Baton Rouge       NY - Buffalo       TX - Beaumont      
CA - San Diego       LA - Lafayette       NY - New York City       TX - Corpus Christi      
CA - San Jose       LA - New Orleans       NY - Rochester       TX - Dallas      
CA - Santa Rosa       LA - Shreveport       NY - Syracuse       TX - El Paso      
CA - Stockton       MA - Burlington       OH - Cincinnati       TX - Fort Worth      
CO - Boulder       MA - Springfield       OH - Columbus       TX - Houston      
CO - Colorado Springs       MA - Westborough       OH - Dayton       TX - Killeen      
CO - Denver       MB - Winnipeg       OH - Highland Heights       TX - Laredo      
CT - Cheshire       MD - Largo       OH - Toledo       TX - Longview      
CT - New Haven       MD - Laurel       OK - Oklahoma City       TX - Lubbock      
CT - Stamford       ME - Portland       OK - Tulsa       TX - McAllen      
DE - Wilmington       MI - Ann Arbor       ON - Ottawa       TX - Midland      
FL - Daytona Beach       MI - Grand Rapids       ON - Toronto       TX - San Antonio      
FL - Fort Lauderdale       MI - Lansing       OR - Beaverton       TX - Tyler      
FL - Fort Myers       MI - Livonia       OR - Bend       TX - Waco      
FL - Gainesville       MN - Minnetonka       OR - Eugene       UT - Ogden      
FL - Jacksonville       MO - Columbia       OR - Medford       UT - Salt Lake City      
FL - Lakeland       MO - Kansas City       PA - Allentown       VA - Glen Allen      
FL - Miami       MO - St. Louis       PA - Erie       VA - Roanoke      
FL - Naples       MS - Biloxi       PA - Harrisburg       VA - Virginia Beach      
FL - Pensacola       MS - Jackson       PA - Philadelphia       VT - Burlington      
FL - Sarasota       MT - Billings       PA - Pittsburgh       WA - Seattle      
FL - Tallahassee       NB - Moncton       PA - Reading       WA - Spokane      
FL - Tampa       NB - Saint John       PA - Scranton-Wilkes Barre       WI - Green Bay      
FL - Winter Park       NC - Asheville       PA - York       WI - Madison      
GA - Atlanta       NC - Charlotte       QC - Montreal       WI - Milwaukee