• 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
Resources
Resources – MS Access 2016 Advanced 00:00:00
Order Your Certificate
Order Your Certificate 00:00:00

MS Access 2016 Advanced

4.7( 9 REVIEWS )
15 STUDENTS
Duration: 1.68 Hours
PRIVATE
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

Select your currency
0
    0
    Your Cart
    Your cart is emptyReturn to Shop

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only$68.11 / year

    ADD OFFER TO CART

    No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.

      Apply Coupon