0
  • LOGIN

  • No products in the cart.

Login

Forgot Password?

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
TAKE THIS COURSE
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
The modules are easy to understand and there is help available if required. Besides great collection of exciting topics which make you come back for more.
It was a pleasure to do a course in SkillUp. The course is well organized and I could study at my own pace.
Super varied course content. From Healthcare and fitness to Therapeutic courses. What I particularly like are the course modules and the way they are arranged gradually. With my nutritional background, I have come to know and love completely different perspectives.
Recommendable! A unique experience, the courses have every detail covered. Enjoyed the course through and through.
The price is reasonable, and you know upfront of your costs. I would recommend Skill Up to learners who want to excel their skills or looking for self-development.
The modules are easy to understand and there is help available if required. Besides great collection of exciting topics which make you come back for more.
Previous
Next

Related Courses

Setup Menus in Admin Panel