• LOGIN
  • No products in the cart.

Login

Course Curriculum

Course Curriculum

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

MS Access 2016 Advanced

4.7( 9 REVIEWS )
453 STUDENTS
$ 249.00
MS Access 2016 Advanced

Description

MS Access 2016 Advanced is designed to teach the learners about the advanced features and functionalities of MS Access. You’ll learn how to create and manage a database more effectively by taking your existing knowledge to the next level.

  • Learning outcome
  • A strong grasp of database management.
  • Get a good hand over the advanced features and functionalities of MS Access.
  • Learn about advanced form design, packaging and encrypting a database, preparing a database for multi-user access, and more.
  • Learn to work with Access Switchboards, and Automating Processes with VBA.
  • Practical knowledge needed to fast track your career.

Requirements

  • Learners will need regular access to a computer with an internet connection.
  • High speed broadband access (LAN, Cable or DSL) is highly recommended for the optimal learning experience.
  • This course is available to all learners, of all academic backgrounds.
  • Why should I take this course?
  • 1.5+ hours of quality e-Learning contents.
  • Certificate upon completion of the course.
  • Access is Microsoft’s flagship database application that allows you to create and manage databases for all sorts of different purposes.
  • You’ll master the advanced techniques for this powerful database program and build an entire database project from scratch
  • Take your existing knowledge of MS Access to the next level and boost up your career as a database manager.

Testimonial

Hear what our happy students want to say

Setup Menus in Admin Panel