Access - Level 1 Course

Microsoft Access Training Online & Onsite

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

Microsoft Access TrainingAccess - Level 1

by Certstaffix® Training

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


Microsoft Access Training
This ILT Series course covers the basic skills and concepts students need to use Microsoft Access productively and efficiently. After an introduction to the Access environment, students will learn how to plan databases and create tables. Then they will learn to organize fields and records, and to work with data entry rules. They will learn how to create basic queries, and how to work with forms and reports. This course will help students prepare for the Microsoft Office Specialist exam for Access. 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
Course Description: Print It | Download PDF | Email It

  Public Classes - Live Online at Your Location or OursHow It Works

Certstaffix® Training public classes are instructor-led, live online training you attend from your home or work or in one of our local computer labs. Our live online instructors teach you from a remote location while being able to interact with students as in a traditional classroom setting.

  • A real, live instructor teaching you from another location
  • Hands-on learning with the software/skills you are being taught
  • Interaction with all students in the class at other locations
  • Any needed software for class provided in online lab environment
  • Easy assistance from the instructor

Click a class date below to register & view location/attendance options.

 Register ➥   June 21, 2021     
 Register ➥   May 10, 2021     

  Group Classes for Organizations - Onsite or Online How It Works

Have a group of employees needing the same training? Onsite training at your office or group live online classes are great solutions.  

  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be customized to your training needs
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session

  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Related Certifications

MOS: Microsoft Office Access 2013 Certification


Suggested Follow-Ons


Course Topics

Unit 1: Getting started
Topic A: Database Concepts
Topic B: Exploring the Access environment

Unit 2: Databases and tables
Topic A: Planning and designing databases
Topic B: Exploring tab les
Topic C: Creating tables

Unit 3: Fields and records
Topic A: Changing the design of a table
Topic B: Finding and editing records
Topic C: Organizing records

Unit 4: Data Entry rules
Topic A: Setting field properties
Topic B: Working with input masks
Topic C: Setting validation rules

Unit 5: Basic queries
Topic A: Creating and using queries
Topic B: Modifying query results and queries
Topic C: Performing operations in queries

Unit 6: Using forms
Topic A: Creating forms
Topic B: Using Design view
Topic C: Sorting and filtering records

Unit 7: Working with reports
Topic A: Creating reports
Topic B: Modifying and printing reports
Course Description: Print It | Download PDF | Email It

Public Class Format

Certstaffix® Training public classes are instructor-led live online training you attend either from your home/work location or in one of our computer labs. Our live online instructors teach you from a remote location while being able to interact with you like in a traditional classroom.


Quality Instructors

Our instructors have many years of experience teaching adult learners in person and online.

Complete Lab Environment

Access to software required is provided in a lab environment during class.

Hands-on Learning

Most classes are not all lecture - you can learn by actually doing.


Small Classes

You get more attention from the instructor and classes flow more smoothly.

Post-Class Lab Access*

Access practice lab environment for 180 days after most classes*.


Low Cancellation Rate

Most classes run as scheduled.



*These courses do not have post-class lab environment access: Adobe, Salesforce, QuickBooks Online Edition, Google, HTML, WordPress, ITIL, Six Sigma, CompTIA, Project Management, SEO, Social Media.


Group Training

Have a group of employees needing the same training? Onsite training at your office or group live online classes are great solutions.

How Group Training Works





  • 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
  • Each student receives a Course Manual with Practice Files (Materials provided before the class date)
  • If a course has a hands‐on lab, we provide access to the configured course software and files.
    (Requires a high‐speed internet connection and certain open ports on your firewall. You can perform a Connection Assessment Test here)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session
  • Training is completed in a convenient session(s) of your choosing
  • Two 15 minute breaks and one hour long break for lunch daily

Request a Free Quote

Access - Level 1 Class Reviews

Here are a sample of Microsoft Access class reviews from past students that have attended our Microsoft Access training courses.



This ILT Series course covers the basic skills and concepts students need to use Microsoft Access productively and efficiently. After an introduction to the Access environment, students will learn how to plan databases and create tables. Then they will learn to organize fields and records, and to work with data entry rules. They will learn how to create basic queries, and how to work with forms and reports. This course will help students prepare for the Microsoft Office Specialist exam for Access. 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


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

4.90 out of 5

My instructor was amazing! I’ve been recently diagnosed as an epileptic and placed on a brain changing medication (5 days ago) and I’m struggling at simple things while adjusting. He was kind, patient and helpful. I would Sign up for any and all classes he teaches!


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

4.84 out of 5

