Instructor Led Pivottable Training Classes
From Mullan Training
VB Access



...tion
working with forms and controls
working with the PivotTable object.
Debugging code
handling errors to ensure minimal downtime while building and effecting the program.
COURSE CONTENT
The VBA Programming Environment
When to use Visual Basic for Applications instead of Macros
Visual Basic for Applications Development Environment
Programming in the VBA Language Code
more...
VB Excel


...tion
working with forms and controls
working with the PivotTable object.
debugging code & handling errors to ensure minimal downtime while building and effecting the program.
COURSE CONTENT
Introduction
What is a Macro
Recording a Macro
Running a Macro
Relative References
Assigning Macros to Buttons and Objects
Assigning a Macro to a Button on a Sheet
Assigning
more...
Introduction To MS Frontpage



...abase Results Wizard
Components
- Office spreadsheet/ PivotTable/ chart
- Banner ad manager
- Hit counter
- Hover button
- Marquee
- Include page
- Scheduled picture/ include page
- Search form
- Table of contents
Various
- Check In/ Out Files
- Line Breaks
- Tools Spell Check, Replace, Etc
- Active Elements (Hover Button, Marquee, Etc)
- Create And Use Templates
- Use of Macros
more...
From INT Information Systems, Inc.
Mastering: Microsoft Excel PivotTables


... its most neglected. Many people have never even heard of PivotTables and those who have have often seen only the most basic features of the tool. This class devotes an entire day to exploring all of the most useful and powerful aspects of Excel's PivotTables. The class is taught as a hands-on "laboratory" lead by an experienced instructor. During class, students use a workstation to work with
more...
From Boston University Corporate Education Center
Access 2003 Level III
...: Summarize Data with a Crosstab Query Topic 2D: Create a PivotTable and a PivotChart Topic 2E: Display a Graphical Summary on a Form
Lesson 3: Simplifying Tasks with Macros
Topic 3A: Create a Macro Topic 3B: Attach a Macro to a Command Button Topic 3C: Restrict Records Using a Where Condition
Lesson 4: Adding Interaction and Automation with Macros
Topic 4A: Require Data Entry with
more...
From The Career Center
Access VBA Programming
Your training in and experience with Microsoft Access has provided you with a solid
foundation for working with this database software. In the previous course in this series,
you began to implement some of the more specialized and advanced capabilities that Access
offers. You are now ready to extend your knowledge base beyond the user level and into
introductory-level administrator skill sets. You
more...
