Fully Customizable Courseware For Trainers
Microsoft Office Access 2003: Advanced
DOWNLOAD A FREE SAMPLE
Are your students ready for the advanced concepts in Microsoft Office Access 2003: Advanced training? Have they already received training in the foundation and intermediate level curriculum? Velsoft’s training materials courseware will help you get them to the next level!
Here are just a few of the topics and lessons covered in this Microsoft Office Access 2003: Advanced courseware:
- Customizing Menus
- Creating Menus?
- Setting Editing and Keyboard Options
- Setting International Options
- Creating a Macro
- Running a Macro
- Using a Switchboard
- Using Design View to Create a Data Access Page
- Using an Existing HTML Page
- Practice Exercise
- Adding a Theme
- Adding Text and Controls
- Aligning and Sizing Content
- Adding Images
- Protecting Data
- Using Cascade Update and Cascade Delete
- Setting Up Parameter Queries
- Adding Pictures and Lines
- Creating a PivotTable Using the Wizard
- Continuing Where the Wizard Left Off
- Completing A PivotChart
- Turning a PivotTable Into a PivotChart and Vice-Versa
And many more topics.
Are you ready?
SECTION 1: Customizing Access
Lesson 1.1: Customizing Menus and Toolbars
Customizing Menus
Creating Menus
Showing and Hiding Toolbars
Customizing Toolbars
Creating Toolbars
Practice Exercise
Lesson 1.2: Setting Access Options, Part 1
Setting General and View Options
Setting Editing and Keyboard Options
Setting Datasheet, Form, and Report Options
Setting Page and Tables/Queries Options
Setting Error Checking Options
Setting Advanced Options
Practice Exercise
Lesson 1.3: Setting Access Options, Part 2
Setting International Options
Setting Spelling Options
Setting AutoCorrect Options
Setting Start-Up Options
Setting Macro Security Options
Practice Exercise
Lesson 1.4: Creating Macros
Using the Macro Design Toolbar
Creating a Macro
Running a Macro
About Macro Groups
Practice Exercise
Lesson 1.5: Advanced Macro Uses
Editing a Macro With the Visual Basic Editor
Assigning a Macro to a Keystroke
Assigning a Macro to a Toolbar
Viewing and Printing Macro Definitions
Practice Exercise
Section 1: Review Questions
SECTION 2: Advanced Data Tools
Lesson 2.1: Switchboards
Using a Switchboard
Using the Switchboard Manager
Creating a Switchboard
Editing a Switchboard
Deleting a Switchboard
Practice Exercise
Lesson 2.2: Creating Data Access Pages
Using the Data Access Page Wizard
Using Design View to Create a Data Access Page
Using an Existing HTML Page
Practice Exercise
Lesson 2.3: Modifying Data Access Pages
Adding a Theme
Adding Text and Controls
Formatting Text and Controls
Aligning and Sizing Content
Adding Images
Practice Exercise
Lesson 2.4: Using Data Access Pages
Basics of Using Data Access Pages
Viewing Data Entered Via a Data Access Page
Protecting Data
Practice Exercise
Section 2: Review Questions
SECTION 3: Advanced Queries
Lesson 3.1: Table Relationships
Normalizing Your Data
Establishing Referential Integrity
Using Cascade Update and Cascade Delete
Setting Fields for Indexing
Using Indexing
Practice Exercise
Lesson 3.2: Using CrossTab Queries
Understanding CrossTab Queries
Creating a CrossTab Query Using the Wizard
Creating a CrossTab Query Manually
Practice Exercise
Lesson 3.3: Using Parameter Queries
Setting Up Parameter Queries
Using a Parameter Query
Practice Exercise
Lesson 3.4: Advanced Reporting Features
Using AutoFormat
Aligning and Formatting Controls
Adding Pictures and Lines
Practice Exercise
Section 3: Review Questions
SECTION 4: Pivot Tables and Pivot Charts
Lesson 4.1: Creating a PivotTable
Creating a PivotTable Using the Wizard
Continuing Where the Wizard Left Off
More About Fields
Completing Your PivotTable
Practice Exercise
Lesson 4.2: Using AutoForm and Creating PivotCharts
Creating a PivotTable Using AutoForm
Creating a PivotChart Using AutoForm
About PivotChart Fields
Completing A PivotChart
Practice Exercise
Lesson 4.3: Using PivotTables and PivotCharts
Using a PivotTable
Using a PivotChart
Editing a PivotTable or PivotChart
Common PivotChart Editing Features
Turning a PivotTable Into a PivotChart and Vice-Versa
Practice Exercise
Section 4: Review Questions
Everything you need to deliver amazing training
Each courseware title is a trainers' kit that comes with the following course components:
Instructor Guide
Velsoft Instructor Guides are the core of each training course. Our Instructor Guides lay out the training in simple, easy-to-follow instructions. You can also customize the Instructor Guides in order to personalize your training.
Student Manual
Each Instructor Guide - for each course - is paired with a Student Manual that you can present to your participants. This customizable Student Manual gives each participant the ?student? version of the course you will be teaching.
Exercise Workbook
Velsoft offers an Exercise Workbook (also customizable) that is specific to the course you are offering. You can choose whether this is something you would like to present to your students.
Sample Files
Pre-made Sample Exercise Files are provided for use with the Lab Workbook so that you, as the trainer, do not have to prepare activity working files.
PowerPoint Deck
Courseware from Velsoft is designed to give you everything you need for use in the classroom or for your workshop. This includes the PowerPoint versions of all the courses, prepared for you in advance.
Quick Reference Guide
Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quick Reference Guide summarizes the most important elements in each courseware title down to two pages.
Fully Customizable
Make any changes you like including easily taking our branding off and replacing it with yours.
Unlimited Users
Train as many participants at your location as you like - forever!
Unlimited Printing Rights
Print-on-demand only what you need for as many participants with no limits.
No Annual Renewal Fees
One-off pricing. Never pay again to use the materials.
