Microsoft Access 2007 Introduction

In this 15-hour course you'll learn: Getting to Know the Access Window; The Ribbon, the Quick Access Toolbar, and the Context Menu; Database Basics; Database Objects - Tables, Creating a Table, Specifying Data Types and Field Properties and much more.

Course Outline

Access is a database program you can use to store and manage large quantities of data – either personal, or business. The data is organized into related tables which you can easily modify and expand. Access also offers some powerful data analysis tools – filtering, sorting, querying- that let you obtain specific Information from the database.

Course content

Day 1*
Getting to Know the Access Window; The Ribbon, the Quick Access Toolbar, and the Context Menu; Database Basics; Database Objects - Tables, Creating a Table, Specifying Data Types and Field Properties; Entering Data in a Table – Using Datasheet View, Using an Auto Form, Modifying a table; Planning and Defining Table Relationships; Filtering/Sorting Data

Day 2*
Database Objects – Forms; Creating a Form Using the Wizard; Modifying a Form in Design View; Using a Form to View/Modify the Data in the Tables; Database Objects – Queries; Performing a Simple Query; Adding Query Conditions

Day 3*
Creating a Parameter Query; Database Objects – Reports; Creating a Report Using a Wizard; Modifying a Report in Design View

Additional Details

Pre-Requisites

Basic Knowledge of Windows and Ms-Word is expected

Certificates offered

Participants receive a certificate of completion

Cancellation Policy

If you have enrolled in a class, but later decide to cancel:

a) You will receive an 80% refund if you cancel more than five business days before the start of the class. The refund will be by cheque or will be reversed to your credit card.

b) You will receive no refund if you cancel five business days or less before the start of the class . We do not provide refunds if you stop attending the classes, or do not attend any classes .

c) If you decide to participate in a later session of the same program within 12 months we will re-enroll you in the next available class at no extra charge.

CLASS CANCELLATION POLICY
Skills for Change strives to hold classes as scheduled, however if low enrollment or other circumstances beyond our control occur, SfC reserves the right to cancel or reschedule classes five business days prior to its commencement date. (We will assume no responsibility for non-refundable airline tickets or other expenses that may be incurred due to cancellation).

Map & Reviews

Skills For Change
[ View Provider's Profile ]

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

The course has not ended yet, 3 more classes are pending. So far so good!

Reviewed by Hanan N. 2011

   

I think the course should be 10 weeks a least not 7 weeks. Second opinion maybe a location near west around Wilson,Jane, Weston road. Parking space is a problem a night time. Thank You,

Reviewed by Elizabeth A. 2011

   

Skills for change should start theses courses in Brampton also...They only have few courses in Brampton locations..

Reviewed by Vipinlal V. 2011

   

did not receive a call back to confirm course. Even though I called and left messages and sent two emails to Skills for Change. To date , January 16th, I have yet to receive a call back and advise me if the course is available, or full. I will not be u

Reviewed by Tara M. 2008

   

Bill was a good teacher who made things very easy to understand.

Reviewed by Dyan C. 2007

   

- classroom was a little too hot - vending machine out of order - instructor waited for tardy attendees/started late - would have prefered a longer duration (ie. once per week) for more practice - reception staff were friendly and helpful - facility

Reviewed by Darlene M. 2007