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
      • 8/10/2017
      • 8/11/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 10/12/2017
      • 10/13/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 10/26/2017
      • 10/27/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 12/7/2017
      • 12/8/2017
    • 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