Unsplit Database & Merge Tables for Solo Use Access

In this Microsoft Access tutorial, I will show you how to unsplit a database and merge tables back into the front end for solo use. We'll discuss reasons for unsplitting, such as simplifying design changes and potentially improving performance. You'll learn two methods, including one that preserves table relationships.

Calvin from Loveland, Colorado (a Platinum Member) asks: I initially created a Microsoft Access database for my team, which included three employees: a secretary and two sales reps. Following your tutorials, I split the database so all four of us could us it. However, I've since downsized and it's now just me using it. I'm wondering if there's a way to unsplit the database and bring the tables back into the front end. I'm sure this would make design changes easier. Would this also improve the database's speed?

Members

There is no extended cut, but here is the database download:

•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Split Your Database

Links

• Relationships

Recommended Courses

• Access Expert 1

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, unsplit database, merge tables, local database performance, Access table merge, solo database use, database relationship preservation, database performance improvement, database redesign ease, Access local storage, Access database backup, C drive database storage, Access relationships import