Microsoft Access 2016 Advanced Onsite Group Training Course

Creating Relational Databases

• Understanding Table Relationships
• Creating Relationships Between Tables         
• Enforcing Referential Integrity        
• Printing and Deleting Relationships
• Understanding Relationship Types 
• Creating Relational Databases Review          

Working with Queries        

• Understanding Different Types of Queries    
• Creating a Multiple Table Query     
• Creating a Calculated Field              
• Working with Expressions and the Expression Builder              
• Using an If Function          
• Summarizing Groups of Records    
• Display Top or Bottom Values         
• Parameter Queries              
• Finding Duplicate Records
• Finding Unmatched Records            
• Crosstab Queries 
• Delete Queries     
• Append Queries  
• Make-Table Queries           
• Update Queries   
• Working with Queries Review         

Working with Forms

• Creating and Using a Form               
• Understanding Form Views              
• Modifying a Form in Layout View 
• Form Design View Basics
• Changing Tab Order           
• Working with Control Properties     
• Control Property Reference              
• Working with Form Properties         
• Form Property Reference  
• Changing a Control’s Data Source  
• Creating a Calculated Control         
• Changing a Control’s Default Value
• Creating a Sub form           
• Modifying and Working with Sub forms        
• Working with Forms Review           

Working with Reports       

• Creating a Report
• Working in Layout View   
• Adding a Logo    
• Working in Design View   
• Adjusting Page Margins and Orientation       
• Adding Page Numbers and Dates    
• Grouping and Sorting        
• Summarize Data using Totals          
• Understanding Report Sections       
• Working with Reports Review         

Formatting Forms and Reports

• Formatting Fonts
• Changing Text Alignment
• Changing Colors
• Using Conditional Formatting         
• Adding Pictures, Lines and Gridlines             
• Working with Number Formatting  
• Using Themes     
• Formatting Forms and Reports Review         

Advanced Topics

• Importing Information       
• Exporting Information       
• Linking Information from an External Source              
• Using Hyperlink Fields     
• Displaying Database Object Dependencies   
• Setting a Password in Access           
• Compacting and Repairing a Database           
• Additional Topics Review

• 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 xomputers 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

• 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

• 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

• 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

• Microsoft Access 2016 Introduction
• Microsoft Access 2013 Advanced
• Microsoft Access 2013 Intermediate
• Microsoft Access 2013 Introduction
• Microsoft Access 2010 Advanced
• Microsoft Access 2010 Intermediate
• Microsoft Access 2010 Introduction

Microsoft Value Pack (Best Deal)