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
      • 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

 

Course Objectives

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

  • Use Access 2010 to manage your data
  • Create 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 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