New Training: Access Management Tools
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.