Virtual and Classroom Training - All our courses are available virtually. We have also started a safe return to classroom training. Click here to learn more.

banner image

Access VBA Admin

1 Day Course
course icon

Course Information

Overview

Level

VBA and Administration

Version

2016

Course Overview

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

Course Objectives

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

Target Student

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

Prerequisites

To ensure the successful completion of this course, the following courses or equivalent knowledge is recommended:Microsoft Access Introduction, Intermediate and Advanced.

Course Outline

1. 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
2. Automating a Business Process with VBA
  • Create a Standard Module
  • Develop Code
  • Call a Procedure from a Form
  • Run the Procedure
3. Managing Switchboards
  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set the Startup Options
4. 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
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

Private Courses

We can arrange your own private Access course.

Tailored

Have us build a custom private course tailored to your needs.

Cost Effective

If you are looking to training a group of people private courses can be very cost effective.

Post Course Support

Unlimited post course email support on the course topics.

What Our Clients Think

As usual a first class training course.

Wendy Thomas - Aldi Stores Ltd

Really good course. lots of hands on practice and clear explanations.

fiona dawe - Covetrus Global Software Services

Fantastic tutor. Great course! Thank you.

Joel Weaver - Science Ltd

I took so much away from this course and felt Stuart's teaching method was exceptional.

Rowanne Kiehl - SSE

This has been by far one of the most useful and well planned/executed training courses I have ever attended. For this to have been achieved remotely just adds to how impressive it was managed.

Trevor Stratton - Lincolnshire County Council

The trainer was an excellent tutor. He did check all of the group was able to keep up and if there were any problems or questions of the attendants, he was always willing to help.

Marianne Seager - Wincanton

Related Courses

Introduction 1 Day
You will gain an essential understanding of Microsoft Access  create a new database, construct data tables, design forms and create queries.
Intermediate 1 Day
You will learn intermediary level skills for querying, reports, lookups, relationships and joins together with exporting and printing data.
Advanced 1 Day
You will gain advanced techniques including update queries. forms and controls, reports, macros, linking to external data and importing data. 
Administration 1 Day
You will learn how to exchange data with other applications, automate business processes by using VBA code and secure and share databases.
Introduction to VBA 3 Days
You will master the essential skills you need to automate your databases using VBA procedures and functions, controlling execution, debugging code and handling errors.