Microsoft Office Access 2016: Part 1 Training in Pleasanton

Enroll in or hire us to teach our Microsoft Office Access 2016: Part 1 class in Pleasanton, California by calling us @303.377.6176. Like all HSG classes, Microsoft Office Access 2016: Part 1 may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Microsoft Office Access 2016: Part 1 may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.

Course Description

 
This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2016, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data. You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.
Course Length: 1 Days
Course Tuition: $250 (US)

Prerequisites

To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.

Course Outline

 
Lesson 1: Getting Started with Access
Topic A: Orientation to Microsoft Access
Topic B: Create a Simple Access Database
Topic C: Get Help and Configure Options in Microsoft Access
 
Lesson 2: Working with Table Data
Topic A: Modify Table Data
Topic B: Sort and Filter Records
 
Lesson 3: Querying a Database
Topic A: Create Basic Queries
Topic B: Sort and Filter Data in a Query
Topic C: Perform Calculations in a Query
 
Lesson 4: Using Forms
Topic A: Create Basic Access Forms
Topic B: Work with Data on Access Forms
 
Lesson 5: Generating Reports
Topic A: Create a Report
Topic B: Add Controls to a Report
Topic C: Enhance the Appearance of a Report
Topic D: Prepare a Report for Print
Topic E: Organize Report Information
Topic F: Format Reports

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.