Access Level 2
CTU-ACCESS10L2-C

 Email this information to yourself or a friend

 Remind me of this course at a later date




Official Program Description

Access Level 2


jump to schedules and register button

Your training and experience using Microsoft® Access® has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access will result in a robust, functional database for your users.

Who Should Attend

This course is designed for individuals who wish to learn intermediate-level operations of the Microsoft® Office Access® program.

Prerequisites

We recommend that you first take one of our introductory courses such as Microsoft® Office Access® Level 1, or have equivalent knowledge and skills.

Attend and You Will Learn

Designing a Relational Database

  • Relational database design
  • Creating a table
  • Creating table relationships

Joining Tables

  • Creating query joins
  • Joining tables with no common fields
  • Relating data within a table
  • Working with subdata sheets
  • Creating subqueries

Organizing a Database for Efficiency

  • Data normalization
  • Creating a junction table
  • Improving table structure

Sharing Data Across Applications

  • Importing data into Access
  • Exporting data to text file formats
  • Exporting Access data to Excel
  • Creating a mail merge

Advanced Reporting

  • Organizing report information
  • Formatting reports
  • Include control formatting in a report
  • Adding a calculated field to a report
  • Adding a subreport to an existing report



Sections

  Access Level 2
CTU-ACCESS10L2-C - 029
   
 
  2015 - TTS - Jan - Apr 2015   Status:  Available
 
In-Class:   Wed 9:00AM - 4:30PM
25 Mar 2015
Class Schedule: 1 Sessions
Contact Hours: 6.0
Course Fee(s):
Registration Fee non-credit    $249.00
Gov't & Non-Profit Registration Fee non-credit    $199.00
Potential Discount(s):
CTU-MultClassDiscount<249
  0.60 CEUs
Location:   On Campus
 
  Access Level 2
CTU-ACCESS10L2-C - 030
   
 
  2015 - TTS - Jan - Apr 2015   Status:  Available
 
In-Class:   Thu 9:00AM - 4:30PM
9 Apr 2015
Class Schedule: 1 Sessions
Contact Hours: 6.0
Course Fee(s):
Registration Fee non-credit    $249.00
Gov't & Non-Profit Registration Fee non-credit    $199.00
Potential Discount(s):
CTU-MultClassDiscount<249
  0.60 CEUs
Location:   On Campus