From the course: Access 2021: Tips, Tricks, and Techniques

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Create a back end

Create a back end

From the course: Access 2021: Tips, Tricks, and Techniques

Start my 1-month free trial Buy for my team

Create a back end

“

- [Instructor] If you plan on having multiple people use your database at the same time, I highly recommend that you consider splitting it. Splitting a database separates the objects into two separate files, creating what is called a front end and a back end. In the front end are all of the user interface elements. Those are your forms, reports, and queries that you've carefully designed. The back end is where all of the data tables will get stored. Splitting a database into a front end and a back end creates a situation where you can place the data tables in a common location on a network drive so that everyone in your organization can use the same files, while each individual user will get their own personalized copy of the front end on their local computer. In order to split a database, all we need to do is come up to the Database Tools tab and in the Move Data group, you'll find this button that just simply says…

Contents