MS Access 2003/2007/2010 Training Course Outline

Listed below are some set topics in Access 2003/2007/2010. We also customize on site Access training programs in the Toronto, Mississauga and GTA area.

Please select the topics that interest you and contact us or call
(905) 271 1119 for more information about courses.

Microsoft Access 2003/2007/2010 - Level 1  Introduction

Topic 1: Overview of Microsoft Access
Introduction to Database Concepts and Terminology
Introduction to Access
Database Planning and Design

Topic 2: Creating Access tables
Examining an Access Table
Creating a Table With the Table Wizard
Creating a Table in Design View
Types of Access Primary Keys

Topic 3: Working with Microsoft Access tables
Modifying a Table Using Design View
Finding and Editing Records
Filtering and Sorting Records

Topic 4: Creating and Using Select Queries
Creating an Access Select Query to View Specific Fields
Specifying Criteria in a Query to View Specific Records
Using Queries to Perform Calculations
Joining Tables in a Query

Topic 5: Creating and Using Forms
Creating a Form With the Form Wizard
Modifying the Form Design
Using a Form to Locate and Organize Information
Multiple-Table Forms

Topic 6: Creating and Using Reports
Creating a Report With the Report Wizard
Creating a Report That Contains Totals

Topic 7: Creating and Maintaining a Database
Creating a Database
Managing a Database and Its Objects
Database Maintenance
 

Microsoft Access 2003/2007/2010- Level 2

Topic1: Principles of Table Design
Normalizing Data
Normalizing Data for First, Second and Third Normal Forms

Topic 2: Principles of Table Relationships
Analyzing Table Relationships
Establishing and Testing Referential Integrity

Topic 3: Table Design Techniques
Data Validation Techniques
Indexing Techniques

Topic 4: Designing Select Queries
Using Calculated Fields in Access Queries
Creating Multiple-Table Queries

Topic 5: Customizing Form Designs
Customizing the Form Design
Performing Calculations on a Form
Adding Combo Boxes to a Form
Adding Unbound Controls

Topic 6: Working with Data Access Pages
Creating Data Access Pages
Integrating with Other Applications

Topic 7: Customizing Reports
Customizing a Report Created by the Report Wizard
Summary Options in Access reports
Working with Subreports
Creating grouping in Access reports
 

Please contact us or call 905 271 1119 for more information
on training courses

MS Office Training
► MS Excel
► MS Access
► MS Project
► SharePoint 3.0
► MS Word
► MS PowerPoint
► MS Outlook
► Microsoft Office

Action eBiz offers On-site Microsoft Access 2007 & 2010 training aand courses in Ontario, Toronto Access, Mississauga. In MS Access courses trainer covers MS Access data analysis, Microsoft Access Charts, aphs, MS Access sorting and filtering, MS Access database. Microsoft Access query training also includes MS Access formulas, Microsoft Access Function for data automation, Microsoft Access Function for data automation, Microsoft Access functions marketing and sales analysis and creating MS Access IF functions formula. We offer MS Access training in Toronto, Mississauga, Oakville, Burlington, Hamilton, Brampton, Ontario, Kitchener, Waterloo, Cambridge, Canada We offer customized MS Access training for Employees, Managers, Executives involved in Financial, Accounting, Marketing, Sales etc.. in Toronto, Mississauga, Brampton, Ontario, Kitchener, Waterloo, Hamilton, Cambridge, Canada On-site Training Microsoft MS Access Courses Trainer Toronto Mississauga Brampton
 We also offer on site training in other Microsoft Office software: MS Project, MS PowerPoint, MS Word, MS Outlook, MS Access and MS FrontPage.