Fully Customizable Courseware For Trainers
Microsoft Access 2013: Expert
DOWNLOAD A FREE SAMPLE
Enlighten your students with the course Microsoft Access 2013 Expert a full featured instructor-led training course.
Twelve modules cover the features of this database program that will enable learners to expand their knowledge and employ it in their workplaces. The topics covered range from SQL to form tasks to COM Add-ins. Students are walked through the topics in an easy-to-understand way to help drive home the
salient points.
Velsoft training material packages offer instructors the tools to walk into a classroom and begin teaching. Each package comes with an instructor guide and exercise workbook, PowerPoint slides, quick reference guide, and more.
Download a free sample and see how you can put this course to work for you and your students.
Module 1: SQL and Microsoft Access
What is SQL?
What is an SQL Statement?
What is an SQL Naming Convention?
What is SQL Syntax?
Review Questions
Module 2: Using the SELECT Statement
Selecting All Data
Selecting Specific Data
Selecting Conditional Data
Using the ORDER BY Statement
Review Questions
Module 3: Using SQL Joins
Creating Simple Joins
Using an Alias
Sorting Joins
Creating Outer Joins
Review Questions
Module 4: Using Subqueries
What is a Subquery?
Creating a Subquery
Subqueries with Aggregate Functions and Nested Subqueries
Using the IN Keyword with Subqueries
Review Questions
Module 5: Advanced Form Tasks, Part One
Limiting User Access to a Form
Creating Checkboxes and Command Buttons
Building Command Button Events
Creating Event Procedures
Review Questions
Module 6: Advanced Form Tasks, Part Two
Using Hyperlinks in a Form
Adding Links to Other Database Objects
Inserting a Mailto Link in a Form
Adding a Browser Control to a Form
Performing Calculations in a Form
Review Questions
Module 7: Advanced Form Tasks, Part Three
Exporting Your Form to XML
Exporting a Form as a Word Document
Exporting a Form as HTML
Sending a Form as an E-mail Attachment
Exporting a Form to Other Formats
Review Questions
Module 8: Creating Split Forms
Creating a Split Form
Splitting an Existing Form
Using a Split Form
Fixing the Form Separator
Review Questions
Module 9: Using Digital Signatures
What is a Digital Signature?
Obtaining a Digital Signature
Attaching Your Signature to a Database
Extract and Use a Signed Database
Review Questions
Module 10: Using the Trust Center
Opening the Trust Center
Trusting a Database
Configuring Macro Security
Customizing the Message Bar
Review Questions
Module 11: Managing COM Add-ins
Viewing Add-ins
Opening the Add-in Manager
Installing Add-ins
Disabling All Add-ins
Uninstalling Add-ins
Review Questions
Module 12: Customizing Access
Changing User Information
Changing the Office Background and Theme
Setting the Default Database Type and Location
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.
