Course 100001

Access 2016 Introduction

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

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

*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
Banner rating d5dfd02e10e7bea369b370d45102dadcf6d70e41b6bfce1ee178127969f7852a
Dynamics Edge4.67 out of 50 stars, based on 80 reviews*

Register

Price: $600
Duration: 2 days
Select Date: Show More Dates
Selected Date:
Selected Location:
Class Time: - EST