 |
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 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
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)
Related On-Site Training Courses
access Self Paced On-Demand Courses
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)
