Microsoft Access Introductory

Time & Location

Contact us to Schedule Courses
Virtual Instructor Led Hands on Courses

About the Course

Microsoft Access is a relational database that can help you and your organization collect and manage large amounts of data. Access is a versatile tool. Use it as a personal management tool or use it as a construction set to develop applications for an entire department or organization. This course focuses the user on how 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 CONTENT

GETTING STARTED WITH ACCESS

• Orientation to Microsoft Access

• Create a Simple Access Database

• Get Help in Microsoft Access

WORKING WITH TABLE DATA

• Modify Table Data

• Sort and Filter Records

• Create Lookups

QUERYING A DATABASE

• Join Data from Different Tables in a Query

• Sort and Filter Data in a Query

• Perform Calculations in a Query

CREATING ADVANCED QUERIES

• Create Parameter Queries

• Create Action Queries

• Create Unmatched and Duplicate Queries

• Summarize Data

GENERATING REPORTS

• Create a Report

• Add Controls to a Report

• Enhance the Appearance of a Report

• Prepare a Report for Print

CUSTOMIZING THE ACCESS ENVIRONMENT

• The Access Options Dialog Box

Register
Price
Quantity
Total
  • 4 or more Course Participants
    $299
    +$38.87 HST
    $299
    +$38.87 HST
    0
    $0
  • 2 - 3 Course Participants
    $399
    +$51.87 HST
    $399
    +$51.87 HST
    0
    $0
  • Course Calendar Date Pricing
    $299
    +$38.87 HST
    $299
    +$38.87 HST
    0
    $0
  • 1 on 1 Training
    $499
    +$64.87 HST
    $499
    +$64.87 HST
    0
    $0
Total$0

Share This Event