Enter your keyword

Course

Access 2016 – Part 1

National Business Training - Computer Training

Course Summary

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.

Course Schedule

    • Start Date
    • End Date
  • Time
  • Price
  • Status
      • 8/17/2017
      • 8/18/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 9/11/2017
      • 9/12/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 10/2/2017
      • 10/3/2017
    • 9:00 am - 5:00 pm
    • $550
    • S
      • 10/25/2017
      • 10/26/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 11/30/2017
      • 12/1/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 12/5/2017
      • 12/6/2017
    • 9:00 am - 5:00 pm
    • $550
    • S
      • 12/14/2017
      • 12/15/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 2/5/2018
      • 2/6/2018
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 4/9/2018
      • 4/10/2018
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 6/11/2018
      • 6/12/2018
    • 9:00 am - 5:00 pm
    • $550
    • S
  • S - ScheduledGTR - Guaranteed to Run

Course Outline

1 – 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

2 – WORKING WITH TABLE DATA

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

3 – QUERYING A DATABASE

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

4 – USING FORMS

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

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
Topic E: Organize Report Information
Topic F: Format Reports

6 – DESIGNING A RELATIONAL DATABASE

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

7 – JOINING TABLES

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

8 – USING DATA VALIDATION

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

9 – 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

10 – ORGANIZING A DATABASE FOR EFFICIENCY

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

11 – 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

Course 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.

 

Target 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.

 

Price $550.00

Date

Share our course