Microsoft Access Training | Chicago & Los Angeles
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.
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 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 |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Access 2003 - Level 3 | Mar 5 ! | Apr 22 | May 26 |
Los Angeles |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Access 2003 - Level 3 | Mar 3 ! | Apr 16 | May 27 |
* Class almost full ! Class guaranteed to run † Class is full
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!"
