Home > Microsoft Office Training:
Microsoft Access Training - Introduction
Microsoft Office 2000-2003
Application Overview:
Microsoft Access
Microsoft Access is a relational database management system which combines the relational Microsoft Jet Database Engine with a graphical user interface. Access can use data stored in Access/Jet, Microsoft SQL Server, Oracle, or any ODBC-compliant data container. Get started quickly with prebuilt applications that you can modify or adapt to your needs. You can create and edit detailed reports that display sorted, filtered, and grouped information. Using Microsoft Access, you can manage all your information from a single database file, run queries to find and retrieve just the data you want, create forms to view, add, and update data in tables.
Users:
IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create robust databases that can be searched, sorted, analysed, reported, updated and shared with other users.
Microsoft Office 2000-2003 Training Courses
Microsoft Access
Introduction
Course Information
Duration: Two-Day Course
Platform: Windows Only
Fee: $545 CDN (+HST)
This class is limited to eight people.
Course Overview
This course introduces you to a powerful database application software, Microsoft Access. During this course, you will learn to create tables, forms, queries and reports. Students will create fields and records, specify properties for fields, format forms and reports and run queries. In this course, Excel files will be imported into an Access database and a mail merge with MS Word will be included.
Course Content
- Create and save a database file
- Design a table with various field types and properties
- Understand the primary key
- Create combo boxes to create drop-down menus in fields
- Save and name tables
- Create a columnar form based on a table
- Use the formatting tools and the Toolbox to design forms
- Understand the types of controls on forms
- Save and name forms
- Create select queries using various wildcards and operators
- Run select queries
- Save and name select queries
- Run Delete and Update queries
- Set up relationships between databases based on a key field
- Display related tables in a query
- Create reports based on tables or queries
- Place a calculated control on a report
- Save and name reports
- Create calculated fields in a query
- Create summary queries to summarize data
- Set up validations to ensure accurate data entry
- Import data from an Excel workbook
- Generate an MS Word mail merge
Calendar Dates:
Mar 26/27, 2012
May 30/31, 2012
Are you using
a newer version of
Microsoft Office?
Download PDF of Course Outline
If you have Adobe Reader installed you can view it now:
Related Training
DPA Training
Course Discounts
Receive a discount off of the regular fee for this course!
Register for two or more courses and you automatically qualify for a discount of 10% off the regular fees for all courses.
Register for five or more courses at one time and the discount increases to 15% per courses
(Note: Only the 10% discount applies to Microsoft Office or FileMaker Pro training)
(PDF 55 kb)