Access 2016 Basic

Learn by doing—not watching—with interactive simulations.

3,076 users

Course Includes

  • Custom-branding Certificate of Accreditation
  • Custom-branding 4.0 Credit Hours
  • Custom-branding Interactive Tutorials & Skills Assessments
  • Custom-branding Student manual, instructor guide, & practice files

What you'll learn:

  • Understand the basics of Access tables, queries, forms and reports.
  • Learn how to find, filter, and sort database information.
  • Plan and create databases, with tables and different types of fields.
  • Gain an understanding of basic database principles.

Proven Learning Method

Learning Method Diagram
Skill Assess Learn Verify Improvement

Access 2016 Basic

 Complete Course to Display Score

Access Fundamentals demo

Understand the Screen Click To Try Not Started Not Started Not Started
Open and Save a Database Not Started Not Started Not Started
Work with Database Objects Not Started Not Started Not Started
Tour of Tables Not Started Not Started Not Started
Tour of Queries Not Started Not Started Not Started
Tour of Forms Not Started Not Started Not Started
Tour of Reports Not Started Not Started Not Started
Help Not Started Not Started Not Started
Close and Exit Access Not Started Not Started Not Started

Create and Work with a Database lock Subscribe to unlock

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

Find, Filter, and Format Data lock Subscribe to unlock

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

Tables lock Subscribe to unlock

Create a Table
Understand Field Types and Properties
Index a Field
Add a Primary Key and Auto-Increment Fields
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
Add Total Rows