Access 2007 Training Materials

Part of the Office 2007 Computer Training Materials Library featuring high quality, fully customizable, print-on-demand training courseware titles for Microsoft Office 2007.

This course provides everything you need to professionally deliver Microsoft Office Access 2007 training including editable training manual, hands-on exercise workbook, exercise files,  detailed instructor guide,  convenient lesson plans and classroom-ready PowerPoint slides.

This course comes with:   Training Manual Exercise Workbook Exercise Files Instructor Guide PowerPoint Slides Lesson Plans

You also receive:   Unlimited reprinting rights Unlimited number of users Unlimited rights to customize all course contents to suit your needs Questions? Would you like more information on this or any of our training courses? Call us toll free 1-800-730-7115

All Velsoft computer training courseware titles are completely customizable so you can easily edit each course to better suit your needs or the needs of your clients. Likewise, courses can be personalized to any organization in seconds giving you the ability to brand the material as your own. All courses come in Microsoft Word and PowerPoint formats for quick and easy editing. Print the materials as you need them, as many times as you like.

 

Access 2007 Training Course    order now $ 995 course outline  •  download sample

Office 2007 Training Library    order now $ 2495 complete bundle   •  best value     The complete Office 2007 Computer Training Materials Library includes:   Access 2007   Excel 2007   InfoPath 2007   OneNote 2007   Outlook 2007   PowerPoint 2007   Project 2007   Publisher 2007   SharePoint Designer 2007 (formerly FrontPage 2007)   SharePoint Server 2007   Visio 2007   Word 2007   Business Contact Manager 3

Using our computer training materials is easy and cost effective.
It works like this... each course (whether you purchase the course individually or as part of a library of related titles) comes with printable training manuals, stand alone exercise workbook, exercise files, instructor guide, classroom-ready PowerPoint slides and convenient lesson plans. Each of the components can be opened into Microsoft Word (or Corel WordPerfect) for editing and you are allowed to make any changes you want to the content to better suit your needs.

Why write Access 2007 training materials when we've done it for you? We've saved you thousands of hours.  We do the prep work... you do the training.

By offering such flexible training solution, you will enjoy how easy it is to customize the training materials to meet your needs. You are allowed to make any changes to the content - including replacing our name with yours. Want to replace our examples and references to those of your own in order to enhance the training and your students' experience? No problem. Prewritten courseware saves you time any money and helps you better prepare for classroom training with well-researched and proven course materials.

Access 2007 Course Outline

 

Add-ons to Access            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 Digital Signatures    What is a Digital Signature?      Obtaining a Digital Signature     Attaching Your Signature to a Database           Skill Sharpener 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 Managing Your Database   Analyzing Performance Analyzing Tables           Viewing Object Dependencies  Splitting a Database      Database Replication    Step-By-Step   Skill Sharpener Customizing Access          Opening the Options Dialogue Overview of the Options Dialogue         Changing User Information        Setting Security Options            Making Access Work Backwards       Step-By-Step   Skill Sharpener Case Study   Review Questions     Using Scripts in Access    Macro Basics         Creating Macros           Playing Macros Macro Security Deleting Macros          Step-By-Step   Skill Sharpener 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 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 Macro Groups       Creating a Macro Group           Running a Macro Group           Editing a Macro Group Step-By-Step   Skill Sharpener Case Study   Review Questions  Using Access to Collaborate        SharePoint Basics  What is SharePoint?     System Requirements    Creating a Workspace  Accessing a Workspace           Publishing to a Workspace        Step-By-Step   Skill Sharpener SharePoint Data     Using Offline Lists         Exporting a List            Restricting Permission for Data Objects Skill Sharpener 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 Case Study   Review Questions       SQL and Microsoft Access          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 Using the SELECT Statement         Selecting All Data         Selecting Specific Data Selecting Conditional Data        Using the ORDER BY Statement         Step-By-Step   Skill Sharpener 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 Using SQL Joins   Creating Simple Joins    Using an Alias   Sorting Joins   Creating Outer Joins     Step-By-Step   Skill Sharpener Case Study   Review Questions     Index