Course Overview
In this course, students add to their Access education in order to provide themselves with marketable job skills. This course builds on the foundational skills obtained by attending the Access 2016 - Part 1 course.
On July 1, 2022 all Microsoft Office Classes will be taught using Microsoft Office 365 courseware and labs. Whether you use Microsoft Office 2016, 2019 or 365 versions, the process, tools, and techniques are the same. You will learn everything you need to improve your productivity, knowledge, and skill.
Course Objectives
In this course, you will learn to create and manage a fundamental Access 2016 database. You will: Customize a form layout to improve usability and efficiency of data entry. Share data across applications. Use macros to improve user interface design. Use VBA to enhance tasks. Organize data into appropriate tables to ensure data dependency and minimize redundancy. Lock down and prepare a database for distribution to multiple users. Create and modify a database switchboard and set the startup options.
Who Should Attend?
Students taking this course are database administrators or prospective database administrators who have experience working with Access 2016 and need to learn advanced skills.
- Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
- Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
- Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
- Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
- Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
- Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.
Course Prerequisites
There are no prerequisites for this course.
Agenda
1 - Implementing Advanced Form Design
- Add Controls to Forms
- Enhance Navigation and Organization of Forms
- Apply Conditional Formatting
2 - Sharing Data Across Applications
- Import Data into Access
- Export Access Data
- Link Tables to External Data Sources
- Create a Mail Merge
3 - Using Macros to Improve User Interface Design
- Create a Macro
- Restrict Records Using a Condition
- Validate Data Using a Macro
- Automate Data Entry Using a Macro
4 - Using VBA
- Getting Started with VBA
- Enhance Access Using VBA
5 - Using Advanced Database Management
- Manage a Database
- Determine Object Dependency
- Document a Database
6 - Distributing and Securing a Database
- Splitting a Database for Multiple User Access
- Implement Security
- Convert an Access Database to an ACCDE File
- Package a Database with a Digital Signature
7 - Managing Switchboards
- Create a Database Switchboard
- Modify a Database Switchboard
- Set Startup Options