100 megs data gift for every genuine quote requested

In previous levels, you were introduced to the various features of Microsoft Office Access 2010 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.

This dynamic training course is now available in Gauteng, Durban and Cape Town.

Contact us today for a group quote.

Excel

Word

PowerPoint

Outlook

Access

Project

Who Should Attend

This course is designed for delegates who have a thorough understanding of the basic and advanced user features of the Microsoft Office Access 2010 application, and are interested in learning introductory level administrator skill sets.

The course is also for the delegate who may be working in a web-based environment and may need to adapt Access applications to the environment.

Learning Outcomes - Microsoft Access 2010 Expert Training Course

  • 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 databases using a SharePoint site.

Course Content - Microsoft Access 2010 Expert Training Course

Lesson 1: Integrating Access into Your Business
Topic A: Import XML Data into an Access Database
Topic B: Export Access Data to the XML Format
Topic C: Export Data to an Outlook Address Book
Topic D: Collect Data Through Email Messages

Lesson 2: Automating a Business Process with VBA
Topic A: Create a Standard Module
Topic B: Develop Code
Topic C: Call a Procedure from a Form
Topic D: Run a Procedure

Lesson 3: Managing Switchboards
Topic A: Create a Database Switchboard
Topic B: Modify a Database Switchboard
Topic C: Set the Startup Options

Lesson 4: Distributing and Securing Databases
Topic A: Split a Database
Topic B: Implement Security
Topic C: Set Passwords
Topic D: Convert an Access Database to an ACCDE File
Topic E: Package a Database with a Digital Signature

Lesson 5: Sharing Databases Using a SharePoint Site
Topic A: Export a Table to a SharePoint List
Topic 5B: Import Data from a SharePoint List
Topic C: Publish a Database to a SharePoint Site
Topic D: Move a Database to a SharePoint Site
Topic E: Work Offline