77-885 · Question #133
An Access database, when splitted, is organized into two parts, i.e., back-end database and front- end database. Which of the following statements are true about the back-end database? Each correct…
The correct answer is A. It is stored on the central computer. B. It includes the tables that store all data. The splitting process organizes the database into two parts: 1.Back-end database: It includes the tables that have all data. The back-end database is stored on the central computer. 2.Front-end database: It includes the forms, queries, and reports that are used to work with the…
Question
Options
- AIt is stored on the central computer.
- BIt includes the tables that store all data.
- CIt includes the forms, queries, and reports used to work with the data.
- DIt is stored on the local computer.
How the community answered
(43 responses)- A74% (32)
- C7% (3)
- D19% (8)
Explanation
The splitting process organizes the database into two parts: 1.Back-end database: It includes the tables that have all data. The back-end database is stored on the central computer. 2.Front-end database: It includes the forms, queries, and reports that are used to work with the data. The front-end database is copied to the local computer of a user if he requires working with
Topics
Community Discussion
6
Luis F.Dec 25, 2025A and B are correct. When you split an Access database the back-end file sits on the central (shared) server and it holds only the tables with the actual data, while the front-end file is what lives on each user's local machine and contains all the forms, queries, and reports.
Carlos M.Dec 2, 2025A and B are the ones. The whole point of splitting an Access database is to keep the tables, which hold the actual data, in one place on a central server so everyone on the network is hitting the same source of truth. That is the back-end. The front-end is the lightweight piece that lives on each user's local machine and holds the forms, queries, and reports, so C and D are describing the wrong half. I actually saw a question worded almost exactly like this on my exam and I almost second-guessed myself on A because I was overthinking "central computer" versus "server," but they mean the same thing in this context, the machine everyone connects to. Locked in A and B and moved on, came back right.
Caetano A.Dec 6, 2025A and B are your answers here. C is the front-end, which lives on each user's local machine, so D is the trap for people who mix the two up. The back-end sits on the file server with nothing but the tables, which is exactly why you split it in the first place, to give everyone a shared data source without shipping the whole accdb to every workstation.
Carlos M.Dec 8, 2025Right, and worth adding that keeping the front-end local also means you can push form and report updates without touching the shared data, which is half the reason the split architecture exists.
Toby R.Dec 14, 2025A and B are right. When you split an Access database, the back-end file holds all the actual tables, so that is where the data lives, and it sits on a central or shared network location so multiple users can hit it at the same time. The front-end, which goes on each user's local machine, is what has the forms, queries, and reports, so C and D both describe the front-end, not the back-end. The whole point of splitting is that you protect the data in one place while letting people customize their own front-end copies without messing up anyone else's setup.
Grace U.Dec 20, 2025When you think about why you would split a database in the first place, which part of the system holds the data that everyone on the network needs to share from one central location, and does that help you narrow down which two answers describe the back-end?