Access 2016 - Part 1

Displaying courses for United States [Change]

Overview

In this course, students will use Access 2016 to manage their data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Objectives

In this course, you will create and manage an Access 2016 database. You will:
  • Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options
  • Organize and manage data stored within Access tables
  • Use queries to join, sort, and filter data from different tables
  • Use forms to make it easier to view, access, and input data
  • Create and format custom reports.

Audience

This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

Syllabus

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

Working with Table Data

  • Topic A: Modify Table Data
  • Topic B: Sort and Filter Records

Querying a Database

  • Topic A: Create Basic Queries
  • Topic B: Sort and Filter Data in a Query
  • Topic C: Perform Calculations in a Query

Using Forms

  • Topic A: Create Basic Access Forms
  • Topic B: Work with Data on Access Forms

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

Designing a Relational Database

  • Topic A: Relational Database Design
  • Topic B: Create a Table
  • Topic C: Create Table Relationships

Joining Tables

  • Topic A: Create Query Joins
  • Topic B: Relate Data Within a Table
  • Topic C: Work with Subdatasheets

Using Data Validation

  • Topic A: Use Field Validation
  • Topic B: Use Form and Record Validation

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

Organizing a Database for Efficiency

  • Topic A: Data Normalization
  • Topic B: Create a Junction Table
  • Topic C: Improve Table Structure

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

Training provider

Teaching mode:
Classroom - Instructor Led
Online - Instructor Led
Duration: 2 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Outlook on the web
United States
This skill has an average salary of
US$0
and is mentioned in
0.00%
of job ads in this area.
Database
United States
This skill has an average salary of
US$77,376
and is mentioned in
14.10%
of job ads in this area.
Database design
United States
This skill has an average salary of
US$93,023
and is mentioned in
0.58%
of job ads in this area.
C
United States
This skill has an average salary of
US$79,822
and is mentioned in
6.96%
of job ads in this area.