Toll Free - 877-442-3915

Account | Self-Paced Login

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

Microsoft Access 2016 Course

Microsoft Access 2016 Self Paced Training Course

Course Description: Introduces the new features and functions of Access 2016, while training students on all the core, intermediate and advanced operations available in Access 2016.

Price: 6-month User License: $99.00
Price: 12-month User License: $129.00

6-Month License $99

12-Month License $129

Microsoft Access 2016 Self-Paced Course Syllabus

Access 2016 Fundamentals

  • Understand the Screen
  • Open and Save a Database
  • Work with Database Objects
  • Tour of Tables
  • Tour of Queries
  • Tour of Forms
  • Tour of Reports
  • Tour of Reports
  • Help
  • Close and Exit Access
Creating and Working with a Database
  • Plan a Database
  • Create a Database
  • Add, Edit, and Delete Records
  • Select Data
  • Cut, Copy, and Paste Data
  • Use Undo and Redo
  • Check Spelling
  • Use the Zoom Box
  • Preview and Print
Finding, Filtering, and Formatting Data
  • Find and Replace Data
  • Sort Records
  • Use Common Filters
  • Filter by Selection
  • Filter by Form
  • Create an Advanced Filter
  • Adjust Rows and Columns
  • Change Gridlines and Cell Effects
  • Freeze a Column
  • Hide a Column
Working with Tables
  • Create a Table
  • Understand Field Types and Properties
  • Index a Field
  • Add a Primary Key
  • Insert, Reorder, and Delete Fields
  • Add Field Descriptions and Captions
  • Change the Field Size
  • Format Number, Currency, and Date/Time Fields
  • Format Text Fields
  • Set a Default Value
  • Require Data Entry
  • Validate Data
  • Create an Input Mask
  • Create a Lookup Field
  • Create a Value List
  • Modify a Lookup List
Creating Relational Databases
  • Table Relationships and Relationship Types
  • Create Relationships Between Tables
  • Enforce Referential Integrity
  • Print and Delete Relationships
Working with Queries
  • Create a Query
  • Sort a Query
  • Use AND and OR Operators in a Query
  • Create a Multiple Table Query
  • Create a Calculated Field
  • Work with Expressions and the Expression Builder
  • Use an IIF Function
  • Summarize Groups of Records
  • Display Top or Bottom Values
  • Parameter Queries
  • Find Duplicate Records
  • Find Unmatched Records
  • Crosstab Queries
  • Delete Queries
  • Append Queries
  • Make-Table Queries
  • Update Queries
Working with Forms
  • Create a Form with the Form Wizard
  • Create and Use a Form
  • Modify a Form in Layout View
  • Form Design View Basics
  • Change the Tab Order
  • Work with Control Properties
  • Work with Form Properties
  • Change a Control’s Data Source
  • Create a Calculated Control
  • Change a Control’s Default Value
  • Create a Subform
  • Work with and Modify Subforms
Working with Reports
  • Create a Report
  • Use the Report Wizard
  • Use the Label Wizard
  • Work in Layout View
  • Format Fonts
  • Copy Formatting
  • Change Text Alignment
  • Insert a Logo
  • Adjust Page Margin and Orientation
  • Add Page Numbers and Dates
  • Group and Sort
  • Summarize Data using Totals
  • Understand Report Sections
Advanced Topics
  • Use Conditional Formatting
  • Work with Number Formatting
  • Use Themes
  • Import Information
  • Export Information
  • Link External Information
  • Mail Merge Records to Word
  • Use Hyperlink Fields
  • Database Object Dependencies
  • Compact and Repair a Database
  • Convert an Access Database

Special Offers!

Special Offer: Get this class, along with all of our other available Microsoft Office self-paced training courses for only $149. See what is included in the Microsoft Office value package.

Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)

Featured Content

Ultimate Guide to Excel Charts and Graphs

Business Computer Skills BBB Profile