Fully Customizable Courseware For Trainers
Microsoft Office Access 2007: Advanced
Deliver high-impact training with professionally designed, fully editable courseware you can brand, customize, and deliver in-person or online
$795.00
Are your students ready for the advanced concepts in our Microsoft Office Access 2007: Advanced training material?Have they already received training in the foundation and intermediate level curriculum? Velsoft’s courseware and training materials are here to help!
Here are just a few of the topics and lessons covered in this courseware:
- Using the Relationships View and Tab
- Normalizing Tables
- Using Cascade Delete and Cascade Update
- Creating a Modal Dialog Box
- Creating a Subform
- Sending a Form via E-Mail
- Creating a PivotChart
And many more topics!
Are you ready? Are they ready? All courseware training material is fully customizable and ready for you to download, so you can get started!
Section 1: Advanced Data Management
Lesson 1.1: Referential Integrity
Using the Relationships View and Tab
Types of Relationships
Establishing Referential Integrity
Enforcing Referential Integrity
Testing Referential Integrity
Step-By-Step
Skill Sharpener
Lesson 1.2: Table Relationships
About Join Lines
Normalizing Tables
Using Cascade Delete and Cascade Update
Setting Fields for Indexing
Using the Index
Step-By-Step
Skill Sharpener
Lesson 1.3: Switchboards
Using a Switchboard vs. Using the Navigation Pane and Tab
Using the Switchboard Manager
Creating a Switchboard
Editing a Switchboard
Deleting a Switchboard
Step-By-Step
Skill Sharpener
Lesson 1.4: Modal Dialog Boxes
Creating a Modal Dialog Box
Adding Controls
Setting Properties
Formatting your Dialog Box
Step-By-Step
Skill Sharpener
Section 1: Case Study
Section 1: Review Questions
Section 2: Advanced Form Tasks
Lesson 2.1: Using Subforms
Creating a Subform
Modifying a Subform
Working with a Subform
Synchronizing Subform Data with a Main Form
Displaying a Subform within a Main Form
Step-By-Step
Skill Sharpener
Lesson 2.2: Advanced Form Tasks
Limiting User Access to a Form
Creating Check Boxes and Command Buttons
Creating Event Procedures
Customizing Error Messages
Step-By-Step
Skill Sharpener
Lesson 2.3: Exporting Your Form.
Sending a Form via E-Mail
Managing Replies
Exporting your Form to XML
Step-By-Step
Skill Sharpener
Lesson 2.4: Using Outlook and SharePoint with Access
Creating an RSS Feed for Outlook
Importing Contacts from Outlook
Importing Contacts from a SharePoint Server
Moving your Database to a SharePoint Server
Publishing to a Web Server
Step-By-Step
Skill Sharpener
Section 2: Case Study
Section 2: Review Questions
Section 3: Pivoting Data
Lesson 3.1: Creating a PivotTable
About PivotTables
Creating a PivotTable
More about PivotTable Fields
Completing your PivotTable
Step-By-Step
Skill Sharpener
Lesson 3.2: Creating a PivotChart
About PivotCharts
Creating a PivotChart
More about PivotChart Fields
Completing Your PivotChart
Step-By-Step
Skill Sharpener
Lesson 3.3: Using PivotTables and PivotCharts
Using a PivotTable
Using a PivotChart
Editing a PivotTable or a PivotChart
Common PivotTable and PivotChart Editing Commands
Creating a PivotTable and PivotChart from the Same Object
Step-By-Step
Skill Sharpener
Section 3: Case Study
Section 3: Review Questions
Section 4: Access and Windows
Lesson 4.1: Access and Windows
Recovering Access
Starting Access on Windows Boot
Using Office Diagnostics
Checking for Updates
Step-By-Step
Skill Sharpener
Lesson 4.2: Using the Access Viewer
What is the Access Viewer?
Downloading the Viewer
Using the Viewer
Step-By-Step
Skill Sharpener
Lesson 4.3: An Introduction to SQL
What is SQL?
Parts of an SQL Statement
SQL Keywords
Adding Where Clauses
Step-By-Step
Skill Sharpener
Section 4: Case Study
Section 4: Review Questions
Index
 Select the format that works best for your organization or learners
Instructor-Led Training Kits
Complete training kit with everything you need to facilitate.
- Instructor Guide
- Participant Manual
- PowerPoint Slides
- Print-Ready Files
- Editable in Word/PowerPoint
- More
SCORM eLearning Courses
Ready-to-deploy eLearning for any SCORM-compliant LMS.
- SCORM 1.2 Package
- LMS Compatible
- Completion Certificates
- Progress Tracking
- Mobile Responsive
Storyline Source Files
Editable .story files for full customization in Articulate 360.
- Editable Source Files
- Articulate 360 Format
- Brand Customization
- Content Editing
- Interactive Elements
c0104a
What You Get
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.
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.