Microsoft® Access 2010 Beyond

COURSE OVERVIEW:
You will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.

 

COURSE COST & LENGTH:

1 day | $500   *Contact us TODAY for Special GROUP Rates!*

AUDIENCE PROFILE:
This course is designed for students who have a thorough understanding of the basic and advanced user features of the Microsoft
® Office Access® 2007 application, and are interested in learning introductory level administrator skill sets. The course is also for students who may be working in a web-based environment and may need to adapt Access® applications to the environment.


AT COURSE COMPLETION:
After completing this course, students will be able to:
   Share Access
® data with other applications.

   Use VBA to automate a business process.
   Create and modify a database switchboard and set the startup options.
   Secure and distribute databases.
   Share databases using a SharePoint site.

 

PREREQUISITES:
To ensure the successful completion of Microsoft
® Office Access® 2010: Level 4, the following courses or equivalent knowledge is recommended:

   Microsoft® Office Access® 2010: Intro

   Microsoft® Office Access® 2010: Intermediate

   Microsoft® Office Access® 2010: Advanced

 

COURSE OUTLINE:
Module 1: Integrating Access
® into Your Business

Lessons
   Import XML Data into an Access
® Database

   Export Access® Data to the XML Format

   Export Data to an Outlook Address Book
   Collect Data Through Email Messages

 

Module 2: Automating a Business Process with VBA
Lessons
   Create a Standard Module
   Develop Code
   Call a Procedure from a Form
   Run a Procedure

 

Module 3: Managing Switchboards
Lessons
   Create a Database Switchboard
   Modify a Database Switchboard
   Set the Startup Options

 

Module 4: Distributing and Securing Databases
Lessons
   Split a Database
   Implement Security
   Set Passwords
   Convert an Access
® Database to an ACCDE File

   Package a Database with a Digital Signature
 

Module 5: Sharing Databases Using a SharePoint Site
Lessons
   Export a Table to a SharePoint List
   Import Data from a SharePoint List
   Publish a Database to a SharePoint Site
   Move a Database to a SharePoint Site
   Work Offline

Metropolitan Washington, D.C.

Call

T: 301.705.5823

© 2020 by Innovative Training, Events & Professional Solutions