DBMS – Access versus Excel
Database management systems (DBMS) are a set of computer programs that allow businesses to place control of the creation, maintenance, and use of a database in the hands of database administrators. These software packages allow different user application programs access to the integrated collection of files called databases. Spreadsheet applications are programs that allow a person to create and manipulate spreadsheets on a computer. This paper will discuss the advantages and disadvantages of using the DBMS Microsoft Access over using the spreadsheet application Microsoft Excel as a database. Microsoft Access
Access is a relational model meaning it is a model based on first-predicate logic that uses tables to store data and manage the relationship between the tables. It is a DMBS that is primarily used to store data for retrieval in the future, and is usually set up so that employees may access it from multiple locations in order to add, change, or query information. When employees use Access, rather than locking up the entire database while in use, the program simply restricts those records that are in current use. “The program has the capability to store data in more than one table and relate or link the tables on common fields. This eliminates the redundancy of a "flat" file and makes entering information easy, with data entry forms using features which eliminate or reduce typing and ensure valid data is entered; this is one advantage that it has over Excel (GEE, 2009).” Access is not user friendly and does require a background in programming in order to be used most affectively unless it is first set up for the user. However, Access is a very powerful program that is suited to the more complex requirements of most databases. Microsoft Excel
Excel is a spreadsheet application that is primarily used to arrange and tabulate data for printed paperwork and presentations by analyzing and manipulating data using...