Course Details
Course Duration – One day
Benefits of Microsoft Access Level 3 Course
Those taking Microsoft Access Level 3 are database administrators or prospective database administrators who have experience working with Access and need to learn advanced skills.
This one day instructor-led course provides students with an overview of the more complex features and functions of Microsoft Access. During this Level 3 course, participants will learn the more complex techniques such as advanced form design, using macros and advanced database management. This course also covers securing a database and managing switchboards. For more information, please read our course content below.
Insight IT specialise in on-site training and can come to you to run our Level 3 course either on your PC's or using our own high specification equipment. If you want specific training for your staff, we would be glad to customise this course to your needs, adding or removing topics as necessary. Our trainers are extremely knowledgeable with the Microsoft Office suite of products with many years of experience.
You will get the most out of the Microsoft Level 3 course if you have attended Microsoft Access Level 1 and 2.
Course Content
Implementing Advanced Form Design
- Add Controls to Forms
- Create Subforms
- Organize Information with Tab Pages
- Enhance Navigation of Forms
- Apply Conditional Formatting
Using Data Validation
- Field and Record Validation
- Form Validation
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
- Convert a Macro to VBA
Using Advanced Database Management
- Link Tables to External Data Sources
- Manage a Database
- Determine Object Dependency
- Document a Database
- Analyze the Performance of a Database
Distributing and Securing a Database
- Splitting a Database for Multiple User Access
- Implement Security
- Set Passwords
- Convert an Access Database to an ACCDE File
- Package a Database with a Digital Signature
Managing Switchboards
- Create a Database Switchboard
- Modify a Database Switchboard
- Set Startup Options
Prerequisites
Microsoft Access Levels 1 & 2