$29.99
Certification

Industry recognized certification enables you to add this credential to your resume upon completion of all courses

Need Custom Training for Your Team?
Get Quote
Call Us

Toll Free (844) 397-3739

Inquire About This Course
Instructor
Intellezy Trainers, Instructor - Access 2016 Advanced

Intellezy Trainers

Improving individual or company performance begins with the right training resources. Keep your team’s Microsoft and Adobe skills fresh with our engaging, short-segment videos. Intellezy’s training is delivered by certified instructors and industry experts. Their friendly, engaging style breaks down complex ideas into bite-sized learning nuggets. And, because they never leave the screen, the learner’s attention is held longer. Start watching and find out how valuable 3 minutes can be.

Add polish to your Access 2016 database skills with this advanced course.

    • Improve the Structure of a Database
    • Maintain a Database
    • Work with Access Switchboards

Duration: 1h 38m

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 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