• LOGIN
  • No products in the cart.

Students will learn the advanced features and functionality of Access 2016.


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 by using the table analyzer wizard and creating a junction table. They will explore how to maintain an Access database, including how to back up a database and how to use various tools such as the object dependencies tool. Students will also learn how to create and modify Switchboards, how to configure security and access for multi-user environments, how to automate processes with VBA (Visual Basic for Applications), and finally how to use Table Events.


Learning Outcomes

  • 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

Pre-requisites

Access Introduction and Intermediate courses or equivalent experience.


Who is this course intended for?

Students who wish to learn the more advanced capabilities of Access.

Course Curriculum

Introduction
Introduction 00:00:00
Improving the Structure of a Database
Using the Table Analyzer Wizard 00:00:00
Append Querying to Normalize a Table 00:00:00
Creating a Junction Table 00:00:00
Maintaining a Database
Backing Up a Database 00:00:00
Using the Compact and Repair Database Tool 00:00:00
Using the Object Dependencies Tool 00:00:00
Using the Database Documenter Tool 00:00:00
Using the Performance Analyzer Tool 00:00:00
Working with Access Switchboards
Understanding the Access Switchboard 00:00:00
Using The Switchboard Manager 00:00:00
Modifying a Switchboard 00:00:00
Setting the Startup Options 00:00:00
Configuring Access for Multiple Users
Using the Database Splitter 00:00:00
Configuring Trusted Locations 00:00:00
Password Protecting a Database 00:00:00
Password Protecting Modules 00:00:00
Converting a Database to an ACCDE file 00:00:00
Automating Processes with VBA
Understanding VBA Basics 00:00:00
Exploring Variables and Control Flow Statements 00:00:00
Exporting a Table or Query with VBA 00:00:00
Converting a Macro to VBA 00:00:00
Using Table Events
Understanding Table Events 00:00:00
Using the Before Change Event Command 00:00:00
Using the After Change Event Command 00:00:00
Conclusion
Course Recap 00:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • $99.00 $15.00
  • UNLIMITED ACCESS
  • Course Certificate
STUDENTS ENROLLED

    Related Courses

    © Learnsector