Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Microsoft Access 2016 Introduction Course

Microsoft Access 2016 Introduction Onsite Group Training Course


Course Description: The Introductory Microsoft Access 2016 training course teaches students the fundamental operations and functions of Microsoft Access 2016. This is a great course for students who are getting started with Access 2016 or want to refresh their core skills.

The Introductory Access 2016 Training Course will cover the following subject areas:

  • Access 2016 Fundamentals
  • Access 2016 New Features
  • Database Basics
  • Creating and Working with a Database
  • Finding, Filtering, and Formatting Data

Microsoft Access 2016 Introduction - Course Syllabus

Database Basics

  • Introduction to Databases 
  • What’s New in Access 2016            
  • Understanding the Access Program Screen   
  • Working with Database Objects      
  • Tour of a Table    
  • Adding, Editing and Deleting Records           
  • Tour of a Form    
  • Tour of a Query   
  • Tour of a Report 
  • Selecting Data     
  • Using the Zoom Box         
  • Database Basics Review   

Creating and Working with a Database

  • Planning a Database           
  • Creating a New Database  
  • Creating a Table  
  • Modifying a Table              
  • Creating a Query
  • Sorting a Query   
  • Using AND and OR Operators in a Query     
  • Creating a Form with the Form Wizard         
  • Creating a Report with the Report Wizard     
  • Creating Mailing Labels with the Label Wizard           
  • Converting an Access Database       
  • Creating and Working with a Database Review           

Finding, Filtering, and Formatting Data

  • Finding and Replacing Data             
  • Sorting Records  
  • Using Common Filters      
  • Filtering by Selection        
  • Filtering by Form
  • Creating an Advanced Filter             
  • Adjusting and Rearranging Rows and Columns           
  • Changing Gridline and Cell Effects
  • Changing the Datasheet Font           
  • Freezing a Column             
  • Hiding a Column
  • Finding, Filtering, and Formatting Data Review          

Working with Tables and Fields

  • Understanding Field Properties       
  • Indexing a Field  
  • Adding a Primary Key to a Table    
  • Inserting, Deleting, and Reordering Fields    
  • Adding Field Descriptions and Captions       
  • Changing the Field Size    
  • Formatting Number, Currency, and Date/Time Fields
  • Formatting Number, Currency, and Date/Time Fields by Hand
  • Formatting Text Fields      
  • Setting a Default Value     
  • Requiring Data Entry         
  • Validating Data   
  • Creating an Input Mask     
  • Creating a Lookup Field   
  • Creating a Value List         
  • Modifying a Lookup List  
  • Working with Tables and Fields Review        
How On-Site Training Works
How On-Site Training Works

  • Discuss your team's educational needs with a BCS representative.
  • Schedule class date(s) that fit your team's availabilty.
  • Professional Trainer will conduct the class at your facility or online.
  • We provide the instructor, instructor travel and lodging, training manuals and digital practice for each student.
  • You provide the meeting/conference room, student computers with correct software installed and a projector for the instructor to use.
  • Usually a two-week lead time to schedule a class.
  • Classes normally run from 9am-4:30pm local time, but can be adjusted to fit your schedule.
  • 1 Hour Lunch Break, and Two 15-minute Break

On-Site access Training Packages
Small Group Package (up to 6 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 6 students can attend the class for the flat rate course price of $1800/day
  • Additional students can be added for $125/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 6 students: $1800/day (Flat Rate)

Medium Group Package (up to 12 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 12 students can attend the class for the flat rate course price of $2500/day (over 31% off our Individual Training rates)
  • Additional students can be added for $100/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 12 students: $2500/day (Flat Rate)

Large Group Package (up to 18 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 18 students can attend the class for the flat rate course price of $3100 (over 43% off our Individual Training rates)
  • Additional students can be added for $75/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 18 students: $3100/day (Flat Rate)

On-Site Training Request

Please complete the information request form below, and one of our representatives will contact you within one business day.







"Great class!! Clear explanations of complex topics. I could repeat lessons as many times as needed to make sure I mastered them."
- Thomas L(Akron, OH)


Business Computer Skills Microsoft Partner
Business Computer Skills BBB Profile