Microsoft Access Level 1 (Fundamentals)

at Training Connection - The Loop

(95)
Course Details
Price:
$895 5 seats left
Start Date:

Tue, Sep 03, 9:00am - Sep 04, 4:30pm (2 sessions)

Next start dates (2)

Location:
The Loop, Downtown/Loop
230 W Monroe St Ste 610
Btwn S Franklin & Wells Streets
Chicago, Illinois 60606
(Map)
Share:
Purchase Options
Description
Class Level: Beginner
Age Requirements: 14 and older
Average Class Size: 5

What you'll learn in this access training:

Students will learn to design and create new databases, tables, and relationships; create and maintain records; locate records; and produce reports based on the information in the database.

Target Audience: This course is aimed at students who need to learn the basic operations of the Microsoft Access database application. No prior experience of Access is required.

Detailed Course Outline

Exploring the Microsoft Access Environment
  • Examine Database Concepts
  • Explore the User Interface
  • Use an Existing Access Database
  • Customize the Access Environment
  • Obtain Help
Designing a Database
  • Describe the Relational Database Design Process
  • Define Database Purpose
  • Review Existing Data
  • Determine Fields
  • Group Fields into Tables
  • Normalize Data
  • Designate Primary and Foreign Keys
  • Determine Table Relationships
Building a Database
  • Create a New Database
  • Create a Table
  • Manage Tables
  • Create a Table Relationship
  • Save a Database as a Previous Version
Managing Data in a Table
  • Modify Table Data
  • Sort Records
  • Work with Subdatasheets
Querying a Database
  • Filter Records
  • Create a Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform Calculations on a Record Grouping
Designing Forms
  • View Data Using an Access Form
  • Create a Form
  • Modify the Design of a Form
Generating Reports
  • View an Access Report
  • Create a Report
  • Add a Custom Calculated Field to a Report
  • Format the Controls in a Report
  • Apply an AutoFormat Style to a Report
  • Prepare a Report for Print
What's included:
  • Microsoft Access Training Manual
  • Certificate of Course Completion
  • 6 Months FREE Repeat Policy

Still have questions? Ask the community.

Refund Policy
Cancellations: 
Cancellations made more than 5 days before the commencement of the training, qualify for a refund less a $100 administration fee. 
Cancellations made 5 days or less before the commencement of the training, will not be eligible for a refund 
We are not able to offer refunds for no-shows or uncompleted courses.

Rescheduling:
Rescheduling requests made 5 days before the commencement of the training are free. Rescheduling that takes place within 5 days of the commencement of the training will incur a $100 administration fee. We do not charge for student substitutions at any time.

If your student wants to confirm her seat on the future class now, then there is a $100 transfer fee payable. Alternatively, as she may not have been aware of our terms, if she is willing to check back with us 2-3 days before a future class, and provided the class is confirmed to run, we will slot her in and waive the cancellation fee.

Money Back Guarantee
We offer a money back guarantee on our public classes.

If the training does not meet expectations, students can leave the class at the end of Day 1 (or by lunchtime in the case of single day courses) and request a refund. Students have to notify the training center manager before they leave and return all the training materials to qualify for a refund.

We are unable to offer a money back guarantee to students who leave a class later than the times noted above. Students can however still repeat the training (often with a different trainer).

Map

Google Map

Training Connection

All classes at this location

Trains CTA - Blue and Red Lines - Monroe Station Walk approximately 4 blocks west on Monroe Street to Franklin Street. CTA - Orange, Pink, Purple and Brown Lines - Quincy station Walk approximately 1.5 blocks north on Wells Street, turn left (west) on Monroe Street, and go to corner of Franklin Street. CTA - Green Line Swap at Clark for Blue line or Roosevelt for Orange line. Metra - Union Station Walk 3 blocks east on West Adams (crossing river). Turn left (North) on Franklin and walk 1 block to Monroe Street.

Start Dates (3)
Start Date Time Teacher # Sessions Price
9:00am - 4:30pm TBD 2 $895
This course consists of multiple sessions, view schedule for sessions.
Wed, Sep 04 9:00am - 4:30pm TBD
9:00am - 4:30pm TBD 2 $895
This course consists of multiple sessions, view schedule for sessions.
Tue, Oct 22 9:00am - 4:30pm TBD
9:00am - 4:30pm TBD 2 $895
This course consists of multiple sessions, view schedule for sessions.
Wed, Dec 04 9:00am - 4:30pm TBD

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 8950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at Training Connection (95)

Similar Classes

School: Training Connection

Training Connection

Training Connection LLC is a computer and business skills training company.  

Our Training Philosophy

Our main focus is to provide exceptional computer desktop and business skills training. We strive to achieve this by following a 5 cornerstone approach:

1. Our Instructors

Without a doubt our most...

Read more about Training Connection

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Chicago educator.

Ready to take this class?
BOOK NOW
Taking this class for work? Get exclusive perks & discounts for free.