Fully Customizable Courseware For Trainers
Microsoft Office Access 2007: Expert
DOWNLOAD A FREE SAMPLE
Microsoft Office Access 2007: Expert will help you make sure that your students are ready for expert status. Have they already received training in the foundation, intermediate and advanced level curriculum? Velsoft’s courseware and training materials can take them to the next level.
Are you an expert?Are you looking to create a group of experts to deploy throughout your organization as efficiency stimulators?
Here are just a few of the topics and lessons covered in this courseware:
- Analyzing Performance
- Analyzing Tables
- Splitting a Database
- Database Replication
- Setting Security Options
- Making Access Work Backwards
- Macro Security
- Assigning a Macro to an Event
- Declaring Variables
- Prompting for User Input
- Using If-Then-Else Statements
- Accessing a Workspace
- Restricting Permission for Data Objects
- Creating a Page
- What is an SQL Statement?
- What is an SQL Convention?
- Selecting Conditional Data
- Using an Alias
And many more topics!
Are you ready?
Our Microsoft Office Access 2007: Expert courseware training material is fully customizable so the instructor can add whatever content they deem necessary (or take away whatever is not).
Section 1: Add-ons to Access
Lesson 1.1: COM Add-Ins
What is a COM Add-In?
Using the Add-Ins Tab
Opening the Add-In Manager
Loading Add-Ins
Using the Trust Center
Step-By-Step
Skill Sharpener
Lesson 1.2: Digital Signatures
What is a Digital Signature?
Obtaining a Digital Signature
Attaching Your Signature to a Database
Skill Sharpener
Lesson 1.3: Smart Tags
What is a Smart Tag?
Inserting Smart Tags into a Database
Customizing Smart Tags
Setting Smart Tag Options
Step-By-Step
Skill Sharpener
Lesson 1.4: Managing Your Database
Analyzing Performance
Analyzing Tables
Viewing Object Dependencies
Splitting a Database
Database Replication
Step-By-Step
Skill Sharpener
Lesson 1.5: Customizing Access
Opening the Options Dialog
Overview of the Options Dialog
Changing User Information
Setting Security Options
Making Access Work Backwards
Step-By-Step
Skill Sharpener
Section 1: Case Study
Section 1: Review Questions
Section 2: Using Scripts in Access
Lesson 2.1: Macro Basics
Creating Macros
Playing Macros
Macro Security
Deleting Macros
Step-By-Step
Skill Sharpener
Lesson 2.2: Other Macro Tasks
Embedding a Macro
Assigning a Macro to a Keystroke
Assigning a Macro to an Event
Assigning a Macro to a Control
Step-By-Step
Skill Sharpener
Lesson 2.3: Visual Basic and Macros
Opening the Visual Basic Editor
Adding Code to your Macro
Adding Comments to VBA Code
Declaring Variables
Prompting for User Input
Using If-Then-Else Statements
Step-By-Step
Skill Sharpener
Lesson 2.4: Macro Groups
Creating a Macro Group
Running a Macro Group
Editing a Macro Group
Step-By-Step
Skill Sharpener
Section 2: Case Study
Section 2: Review Questions
Section 3: Using Access to Collaborate
Lesson 3.1: SharePoint Basics
What is SharePoint?
System Requirements
Creating a Workspace
Accessing a Workspace
Publishing to a Workspace
Step-By-Step
Skill Sharpener
Lesson 3.2: SharePoint Data
Using Offline Lists
Exporting a List
Restricting Permission for Data Objects
Skill Sharpener
Lesson 3.3: Your Personal SharePoint Space
Public and Private Views
Shared and Private Documents
Creating a List
Creating a Page
Personalizing your Space
Step-By-Step
Skill Sharpener
Section 3: Case Study
Section 3: Review Questions
Section 4: SQL and Microsoft Access
Lesson 4.1: Understanding SQL
What is an SQL Database?
What is an SQL Statement?
What is an SQL Convention?
What is SQL Syntax?
Linking a Database to an SQL Server
Step-By-Step
Skill Sharpener
Lesson 4.2: Using the SELECT Statement
Selecting All Data
Selecting Specific Data
Selecting Conditional Data
Using the ORDER BY Statement
Step-By-Step
Skill Sharpener
Lesson 4.3: Using Subqueries
What is a Subquery?
Creating a Subquery
Subqueries with Equality
Subqueries with Aggregate Functions
Nested Subqueries and Uses of the IN Keyword
Step-By-Step
Skill Sharpener
Lesson 4.4: Using SQL Joins
Creating Simple Joins
Using an Alias
Sorting Joins
Creating Outer Joins
Step-By-Step
Skill Sharpener
Section 4: Case Study
Section 4: Review Questions
Index
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.
