Banner rating d5dfd02e10e7bea369b370d45102dadcf6d70e41b6bfce1ee178127969f7852a
Dynamics Edge
4.67 out of 50 stars, based on 80 reviews*

Got a team or group of 5 or more people? We have special options for you, such as in-person training at your site, or special group pricing for Live Virtual training. Click or tap the button below to request a special quote for your group now!

Request Group Quote

Purchase

Price: $600
Duration: 2 days
Select Date:
Number of Seats:
Selected Date:
Selected Location:
Time: - EST

Course 100001

Price: $600, Length: 2 days

Access 2016 Introduction

100001 Access 2016 Introduction Training Access 2016 Intro Training Dynamics Edge

Start Prototyping High-Performance, Rich, and Well-Functioning Databases QUICKLY NOW. Let us teach you how to leverage Microsoft Access 2016 to speed up your organization's database creation pipeline in this value-packed Access 2016 Introduction training course!

Access is Microsoft’s flagship database application that allows you to create and manage databases for all sorts of different purposes. This new version of Access incorporates a few new features and connectivity options in order to make databases more accessible to the everyday user.

Click or tap here to enroll in this class now on the next available date of
Monday August 12, 2019, 10AM - 5PM EST!

Note: Use the above link to enroll now. If August 12, 2019 is not available due to seats filling up quickly, the next available date will be selected for you - so make sure to make the decision NOW to enroll using the above link to secure your course seat(s) on August 12, 2019!

Students will learn how to orient themselves with Microsoft Access 2016, create a simple Access database, learn how to Work with Table Data, Querying a Database, Creating Advanced Queries, Generating Reports, Customizing the Access Environment, Designing a Relational Database, Joining Tables, Organizing a Database for Efficiency, Sharing Data Across Applications, Advanced Reporting, Additional Reporting Options and get help in Microsoft Access.

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 in Microsoft Access

Lesson 2: Working with Table Data

  • TOPIC A: Modify Table Data
  • TOPIC B: Work with Records
  • TOPIC C: Sort and Filter Records
  • TOPIC D: Create Lookups

Lesson 3: Querying a Database

  • TOPIC A: Join Data from Different Tables in a Query
  • TOPIC B: Sort and Filter Data in a Query
  • TOPIC C: Perform Calculations in a Query

Lesson 4: Creating Advanced Queries

  • TOPIC A: Create Parameter Queries
  • TOPIC B: Create Action Queries
  • TOPIC C: Create Find Duplicate and Find Unmatched Queries
  • TOPIC D: Summarize Data

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

Lesson 6: Customizing the Access Environment

  • TOPIC A: The Access Options Dialog Box

Lesson 7: Designing a Relational Database

  • TOPIC A: Relational Database Design
  • TOPIC B: Create a Table
  • TOPIC C: Modify a Table and Fields
  • TOPIC D: Create Table Relationships

Lesson 8: Joining Tables

  • TOPIC A: Create Query Joins
  • TOPIC B: Join Tables That Have No Common Fields
  • TOPIC C: Relate Data within a Table
  • TOPIC D: Work with Subdatasheets
  • TOPIC E: Create Subqueries

Lesson 9: Organizing a Database for Efficiency

  • TOPIC A: Data Normalization
  • TOPIC B: Create a Junction Table

Lesson 10: Sharing Data Across Applications

  • TOPIC A: Import Data into Access
  • TOPIC B: Export Data to Text File Formats
  • TOPIC C: Export Access Data to Excel
  • TOPIC D: Create a Mail Merge

Lesson 11: Advanced Reporting

  • TOPIC A: Organize Report Information
  • TOPIC B: Format Reports
  • TOPIC C: Include Charts in a Report
  • TOPIC D: Add a Calculated Field to a Report
  • TOPIC E: Add a Subreport to an Existing Report

Lesson 12: Additional Reporting Options

  • TOPIC A: Create a Mailing Label Report
  • TOPIC B: Publish a Report as PDF

We look forward to your great success!

*NOTE: if an average rating and rating count are shown on this page, they are based on all reviews associated with Dynamics Edge that are shown on the review page, and are not restricted to reviews only for the particular course offered on this page.


100001Access 2016 Introduction