IT Training Courses
Microsoft Gold IT Training Partner
Contact Us
800-326-1044

Live Help

Our Learning Consultants are standing by available to help.

Search Courses:


IT Courses Offered In:


QuickStart uses Lync for remote classes and QSLive

Microsoft Gold Partner

This site runs on .NET 4.0 and SQL Server 2008 powered by Windows Server 2008 R2 Hyper-V. Built using Visual Studio 2010.

EK-084589 - Microsoft Office Access 2010, Advanced, Level 3

Course EK-084589


Price: $249.00
Software Assurance Value: Not Eligible       
Duration: 1 Days



Register Here Where do you want to train?

Can't find a class in your area? Request a specific date and location for this class.





 Course Description

Description

In Access 2010 Intermediate you were introduced to the various features of Access 2007 that dealt with local database management. However, effective database management calls for mastering the advanced administrative and collaborative features of Access. In this course, you will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.

Return to Top

Audience

Anyone with solid Microsoft Access knowledge who would like to take advantage of the power and flexibility offered by the more advanced data handling capabilities of Access 2010.

Return to Top

Prerequisites

Access 2007 Intermediate or equivalent skills and knowledge.

Return to Top

Course Objectives

Upon successful completion of 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 databases
  • Share a database using a SharePoint site.

Return to Top

Course Outline

Integrating Access into Your Business

  • Import XML Data into an Access Database
  • Export Access Data to XML Format
  • Export Data to the Outlook Address Book
  • Collect Data Through Email Messages
Automating a Business Process with VBA
  • Create a Standard Module
  • Develop Code
  • Call a Procedure from a Form
  • Run the Procedure
Managing Switchboards
  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set the Startup Options
Distributing and Securing Databases
  • Split a Database
  • Implement Security
  • Set Passwords
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature
Sharing a Database 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
  • Work Offline

Return to Top