Adobe Training
Acrobat Training
Captivate Training
Dreamweaver Training
Flash Training
Flex Training
Illustrator Training
InDesign Training
Photoshop Training
Web Development
AJAX Training
CSS Training
HTML Training
JavaScript Training
PHP MySQL Training
Ruby on Rails Training
XML Training
Microsoft Office
Access Training
Excel Training
Outlook Training
PowerPoint Training
Project Training
Visio Training
Word Training
Business Skills
Anger Management Class
Business Communication
Business Etiquette Training
Business Writing Class
Change Management
Customer Service Training
Project Management Training
Sales Training
Supervisor Training
Time Management Training
QuickBooks
QuickBooks Training
Access Training | Chicago
Fast Facts
1 day
Max 8 students
9.00am to 4.30pm
One per student
Included
295.00
Access 2007 - Level 3
Course Description
This 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 targeted at intermediate users of Access who need to work with related tables; create advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. Students should have completed the Access Level 2 course or have the equivalent knowledge prior to attending.
Leaning 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.
Upcoming Classes
Chicago |
Aug, 2008 | Sep, 2008 | Oct, 2008 | Nov, 2008 |
| Access 2007 - Level 3 | Sep 5 | Oct 8 | Nov 21 |
Course Outline
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
Meet the Instructors
Rich
Rich has been creating custom software programs, and delivering tailored training classes for the past 13 years. His passion for instruction and his pursuit of all things technical, combine with his outgoing personality to provide an engaging and enthusiastic exchange of knowledge and ideas with his trainees. Software training for Rich is a labor of love. As he puts it, "When you love what you do, it's really not work after all!"
