Access 2016 Fundamentals - Full Day Class Personalize our class outlines. We'll create a class just for you.

Printable Version  |  See Other Class Topics  |  See All Class Outlines


Overview

Upon successful completion of this course, students will be able to:

  • Navigate within the Access environment, create a simple database, and customize Access configuration options
  • Organize and manage data stored within Access tables
  • Use queries to join, sort, and filter data from different tables
  • Use forms to make it easier to view, access, and input data
  • Create and format custom reports

Course Content

Lesson 1: Getting Started with Access 

  1. Orientation to Microsoft Access
  2. Create a Simple Access Database
  3. Get Help and Configure Options in Microsoft Access

Lesson 2: Working with Table Data

  1. Modify Table Data
  2. Sort and Filter Records

Lesson 3: Querying a Database

  1. Create Basic Queries
  2. Sort and Filter Data in a Query
  3. Perform Calculations in a Query

Lesson 4: Using Forms

  1. Create Basic Access Forms
  2. Work with Data on Acces Forms

Lesson 5: Generating Reports

  1. Create a Report
  2. Add Controls to a Report
  3. Enhance the Appearance of a Report
  4. Prepare a Report for Print
  5. Organize Report Information
  6. Format Reports

Appendix A: Microsoft Office Access 2016 Exam 77–730
Appendix B: Microsoft Office Access 2016 Common Keyboard Shortcuts 

If you would like to customize this class, please call us at (888) 572-1200.

Have a Question?

Give us a call at (888) 572-1200 or contact us for fast attention.

Get in touch!