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
