Microsoft Access Training | Chicago & LA
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.
Access Training deals
Found out more about our Microsoft Access Training deals and our 100% Money Back Guarantee.
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.
Upcoming Classes
Chicago |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Access 2007 - Level 3 | Mar 11 ! | Apr 21 | May 19 ! | Jun 16 |
Los Angeles |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Access 2007 - Level 3 | Mar 31 | Apr 28 | Jun 3 Jun 30 |
* Class almost full ! Class guaranteed to run † Class is full
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!"
