0
  • An empty cart

    You have no item in your shopping cart

0
  • An empty cart

    You have no item in your shopping cart

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
      • 6/1/17
      • 6/2/17
    • 9:00 am - 5:00 pm
    • $550
    • S
      • 6/27/17
      • 6/28/17
    • 11:30 am - 7:30 pm
    • $550
    • GTR
      • 8/7/17
      • 8/8/17
    • 9:00 am - 5:00 pm
    • $550
    • S
      • 10/2/17
      • 10/3/17
    • 9:00 am - 5:00 pm
    • $550
    • S
      • 12/5/17
      • 12/6/17
    • 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

Actual course outline may vary depending on offering center. Contact your sales representative for more information.

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