Microsoft® Access 2010 Beyond
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!*
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.
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
Module 1: Integrating Access® into Your Business
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
Create a Standard Module
Call a Procedure from a Form
Run a Procedure
Module 3: Managing Switchboards
Create a Database Switchboard
Modify a Database Switchboard
Set the Startup Options
Module 4: Distributing and Securing Databases
Split a Database
Convert an Access® Database to an ACCDE File
Package a Database with a Digital Signature
Module 5: Sharing Databases Using a SharePoint Site
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