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

National Business Training - Computer Training

Course Summary

In this course, students will learn how to use Access 2010 to manage your 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
      • 2/27/2017
      • 2/28/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 3/7/2017
      • 3/8/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 4/6/2017
      • 4/7/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 5/22/2017
      • 5/23/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 6/5/2017
      • 6/6/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 7/13/2017
      • 7/14/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 9/7/2017
      • 9/8/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 11/9/2017
      • 11/10/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 Charts in a Report
Add a Calculated Field to a Report
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

 

Target Audience

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