Access VS Excel: Which is BETTER?

             From all the teachings from Ms. Sanchez, I've learned that database is an organized collection of data. And this collection can be easily accessed and managed. The database handler is able to organize the data into tables, rows, columns, and index it for convenience to finding relevant information.

        The user makes a database that is accessible to all other users providing data using a set of software program. Database is mainly used  to store, retrieve and manage data through operating a vast amount of information.

           Microsoft Excel is a spreadsheet application launched in 1985 by the Microsoft Corporation. The software is a popular spreadsheet system, which manages data using columns and rows along with the formulas that allow the software to put mathematical function to the data inside the spreadsheet. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA) in order for it to perform certain tasks.

           On the other hand, Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is an information management tool, or relational database, that helps you store information for reference, reporting and analysis. 

         There are times that we have to pick which software is the perfect go-to but in order for us to choose Microsoft Excel, it requires a flat or nonrelational view of our data instead of a relational database that uses multiple tables, and when our data is mostly numeric. Moreover, it frequently runs calculation and statistical comparisons on our data. Meanwhile, Microsoft Access is used when we anticipate that many people will be working in the database and we want robust options that safely handle updates to our data, such as record locking and conflict resolution as well as the need to add more tables to a data set that originated as a flat or nonrelational table.