StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Database Structures, Languages, and Architectures SLP - Research Paper Example

Cite this document
Summary
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…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER96.2% of users find it useful
Database Structures, Languages, and Architectures SLP
Read Text Preview

Extract of sample "Database Structures, Languages, and Architectures SLP"

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
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Database Structures, Languages, and Architectures SLP Research Paper”, n.d.)
Retrieved from https://studentshare.org/logic-programming/1409885-database-structures-languages-and-architectures
(Database Structures, Languages, and Architectures SLP Research Paper)
https://studentshare.org/logic-programming/1409885-database-structures-languages-and-architectures.
“Database Structures, Languages, and Architectures SLP Research Paper”, n.d. https://studentshare.org/logic-programming/1409885-database-structures-languages-and-architectures.
  • Cited: 0 times

CHECK THESE SAMPLES OF Database Structures, Languages, and Architectures SLP

Service Oriented Architecture: Patterns and Antipatterns

One of the main difficulties of coming up with service architectures in businesses is the detection of the borders.... After Erl [1], the consistency organization OASIS comes up with enterprise service architectures [2]....  It makes it possible to improve distributed structures, which are adaptable, less costly and measurable....
20 Pages (5000 words) Literature review

Impact of Data Warehousing and OLAP Models on Management Accounting

database Design 32 2.... The management accountants are supposed to handle the data related to all the departments in an ordered manner for crucial decision-making.... Thus, the role of management accountant is more as a business enabler than financial data maintaining.... hellip; Today's business decision-making and business strategies greatly depend on the financial data and the way in which the accountant manages the data....
160 Pages (40000 words) Thesis

The Technical System: Information, Information Technology, and Information Systems

The paper critically analyzes Business Intelligence Systems of IBM, Microsoft, SAP, and Oracle based on their information and analysis capabilities and hardware and system software required to run the application.... In order to meet the targets set every Business Enterprise must act on proper planning....
7 Pages (1750 words) Research Paper

SAP, CRM and ERP Technologies

This assignment "SAP, CRM and ERP Technologies" focuses on SAP Web Application Server (Web AS) that requires a common infrastructure that is provided by the SAP Net Weaver.... nbsp;SAP  provides user authentication by utilizing third-party security products i.... .... Public Key infrastructure (PKI)....
16 Pages (4000 words) Assignment

Data Warehousing for Business Intelligence

The data are transformed using the Oracle database management system and with the use of Java language.... Several other aspects contributed to the improvement of data warehousing in organizations, such as the need for improvement in database technology.... relational data model and relational database management system....
8 Pages (2000 words) Coursework

Effective Management of Data Tables

network system's model resembles that of the hierarchical system but the difference is that network systems have numerous parent-child tree structures.... These systems have numerous structures thus they are highly extensive.... The paper 'Effective Management of Data Tables' presents some of the relational database systems which include SQLite, Oracle, IBM DB2, Ms.... Relational database systems are very common in most of the business organizations....
7 Pages (1750 words) Case Study

The Software and Hardware Components of the Watson Supercomputer

This objective can be achieved with the help of the processor by reducing letters, words, or symbols into a gigantic database known as information.... The paper 'The Software and Hardware Components of the Watson Supercomputer' presents IBM Watson which is an artificially designed, intelligent system, which is named for the IBM founder Thomas J....
9 Pages (2250 words) Case Study

Improving Security in Web Services-Based Services Oriented Architectures

This report "Improving Security in Web Services-Based Services Oriented architectures" presents an overview of the common existing internet attack methods that have been discussed.... These online operations of enterprises are called web-based services, which involve peer to peer communication in enterprise architectures.... Such Service-Oriented architectures are more interactive with many standards.... One of the main challenges faced by these web-based Service-Oriented architectures is the security in the communication between the service provider and the customer....
9 Pages (2250 words) Report
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us