Ms. Bobbye was really great! She also took the time to go over other Microsoft tricks that would help us in Excel and Microsoft (in general) which I found extremely useful being someone who grew up learning apple software and recently had to switch to Microsoft due to work. She was very lively and knowledgeable, funny too! Made the classes very clear cut, my days flew by! Very happy with my experience


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

5.00 out of 5

Mr. Bill was absolutely amazing instructor. I'm a brand new epileptic and struggling with adjusting to new meds and comprehending - he was amazing with keeping touch, ensuring I was comprehending and available to me at all times if/when needed. I would take any course this instructor teaches! He was the best I've had and I've earned 5 degrees and his ability and teaching surpasses that of my MBA instructors.


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

4.72 out of 5

make the virtual lab window larger


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

4.94 out of 5

Loved the ease of signing up, logging in and be able to chat with the teacher and other students if you had questions and needed more clarity.


- attended our Access - Level 1 class

5.00 out of 5

JoLynn was an excellent instructor. She worked through the exercises at a perfect rate, answering questions and referencing items that we may need to know, but weren't necessarily in the manual.


- attended our Access - Level 3 class

5.00 out of 5

Instructor was the best I have had.


- attended our Access - Level 2 class

4.91 out of 5

If the instructor could (more) frequently reference the page in the book to help keep the student following along.


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

4.96 out of 5

I would have preferred a little more hands on training in combination with the instructor led walk-thru. The second day was better than the first day.


- attended our Access - Level 2 class

4.74 out of 5

I would have had the course spend more time on table relationships and queries vs forms, charting and reports. Just a personal preference.


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

4.90 out of 5

I will definitely take the next courses in this level if I can. Bill was an excellent instructor who didn't just keep to the curriculum, but answered questions that were practical and applicable to our workplaces. I really appreciate the resources he provided for post class questions, including himself and future classes. His voice is very melodic and easy to listen to, and he didn't mind at all repeating things we were confused on. He didn't just repeat, but rephrased in a different way so that it was clear. He also offered his expertise and real-world experience in how to create a more aesthetically pleasing and organized database, table, reports, etc.


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

4.72 out of 5

I thought the instructor's tone was perfect and her interaction with the manual was also good.


- attended our Access - Level 2 class

5.00 out of 5

I thought the class was very good and I learned a lot. I had taken a previous intermediate course from a different company and did not learn even half as much as I did in this class


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

4.83 out of 5

I really enjoyed my time in the classroom. Very educational and comfortable.


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

5.00 out of 5

I learned a lot in this course and I really appreciated Ali's teaching style. He is very knowledgeable and presented the material in a way that I could understand. I also appreciated his kindness and humor.


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

4.68 out of 5

I found it very easy to learn coming in at the intermediate level and never taking the basic


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

4.81 out of 5

I enjoyed Bill as the instructor. I want to make sure he is my next instructor when i take my Excel class. He has patience for is very good.


- attended our Access - Level 1 class

4.85 out of 5

Great instructor! He did a wonderful job explaining things to us even though we were not in a classroom but virtual lab. I felt he was very patient and knew what he was doing and how to explain everything easily.Thank you!


- attended our Access - Level 1 class

5.00 out of 5

Great class!!!! Will take more in the furture.


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

5.00 out of 5

Excellent instructor Mr. Ali Aidroos--very clear, knowledgeable, expert teacher! He helped me so much that I am confident I can go back to work and create a database and work with tables, queries, forms, reports. I look forward to taking the Intermediate class and Advanced class during the remainder of this week. Thank you so much! Best, Kelly Houston


- attended our Access - Level 1 class

5.00 out of 5

excellent instructional style for this format.


- attended our Access - Level 1 class

4.95 out of 5

Compared to the access level 1 and 2 courses I took earlier in the week (with a different instructor), I found this instructor (Ali) much easier to follow. I especially appreciated the following:1. He took his time with each exercise and moved along at an easy to follow pace2. he constantly referred to the page in the manual he was on and presented the manual content in order3. He provided a basis overview on how to navigate the access screens at the start of the class (which was not provided in the basic course)4.He did a great job reinforcing topics and and referencing navigation/previously presented items5. He encouraged completion of exercises at the same time he was presenting, which made it much easier to follow (and prevented boredom)I would happily take another class from Ali. It was very noticeable that the class participants were able to follow along with him and did not get "lost as they did earlier in the week.


- attended our Access - Level 3 class

5.00 out of 5

Bill, was a great teacher. He listened and answered questions he knew the answers too and anything he didn't know he tried to find out or helped us figure out. the answers. I'd definitely take a course with him leading again.


