Course Description
Access 2016 Advanced will further build upon the topics covered in the Access 2016 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create and modify Switchboards, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), and use Table Events.
Instructor: Ed McCrae
Student data files are available under Downloads in the course dashboard.
What am I going to get from this course?
- Improve the Structure of a Database
- Maintain a Database
- Work with Access Switchboards
- Configure Access for Multiple Users
- Automate Processed with VBA
- Use Table Events
Prerequisites and Target Audience
What will students need to know or do before starting this course?
Access Introduction and Intermediate courses or equivalent experience.
Who should take this course? Who should not?
Students who wish to learn the more advanced capabilities of Access.
Curriculum
Module 1: Introduction
00:50
Lecture 2
Student Data Files
Module 2: Improving the Structure of a Database.
19:51
Lecture 3
Using the Table Analyzer Wizard
05:01
Lecture 4
Append Querying to Normalize a Table
08:22
Lecture 5
Creating a Junction Table
06:28
Module 3: Maintaining a Database
10:13
Lecture 6
Backing Up a Database
02:05
Lecture 7
Using the Compact and Repair Database Tool
03:06
Lecture 8
Using the Object Dependencies Tool
01:54
Lecture 9
Using the Database Documenter Tool
01:40
Lecture 10
Using the Performance Analyzer Tool
01:28
Module 4: Working with Access Switchboards
21:22
Lecture 11
Understanding the Access Switchboard
03:18
Lecture 12
Using The Switchboard Manager
09:02
Lecture 13
Modifying a Switchboard
05:14
Lecture 14
Setting the Startup Options
03:48
Module 5: Configuring Access for Multiple Users
10:54
Lecture 15
Using the Database Splitter
03:29
Lecture 16
Configuring Trusted Locations
01:43
Lecture 17
Password Protecting a Database
02:58
Lecture 18
Password Protecting Modules
01:16
Lecture 19
Converting a Database to an ACCDE file
01:28
Module 6: Automating Processes with VBA
23:40
Lecture 20
Understanding VBA Basics
05:49
Lecture 21
Exploring Variables and Control Flow Statements
10:13
Lecture 22
Exporting a Table or Query with VBA
06:00
Lecture 23
Converting a Macro to VBA
01:38
Module 7: Using Table Events
10:06
Lecture 24
Understanding Table Events
01:50
Lecture 25
Using the Before Change Event Command
03:58
Lecture 26
Using the After Change Event Command
04:18
Module 8: Conclusion
00:47
Lecture 27
Course Recap
00:47
