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 2003 - Level 3
Course Description
Most organizations maintain and manage large amounts of information. One of the most efficient and powerful methods for storing data is a relational database. In this course, you will cover advanced features of Microsoft Access 2003, such as building advanced forms, creating advanced reports and to automate operations using Macros.
Target Audience
This Microsoft Access course is primarily aimed at existing Access users who need to learn advanced Access features such as Macros, Advanced Forms and Advanced reporting including Forms. Students should have completed the Access Level 2 course or have equivalent experience prior to attending.
Leaning Objectives
Upon successful completion of this Access training course students will be able to:
- Restructure an existing set of Data to improve the design of a Database.
- Use a variety of Techniques to summarize and present Data with queries.
- Create and revise basic Access Macros.
- Create Macros that improve Data entry efficiency and integrity.
- Improve the effectiveness of Data entry in Forms.
- Improve the effectiveness of data displayed in Reports.
- Maintain an Access database by using various Utility tools.
Upcoming Classes
Chicago |
Aug, 2008 | Sep, 2008 | Oct, 2008 | Nov, 2008 |
| Access 2003 - Level 3 | Sep 26 | Oct 29 |
Course Outline
Structuring Existing Data
- Import Data
- Analyze Tables
- Create a Junction Table
- Improve Table Structure
Writing Advanced Queries
- Create Unmatched and Duplicates Queries
- Group and Summarize Records Using the Criteria Field
- Summarize Data with a Crosstab Query
- Create a PivotTable and a PivotChart
- Display a Graphical Summary on a Form
Simplifying Tasks with Macros
- Create a Macro
- Attach a Macro to a Command Button
- Restrict Records Using a Where Condition
Adding Interaction and Automation with Macros
- Require Data Entry with a Macro
- Display a Message Box with a Macro
- Automate Data Entry
Making Forms More Effective
- Change the Display of Data Conditionally
- Display a Calendar on a Form
- Organize Information with Tab Pages
Making Reports More Effective
- Cancel Printing of a Blank Report
- Include a Chart in a Report
- Arrange Data in Columns
- Create a Report Snapshot
Maintaining an Access Database
- Link Tables to External Data Sources
- Back Up a Database
- Compact and Repair a Database
- Protect a Database with a Password
- 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!"
