Microsoft Access: Advanced
Instructor: Brandon Mack
Delivery: In-person
Length: 1 Day
Difficulty: Advanced
Join us for this course
Course Overview
You’ve covered many of the basic functions of Microsoft Office Access, and now you’re ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. Today’s training, added to that which you’ve gained from the Microsoft Office Access Novice and Microsoft Office Access Intermediate courses, rounds out your Access education and provides you with marketable job skills.
Prerequisites
You should have basic knowledge of Windows including opening applications and opening files from File Explorer. You should have a working knowledge of all topics covered in Access Novice and Access Intermediate.
What You Will Learn
- 01Implementing Advanced Form Design
- Add Controls to Forms
- Enhance Navigation and Organization of Forms
- Apply Conditional Formatting
- 02Sharing Data Across Applications
- Import Data into Access
- Export Access Data
- Link Tables to External Data Sources
- Create a Mail Merge
- 03Using Macros to Improve User Interface Design
- Create a Macro
- Restrict Records by Using a Condition
- Validate Data by Using a Macro
- Automate Data Entry by Using a Macro
- 04Using VBA
- Getting Started with VBA
- Enhance Access by Using VBA
- 05Using Advanced Database Management
- Manage a Database
- Determine Object Dependency
- Document a Database
- 06Distributing 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
- 07Managing Switchboards
- Create a Database Switchboard
- Modify a Database Switchboard
- Set Start-up Options
Included With The Course
- Professional textbook (physical and digital)
- Unused copy of any files referenced throughout the textbook.
- Certificate of completion signed by the instructor.
Associated Certifications
Not applicable.
Frequently Asked Questions
We understand that you may have questions, and we’re here to help! Some of the most commonly asked questions about this course are covered below but if they don’t cover what you are looking for feel free to reach out to us through our contact page, and we’ll respond promptly to ensure you get the assistance you require. Your satisfaction is our priority, and we’re committed to making sure you have all the information necessary for a seamless experience.
There are a few different versions of OneNote out there. There is the online version that comes with Microsoft 365, the version that comes installed with Windows, and the Microsoft 365 desktop application. This course covers the Microsoft 365 desktop application but a lot of the features can be found in the others as well.
You can find additional information on the different versions of OneNote by clicking here.
Registration
Use the registration form below to register attendees for this course. Once you are registered we will be in touch to coordinate payment. We look forward to seeing you!