Access Level 1
CTU-ACCESS10L1-C

 Email this information to yourself or a friend

 Remind me of this course at a later date




Official Program Description

Access Level 1


click here to jump to schedules and register area

A relational database application such as Microsoft® Office Access® can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will learn how to use Access to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Who Should Attend

This course is designed for students who wish to learn the basic operations of the Microsoft Access database program to perform their day-to-day responsibilities and who want to use the application to be more productive in their work.

Prerequisites

It is best if you have prior experience with Windows operating systems and basic knowledge of Microsoft Word and/or Excel.

Attend and You Will Learn

Getting Started with Access

  • Orientation to Microsoft Access
  • Creating a simple Access database
  • Getting help in Microsoft Access

Working with Table Data

  • Working with table data
  • Modifying table data
  • Sorting and filter records
  • Creating lookups

Querying a Database

  • Joining data from different tables in a query
  • Sorting and filter data in a query
  • Performing calculations in a query

Creating Advanced Queries

  • Creating parameter queries
  • Creating action queries
  • Creating unmatched and duplicate queries
  • Summarizing data

Generating Reports

  • Creating a report
  • Adding controls to a report
  • Enhancing the appearance of a report
  • Preparing a report for print

Customizing the Access Environment

  • The Access options dialog box




Sections

  Access Level 1
CTU-ACCESS10L1-C - 038
   
 
  2015 - TTS - May - Jun 2015   Status:  Available
 
In-Class:   Wed 9:00AM - 4:30PM
6 May 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 1
CTU-ACCESS10L1-C - 039
   
 
  2015 - TTS - May - Jun 2015   Status:  Available
 
In-Class:   Fri 9:00AM - 4:30PM
12 Jun 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 1
CTU-ACCESS10L1-C - 040
   
 
  2016 - TTS - Jul - Aug 2015   Status:  Available
 
In-Class:   Fri 9:00AM - 4:30PM
10 Jul 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 1
CTU-ACCESS10L1-C - 041
   
 
  2016 - TTS - Jul - Aug 2015   Status:  Available
 
In-Class:   Thu 9:00AM - 4:30PM
13 Aug 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