The CompTIA Tech+ Study Guide (Exam FC0-U71, 3rd Edition, 2025) clearly states:
“If you need to have multiple concurrent users accessing data, you need a database. Flat files don’t do well when several people try to access them at once. In the vast majority of cases, one user might be able to write to the file, but all users will be limited to a read-only copy.”
It further explains that:
“Databases generally lock only on a record level (or individual line of data), so multiple people can actively use the database at one time.”
Therefore, the best reason to convert a large spreadsheet to a database is to allow multiple concurrent users to access and update the data simultaneously without conflicts.
Verified Reference:
Chapter 7: Database Fundamentals — “When to Use Databases” (pp. 389–391).
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit