New Skills

New Training: Access Management Tools

by Team Nuggets
New Training: Create Forms in Access 2019 picture: A
Published on February 22, 2021

In this 6-video skill, CBT Nuggets trainer Jacob Moran shows you the tools you’ll use to make managing your Access database a little easier. These tools include the documenter, database splitter, backup and export tools, and the access built-in security model Watch this new Microsoft 365 training.

Watch the full course: Microsoft Access 2019 Training

This training includes:

  • 6 videos

  • 28 minutes of training

You’ll learn these topics in this skill:

  • Introduction to Managing Access Databases

  • Backing Up an Access Database

  • Splitting an Access Database

  • Documenting an Access Database

  • Securing an Access Database

  • Analyzing an Access Database

What is Access Database Splitting?

When you split an Access database, you reorganize it into two parts, for the purpose of improving its performance and reducing the chances of file corruption. After splitting a database, one part of it resides on the backend and includes your data tables while the other part resides on the frontend and includes other forms of Access objects, such as queries, forms and reports.

You can split your Access database by using the Database Splitter Wizard. After doing this, you must distribute the frontend part of your database to your users, who will then use this as a local copy on their devices.

Before splitting your database, back it up. By doing this, if you don't like the results of splitting your database, you can restore your original one.

Understand that it can take a long time to split a database, and while this is happening, your users shouldn't access it.

Send me CBT Nuggets IT training news and resources. (Optional)

By submitting this form you agree that you have read, understood, and are able to consent to our privacy policy.

Don't miss out!Get great content
delivered to your inbox.

By submitting this form you agree that you have read, understood, and are able to consent to our privacy policy.

Recommended Articles

Get CBT Nuggets IT training news and resources

I have read and understood the privacy policy and am able to consent to it.

© 2023 CBT Nuggets. All rights reserved.Terms | Privacy Policy | Accessibility | Sitemap | 2850 Crescent Avenue, Eugene, OR 97408 | 541-284-5522