Access Level 4: Advanced Design & VBA
Turn an Access database into a secured, automated business tool. Automate tasks with VBA, build switchboards and startup routines, split and lock down your database, and share it with the users.
Scheduled dates
This course is available for private and onsite training - delivered for your team anywhere in the U.S., or virtually on your schedule. You can also ask us to add it to the public calendar, or let us know you’re interested and we’ll reach out when a date is set.
Course objective
Students will integrate Access with other applications, automate business processes with VBA, build and manage database switchboards, secure and distribute a database, and share data through a SharePoint site.
Prerequisites
To ensure your success, we recommend that you have experience with advanced Access queries, forms, reports, and macros. Students can obtain this level of skill through our Access Level 1, 2, and 3 courses. This course introduces VBA programming and is technical in nature.
Course outline
- Import and Export Data
- Export Data to the Outlook Address Book
- Collect Data Through Email Messages
- Create a Standard Module
- Develop Code
- Call a Procedure from a Form
- Run the Procedure
- Create a Database Switchboard
- Modify a Database Switchboard
- Set the Startup Options
- Split a Database
- Implement Security
- Set Passwords
- Convert an Access Database to an ACCDE File
- Digital Signature Overview
- 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