Enter your keyword

Course

Access 2013 – Part 1

National Business Training - Computer Training

Course Summary

In this course, students will learn how to use Access 2013 to manage 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
      • 1/31/2018
      • 2/1/2018
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 2/26/2018
      • 2/27/2018
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 3/5/2018
      • 3/6/2018
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 3/14/2018
      • 3/15/2018
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 4/3/2018
      • 4/4/2018
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 4/26/2018
      • 4/27/2018
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 5/3/2018
      • 5/4/2018
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 5/14/2018
      • 5/15/2018
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 5/22/2018
      • 5/23/2018
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 5/31/2018
      • 6/1/2018
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 6/18/2018
      • 6/19/2018
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 6/28/2018
      • 6/29/2018
    • 9:00 am - 5:00 pm
    • $550
    • GTR
  • S - ScheduledGTR - Guaranteed to Run

Course Outline

1 – GETTING STARTED WITH ACCESS

Orientation to Microsoft Access
Create a Simple Access Database
Get Help in Microsoft Access

2 – WORKING WITH TABLE DATA

Modify Table Data
Sort and Filter Records
Create Lookups

3 – QUERYING A DATABASE

Join Data from Different Tables in a Query
Sort and Filter Data in a Query
Perform Calculations in a Query

4 – CREATING ADVANCED QUERIES

Create Parameter Queries
Create Action Queries
Create Unmatched and Duplicate Queries
Summarize Data

5 – GENERATING REPORTS

Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
Prepare a Report for Print

6 – CUSTOMIZING THE ACCESS ENVIRONMENT

The Access Options Dialog Box

7 – DESIGNING A RELATIONAL DATABASE

Relational Database Design
Create a Table
Create Table Relationships

8 – JOINING TABLES

Create Query Joins
Join Tables That Have No Common Fields
Relate Data within a Table
Work with Subdatasheets
Create Subqueries

9 – ORGANIZING A DATABASE FOR EFFICIENCY

Data Normalization
Create a Junction Table
Improve Table Structure

10 – SHARING DATA ACROSS APPLICATIONS

Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge

11 – ADVANCED REPORTING

Organize Report Information
Format Reports
Include Control Formatting in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report

Course Objectives

Upon successful completion of  this course, students will be able to:

  • Use Access 2013 to manage data, including creating a new database.
  • Construct tables
  • Design forms and reports.
  • Create queries to join, filter, and sort data.

Target Audience

This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2013, 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