One of the most useful features provided by Access to its users is the feature that allows splitting the databases. Splitting a database involves creating different files, one in the backend, with relational data and another in the frontend, with interface objects.
1. Multiple Users can Access Data Simultaneously
2. Provides Better Protection
3. Allows for Future Planning
4. Easy to Modify User Interface
There are a lot of benefits that you can achieve by splitting your Access databases, the above benefits are described in detail here.