• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Access 2016 Advanced

Access 2016 Advanced

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 1 hour 40 minutes

  • All levels

Description

If you have already done with the basic functions of Microsoft Office Access 2016, then now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more.

Access is Microsoft's flagship database application that allows you to create and manage databases for all sorts of different purposes. This new version of Access incorporates a few new features and connectivity options in order to make databases more accessible to the everyday user. This Access 2016 Advanced is intended to help all users get up to speed on the different features of Access and to become familiar with its more advanced features. The course covers how to complete advanced form design tasks, add field and record validation, create and manage macros, conduct advanced database management, distribute and secure a database, and manage switchboards.

What Will I Learn?
  • 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

Requirements
  • Access Introduction and Intermediate courses or equivalent experience.

Who is the target audience?
  • Students who wish to learn the more advanced capabilities of Access.

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:09: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 Too

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:02: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:01:00

Resources

Resources - Access 2016 Advanced

00:00:00

Course Certification

About The Provider

We understand more than anyone how important it is for yo...

Read more about iStudy UK

Tags

Reviews