Microsoft Access 2007/2010 Level 3
Class timetable | Course outline
Course DescriptionThis Access course covers advanced features of Microsoft Access such as building advanced forms, writing advanced queries, creating advanced reports and to automate operations using Macros.
Target Audience
This Access training class is aimed at intermediate users who need to learn how to use advanced Microsoft Access features. Students should have completed the Access Level 2 course or have the equivalent knowledge prior to attending.
For added peace of mind, Training Connection’s Microsoft Access training comes with a 100% Money Back Guarantee.
If by lunchtime you don't feel that the program is for you, then you can leave the course at this point and receive a full refund of your course fees.
Access Level 3 Class Timetable
| Chicago | May 2 ! | Register |
| Chicago | Jun 1 | Register |
| Los Angeles | Jun 6 ! | Register |
| Chicago | Jul 5 ! | Register |
| Los Angeles | Jul 18 | Register |
| Chicago | Aug 10 | Register |
| Los Angeles | Aug 23 | Register |
| Chicago | Sep 19 | Register |
| Los Angeles | Oct 17 | Register |
| Chicago | Oct 26 | Register |
| Los Angeles | Nov 28 | Register |
* Class almost full ! Class guaranteed to run † Class is full
Learning Objectives
Upon successful completion of this Access training course students will be able to:
- Restructure Data into Appropriate Tables to Ensure Data Dependency and Minimize Redundancy.
- Write Advanced Queries to Analyze and Summarize Data.
- Create and Revise Access Macros.
- Display Data more Effectively in a Form.
- Customize Reports by using Various Access Features, thus Making them More Effective.
- Maintain your Database using Tools provided by Access.
Structuring Existing Data
- Analyze Tables
- Create a Junction Table
- Improve the Table Structure
Writing Advanced Queries
- Create Subqueries
- Create Unmatched and Duplicate Queries
- Group and Summarize Records Using Criteria
- Summarize Data Using a Crosstab Query
- Create a PivotTable and a PivotChart
Simplifying Tasks with Macros
- Create a Macro
- Attach a Macro
- Restrict Records Using a Condition
- Validate Data Using a Macro
- Automate Data Entry Using a Macro
Making Effective Use of Forms
- Display a Calendar on a Form
- Organize Information with Tab Pages
- Display a Summary of Data in a Form
Making Reports More Effective
- Include a Chart in a Report
- Print Data in Columns
- Cancel Printing of a Blank Report
- Create a Report Snapshot
Maintaining an Access Database
- Link Tables to External Data Sources
- Manage a Database
- Determine Object Dependency
- Document a Database
- Analyze the Performance of a Database
What's included
Microsoft Access Training Manual
Certificate of Course Completion
6 Months FREE Repeat Policy
2 AMC Movie Vouchers
Related Courses
