Database

What is Database?

            Database refers to a collection of related information that is organized in a way that you can easily access, manage and update. Database allows you to store data, in addition, you can summarize and extract the collected data.

What type of software is Microsoft office Excel?

                Excel is a type of spreadsheet software program that is used to manage numerical functions. The data in excel are stored in spaces called cells. It is capable of calculation and large computation, you can add charts, tables, graphing tools in this software. It allows the user to organize, format and compute data from the cells of the program.

What type of software is Microsoft office Access?

                Access is a database management system program, where tables are linked and connected. It uses unique ID to easily find and access the information. You use access to store details on large amount of items. This program keeps them organized, link and extract information from a lot of data.

Differences between Excel and Access

                Excel and Access are both used in organizing and managing data. Excel is used to perform mathematical equation and financial calculations, while Access is used for storing large amount of data. Access is hard to learn, meanwhile Excel can be learned easily. Both of these store data, however Access has a larger amount of storage capacity compared to excel.