- attended our Access - Level 3 class

4.82 out of 5

Bill was by far the most helpful teacher I encountered all week! He was clearly an advanced user for all the Microsoft programs which was extremely useful for me, a newbie. Bill covered the material very thoroughly and straight to the point. I really enjoyed that he knew the program so well that he didn't have to backtrack and redo his steps so there was no confusion about the process steps I learned today. The last hour of my class he even did a "private tutor" session with me since the other two people in the class had to leave early! This was so great! He really went above and beyond the whole day but especially in the last hour. He took a look at my data with me I explained that my question was mostly what his opinion would be for me to go about applying this program to my company. We have not used Access (we have used excel, word, sharepoint etc...) and I am the first one to use Access/learn Access in my company. I also did Basic Advanced in one week in order to expedite this program usage in my company. Bill was so kind to help me think of ways to start the organization of my data/documents he is an extraordinary professor! Great Job!! 5 stars!


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

4.87 out of 5

Bill Botzong is an excellent instructor. I'm really impressed with how good he handle the class. Kudos to him


- attended our Access - Level 1 class

5.00 out of 5

Bill Botzong is a great instructor. He is very clear and concise. Explains and elaborates answers to all questions and concerns very thoroughly. Taking the next class and hoping the instructor will be just as great! Thanks Bill!


- attended our Access - Level 1 class

4.82 out of 5

Best course I have ever taken. The instructor was very knowledgeable and helpful. Appreciated the helpful hints. I also like that the course is being emailed so I can practice.


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

4.75 out of 5

Ask students to log in at least 15 minutes early to prevent delays in class start time.


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

5.00 out of 5

Amazing instructor!


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

4.62 out of 5

Ali was very enjoyable to take an online course with. He was patient, knowledgeable, respectful.


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

4.70 out of 5

Ali Aidroos was an excellent instructor & it was a pleasure to learn from him. Thank You Certaffix!!!


- attended our Access - Level 1 class

4.83 out of 5

A little more emphasis on how to actually load data into the database would be helpful.


- attended our Access - Level 1 class

4.48 out of 5


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

4.17 out of 5


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

4.48 out of 5


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

4.94 out of 5


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

4.70 out of 5


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

5.00 out of 5


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

4.91 out of 5


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

4.50 out of 5


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

5.00 out of 5


- attended our Access - Level 3 class

4.61 out of 5


- attended our Access - Level 3 class

5.00 out of 5


- attended our Access - Level 3 class

5.00 out of 5


- attended our Access - Level 2 class

4.89 out of 5


- attended our Access - Level 2 class

5.00 out of 5


- attended our Access - Level 2 class

4.83 out of 5


- attended our Access - Level 2 class

4.55 out of 5


- attended our Access - Level 2 class

4.75 out of 5


- attended our Access - Level 2 class

5.00 out of 5


- attended our Access - Level 2 class

4.95 out of 5


- attended our Access - Level 2 class

5.00 out of 5


- attended our Access - Level 1 class

4.74 out of 5


- attended our Access - Level 1 class

5.00 out of 5


- attended our Access - Level 1 class

4.83 out of 5


- attended our Access - Level 1 class

4.78 out of 5


- attended our Access - Level 1 class

4.96 out of 5


- attended our Access - Level 1 class

4.96 out of 5


- attended our Access - Level 1 class

4.91 out of 5


- attended our Access - Level 1 class

5.00 out of 5


- attended our Access - Level 1 class

5.00 out of 5


- attended our Access - Level 1 class

5.00 out of 5


- attended our Access - Level 1 class

4.94 out of 5


- attended our Access - Level 1 class

4.35 out of 5


- attended our Access - Level 1 class

4.91 out of 5


- attended our Access - Level 1 class

4.83 out of 5


- attended our Access - Level 1 class

4.67 out of 5


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

5.00 out of 5


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

5.00 out of 5


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

5.00 out of 5


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

5.00 out of 5


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

4.65 out of 5


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

4.65 out of 5


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

4.93 out of 5


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

5.00 out of 5


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

4.76 out of 5


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

5.00 out of 5


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

5.00 out of 5


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

4.76 out of 5


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

5.00 out of 5


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

4.82 out of 5


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

5.00 out of 5


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

4.82 out of 5


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

4.06 out of 5


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

5.00 out of 5


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

4.94 out of 5


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

5.00 out of 5


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

5.00 out of 5


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

5.00 out of 5


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

4.94 out of 5


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



Please contact us if we do not yet have any reviews or you would like more.


View all Microsoft Access training reviews

Microsoft Access Courses By City:

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