• Skip to main content
  • Skip to primary navigation
State & Federal Contracts for Government
Contact Us:       info@microassist.com       (512) 794-8440

Microassist

Menu Responsive

Search

  • Accessibility
    • Accessibility Audits
    • VPAT Consulting Services
    • Accessibility Remediation
    • Accessible PDF and Document Remediation Services
    • Accessible Website and Application Development
    • Accessibility Training
    • Accessible Elearning
    • Accessibility in the News
  • Custom Elearning
    • Elearning Philosophy
    • Accessible Elearning
    • Managed Learning Services: Training Support for Business
    • Training Staff Augmentation Services
    • Learning Management System
    • Mlearning Development
    • Examples of Our Work
    • The Learning Dispatch (Blog)
  • Classroom Training
    • Course List
    • Course Schedule
    • Classroom Rental
    • Training FAQ
    • Software Tips (Blog)
  • About
    • Government Solutions
    • Blogs
    • Team
    • Career Opportunities
    • Community Involvement
    • History
    • Newsletter Subscriptions
    • News and Media
    • Accessibility Statement
  • Open Search Field

Databases and Reporting

Access 2016: Part 2

Course Overview

Your training and experience using Microsoft Access 2016 has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

Course Length

1 day

Target Audience

This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, or creating advanced queries and reports.

Course Prerequisites

To ensure your success, it is recommended you have completed Microsoft Office Access 2016: Part 1 or possess equivalent knowledge. It is also suggested that you 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. You can obtain this level of skills and knowledge by taking either of the following Logical Operations courses, or any similar courses in general Microsoft Windows skills:

  • Windows 10: Introduction
  • Microsoft Windows 10: Transition from Windows 7
  • Microsoft Office Access 2016: Part 1

Learning Outcomes / Objectives

In this course, you will create and manage an Access 2016 database. You will:

  • Design a relational database.
  • Join tables to retrieve data from unrelated tables.
  • Validate data entered into a database.
  • Use advanced queries to manipulate your data.
  • Organize a database for efficiency and performance, and to maintain data integrity.
  • Customize reports to organize the displayed information and produce specific print layouts.

Download Course Registration Form


Topic List

Lesson 1: Designing a Relational Database
Topic A: Relational Database Design
Topic B: Create a Table
Topic C: Create Table Relationships

Lesson 2: Joining Tables
Topic A: Create Query Joins
Topic B: Relate Data Within a Table
Topic C: Work with Subdatasheets

Lesson 3: Using Data Validation
Topic A: Use Field Validation
Topic B: Use Form and Record Validation

Lesson 4: Creating Advanced Queries
Topic A: Create Parameter Queries
Topic B: Summarize Data
Topic C: Create Subqueries
Topic D: Create Action Queries
Topic E: Create Unmatched and Duplicate Queries

Lesson 5: Organizing a Database for Efficiency
Topic A: Data Normalization
Topic B: Create a Junction Table
Topic C: Improve Table Structure

Lesson 6: Using Advanced Reporting Techniques
Topic A: Include Control Formatting in a Report
Topic B: Add a Calculated Field to a Report
Topic C: Add a Subreport to an Existing Report

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

Footer

Microassist

As one of Central Texas’s most experienced software education centers, a primary training vendor for the State of Texas, and a Microsoft Certified Solution Partner, Microassist has successfully worked with clients in fields ranging from advertising, real estate, law and politics to state and government agencies.

Quick Links

Government Solutions

Accessibility in the News

Learning Dispatch (Blog)

Lexis-Nexis Mealey’s® Commentaries

Classroom Course Schedule

Digital Accessibility Blog

Contact Us

Microassist, Inc.

8500 Shoal Creek
Building 4, Suite 225

Austin, Texas 78757

Tel: (512) 794-8440
Fax: (512) 794-8742

Email: info@microassist.com MORE

Back to Top
Copyright 2021 Microassist. All Rights Reserved.
  • Privacy
  • Accessibility Statement
  • Site Map
  • Contact Us
International Association of Accessibility Professionals (IAAP) Member
Microassist on Facebook
Microassist on Twitter
Microassist on Linked In
Microassist on Youtube
MENU
  • Accessibility
    • Accessibility Audits
    • VPAT Consulting Services
    • Accessibility Remediation
    • Accessible PDF and Document Remediation Services
    • Accessible Website and Application Development
    • Accessibility Training
    • Accessible Elearning
    • Accessibility in the News
  • Custom Elearning
    • Elearning Philosophy
    • Accessible Elearning
    • Managed Learning Services: Training Support for Business
    • Training Staff Augmentation Services
    • Learning Management System
    • Mlearning Development
    • Examples of Our Work
    • The Learning Dispatch (Blog)
  • Classroom Training
    • Course List
    • Course Schedule
    • Classroom Rental
    • Training FAQ
    • Software Tips (Blog)
  • About
    • Government Solutions
    • Blogs
    • Team
    • Career Opportunities
    • Community Involvement
    • History
    • Newsletter Subscriptions
    • News and Media
    • Accessibility Statement