Retrieved from https://studentshare.org/logic-programming/1409885-database-structures-languages-and-architectures
https://studentshare.org/logic-programming/1409885-database-structures-languages-and-architectures.
DATABASE STRUCTURES, LANGUAGES, AND ARCHITECTURES SLP Database Structures, Languages, and Architectures SLP Affiliation This paper presents the analysis of two most commonly used applications for data storage and management, which are Microsoft Excel and Microsoft Access. The basic purpose of this research is to analyze the features of both applications and choose one of them for the database management. Both MS Access and MS Excel are installed under the package of Microsoft Office however Microsoft Access is normally used for Small Business, Professional and Ultimate versions of the suite.
Additionally, both Access and Excel programs have some common processes; but they cannot be alternatives to each other. Moreover, the assessment of the most effective tool depends on the job or needs of data we desire to store (Burnside, 2010) and (Microsoft Corporation., 2011). Normally, people use Excel to complete their paper-works since it allows them to place and tabulate data correctly for presentations or printing. Thus, this is the basic reason that Excel is frequently used in educational, professional and offices where a lot of data needs to be gathered and tabulated.
On the other hand, MS Access is employed as an application of storing data so that it could be accessed and used later. In many cases a database is developed using MS Access so that staff could be able to access it from different locations and perform queries or insert new data when required. Moreover, a lot of people can use MS Access simultaneously without even feeling some difference (Joan, 2011). Microsoft Access is used to create a relational database, in which data can be inserted together autonomously and interdependently (by making use of tables).
Thus, in this way database users can combine data from numerous sources and analyze and/or report information as many times as they are needed. Moreover, Access allows the users to enter and store tons of data using different forms which can be intertwined for simple referencing as well as analyzing (Curmudgeon, 2011). Now we will analyze which one is better from both. From the above discussion it can be concluded that Access can be useful when we require storing tons of data in an easy way since it allows the users to enter the data using easy interface.
Access also works when we require easy referencing and analysis of data. Moreover, it performs queries to extract very small data from huge data collection and makes overall analysis easy and less time consuming (Curmudgeon, 2011) and (Burnside, 2010). Seeing that MS Access is an excellent tool for storing data as well as querying it, on the other hand Excel is suitable for collecting, manipulating data and analyzing it. Moreover, Excel encompasses wide-ranging systems and tools for importing the results of a query into worksheets consequently they can be assessed and translated more simply.
Furthermore, Excel is significantly easier to utilize, as well as has a great deal lower entry requirement in scenario of what is required to utilize it effectively. Moreover, it can be installed on numerous machines (Curmudgeon, 2011) and (Burnside, 2010). This paper has analyzed two most commonly used data storing applications Microsoft Excel and Microsoft Access. This choice is heavily dependent on the needs and requirements of user and business data. However, Access is most suitable option to store large amount of data easily like a database system.
Bibliography Burnside, K. (2010, May 10). Microsoft Excel Vs. Access. Retrieved March 02, 2011, from eHow.com: http://www.ehow.com/about_6495113_microsoft-excel-vs_-access.html Curmudgeon . (2011). Software Decisions: Access vs. Excel. Retrieved March 05, 2011, from HubPages.com: http://hubpages.com/hub/Access_vs_Excel Joan, B. (2011). Difference Between Microsoft Excel and Microsoft Access. Retrieved March 06, 2011, from Difference Between: http://www.differencebetween.net/object/difference-between-microsoft-excel-and-microsoft-access/ Microsoft Corporation. (2011). Choose between Access and Excel.
Retrieved March 04, 2011, from Microsoft.com: http://office.microsoft.com/en-us/training/choose-between-access-and-excel-RZ010253998.aspx?section=9
Read More