Access Introduction

Course Description:

 : The Access 2016 Introduction course will teach students to manage data, construct tables, design forms and reports, and create queries using Microsoft Access 2016. Please note: This class taught using the Access 2016 version and is for users of Access 2016, 2013 and 2010. There are very few differences between the versions, and the instructor will highlight any differences.

Upon completion of the course, users will be able to:

• Create a simple Access database
• Work with table data
• Query a database
• Create advanced queries
• Generate reports
• Customize the Access 2013 environment

Course Content

Section 1: Getting Started with Access 2016
Topic 1: Orientation to Microsoft Access 2016
Topic 2: Creating a Simple Access 2016 Database
Topic 3: Get Help and Configure Options in Microsoft Access 2016

Section 2: Working with Table Data
Topic 1: Modifying Table Data
Topic 2: Sorting and Filtering Records

Section 3: Querying a Database
Topic 1: Creating Basic Queries
Topic 2: Sort and Filter Data in a Query
Topic 3: Perform Calculations in a Query

Section 4: Using Forms
Topic 1: Creating Basic Access Forms
Topic 2: Work with Data on Access Forms

Section 5: Generating Reports
Topic 1: Creating a Report
Topic 2: Add Controls to a Report
Topic 3: Enhance the Appearance of a Report
Topic 4: Prepare a Report for Print
Topic 5: Organize Report Information
Topic 6: Format Reports

Section 6 Designing a Relational Database
Topic 1: Relational Database Design
Topic 2: Creating a Table
Topic 3: Creating Table Relationships

Section 7: Sharing Data Across Applications
Topic 1: Import Data into Access
Topic 2: Export Data to Text File Formats
Topic 3: Export Access Data to Excel
Topic 4: Creating a Mail Merge

We offer live-instructor group training classes for your team.

Upskill your team from the comfort of your office or online.

Benefits of Group Training Include:

• Experienced Professional Instructor Trains Your Team
• Content Focused On Your Team's Needs
• Convenient Scheduling and Class Setup
• Significant Per/Student Cost Savings
• Online, On-Site and Blended Options Available

Get A Free Consultation