A split database is created by splitting two Access database files ending up with a ‘Back-End’ and ‘Front-End’ database files. A ‘Back-End’ Access database normally contains only the data tables while the ‘Front-End’ comprises the remaining database objects such as queries, forms, and reports. The data that a user inputs in a database object will be stored in the tables that back-end databases hold. Anybody can go through the information available in the front-end database but in order to access the back-end, the user needs to have administrator permission. Splitting a database can improve its performance, help secure your data, […]

Tags: Access Database, access database 2016 tutorials, access database forms, access database management system, access database planning, access database queries, building an access database, creating an access database