What is the main reason to split an Access database?
A)Improve development and maintenance
B)To confirm the primary key of each table
C)Controls how the tables are linked
D)To decide which fields go to which tables

Question

Quizplus · Accepted Answer

The main reason to split an Access database is to improve development and maintenance by dividing the database into a front-end and back-end. The front-end contains forms, reports, and queries, while the back-end contains the tables and relationships between them. This allows for easier management, updating, and scalability of the database.

Answer: D 
 While deciding which fields go to which tables may be necessary when splitting an Access database, it is not the main reason for doing so. The primary reason is to improve development and maintenance.

What Is the Main Reason to Split an Access Database