Nobody downloaded yet

Business information for Fly Guys about Excel Spreadsheet and Access Database - Assignment Example

Comments (0) Cite this document
Summary
This paper assesses the capabilities of this utilities based on the business information need at Fly Guys. The author describes the ability of the MS Access database application, compares Excel spreadsheet and Access Database and concludes that Access database application is a better alternative …
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER95.4% of users find it useful
Business information for Fly Guys about Excel Spreadsheet and Access Database
Read TextPreview

Extract of sample "Business information for Fly Guys about Excel Spreadsheet and Access Database"

Download file to see previous pages In contrast, the Excel spreadsheets would keep displaying messages about a locked file and this might intimidate the passengers in addition to contributing to time wastage. Thus, Access database application is a better alternative as pertains to the support of the booking operations.
Second, Access database uses structured query languages (SQL) to manipulate records. An even more striking aspect of this future is that the end-user can tailor the queries to suit the business needs. For example, it is possible generating reports based on criteria such as passengers involved in half journeys, passengers involved in full journeys and passengers who are most loyal to Fly Guys. On the other hand, Excel spreadsheets lack such fascinating features. Implicit in this is the point that a business which embraces Excel as an information management tool is likely to be restricted with regards to generating reports that can support business goals. So, MS Access database is better placed to meet the custom report generation needs at Fly Guys.
Another reason why Fly Guys would need to focus on MS Access to address the custom report needs is its scalability and flexibility. In brief, Access can scale well and communicate seamlessly with nearly all other 21st century relational databases via open database connectivity (ODBC) connections. The only prerequisite for this capability is for the involved database administrator to have a thorough knowledge of the Fly Guys-owned MS Access database file.
As Beskeen (2010) puts it, MS Access is a better option when it comes to information storage. In general, the application’s capabilities come in handy when a need arises to store information for a more elaborated time. This aspect suits the operation at Fly Guys because the records handled will inevitably rise. ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Business information for Fly Guys about Excel Spreadsheet and Access Assignment”, n.d.)
Business information for Fly Guys about Excel Spreadsheet and Access Assignment. Retrieved from https://studentshare.org/business/1696305-managing-business-information
(Business Information for Fly Guys about Excel Spreadsheet and Access Assignment)
Business Information for Fly Guys about Excel Spreadsheet and Access Assignment. https://studentshare.org/business/1696305-managing-business-information.
“Business Information for Fly Guys about Excel Spreadsheet and Access Assignment”, n.d. https://studentshare.org/business/1696305-managing-business-information.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Business information for Fly Guys about Excel Spreadsheet and Access Database

Analayze Excel Spreadsheet on Italian Goverment

.... The consumption of durable goods refers to nonperishable goods and goods that last for a period of more than three years, while on the other hand nondurable goods are the goods consumed for perishable goods or other goods that generally last for less than one year. A country’s treasure is the most impacted area within the economy when taking about the bond market (Schaefer, 65). Most economists argue that the most appropriate way in trying to understand the relationship between the bonds and the economy is to think about interest rates as being the cost of money (Taylor, 21). A stronger economy is characterized by high demand of money because greater activity means that there is more of need for cash...
8 Pages(2000 words)Term Paper

Information about the Relational Database Business Paper

...and explaining the entity relationship model, it can be stated that the model comprises of four levels of data views. The first one is the information concerning entities and relationships that exists in the human minds. In explaining about this particular data view, it can be said that the focus is largely on entities and relationship. Basically an entity is a thing which can be specifically identified while relationship is commonly represented as an association of entities. Normally, the information of entities and relationships are present in the level 1 of the entire logical view. The second one is the information structure which focuses on the organization of...
4 Pages(1000 words)Admission/Application Essay

Database Information Systems Management

...over what was done in the past and use it as comparison and reference to make decisions regarding new ventures. Another example how a manager can utilize the information system to help in decision-making is using the database to obtain information about the organization, products or services made or sold. Once again, by having access to all of this information at one time will aid the manager in making decisions that are based on knowledge and the information system can help expedite the manager's time in making solid informed decisions. A manager can use the information system for...
10 Pages(2500 words)Essay

Database vs. Spreadsheet

..., which software MS Access and MS Excel can be used in which situation will be discussed. II. Database and Spreadsheet A spreadsheet is a rectangular table of information. It means for the format used to present bookkeeping ledgers. The most common use of spreadsheets is to manage basic information such as telephone numbers, employee names, financial data, calculations, addresses and many more other things. Spreadsheets can store data but in actual it is not performs that job as easily as a database can perform. In actual, a spreadsheet is not considered...
8 Pages(2000 words)Essay

Financial Applications for Excel Spreadsheet

...Running Head: EXCEL PAYROLL Excel Payroll Time Sheet System Plus Tips and Tricks Excel Payroll Time Sheet System Plus Tips and Tricks One of the more arduous tasks in smaller companies is calculating time sheets, often hand written or in word documents, for payroll. This is especially true for smaller companies without a synchronized time clock computer system. Using some of the versatile functionality of Excel spreadsheets and their capability to link and transfer information from other spreadsheets is certainly a viable solution for this problem. This would work best in a company where all staff members have their...
2 Pages(500 words)Essay

Information Systems (Database Assignment)

...a book, Mr. Russell marks the entry on the card and also writes this in his notebook. He then keeps the card with himself to remind him of the pending books. There is also another notebook which maintains information about the contact details of all the members of the library. Initially, when the number of members used to be less, the existing system ran smoothly and had no flaws. However, as the number of members and the daily transactions increase, there are a few serious problems that Mr. Russell is facing. They are described below: There are no proper records for the books in the shelves. Often members complain that they do not have the facility to search for a particular book, or at least know,...
5 Pages(1250 words)Essay

Microsoft Access Database

...Module Microsoft Access Database Database contains two tables and two forms: suppliers and products. This can be openedor accessed through Microsoft access only. Data are entered either directly or via the forms depending on the accessibility permissions. Products The following is a list of products brands available to customers in our restaurant: i. Afia ii. Cocacola iii. Delmonte iv. Nuvita The above mentioned products are soft drinks produced and supplied by different companies. Each vendor has its unique brands, as for example; Delmonte produce delmonte brand, Afia as well produces Afia brand and so on. The products are supplied to...
2 Pages(500 words)Assignment

Business intelligence and database and information management

...BUSINESS INTELLIGENCE Introduction Business intelligence is a term that describes the tools used in the analysis, consolidation, storage and provision of access to large quantities of data with the aim of assisting users make informed business choice. The tools comprise of theories, processes, methods, architecture and functional technologies that have to do with data management. This means that for the practice of business intelligence to be incorporated in an organization, there needs to be a collection of data otherwise known as a database. A database is any form of operational data collected and...
8 Pages(2000 words)Research Paper

Fly Guys

...day when the aeroplane comes back. The report comprises of three parts 1-3 discussing how spreadsheet and databases can be incorporated in Fly Guys flight booking procedures. Part 1 This section of the report analyses the operations of Fly Guys that fit excel and access operations. Both spreadsheets and databases are essential in the daily functions of many businesses including Aircraft operations. While it is not necessarily essential to select between databases and spreadsheets, they are frequently suited to diverse...
8 Pages(2000 words)Research Paper

Descriptive statistics spreadsheet in Excel including graphs

...Descriptive Statistics QNT/561 Definitions Central Tendency: Mean = average value of data in a set Mode = The value that appears most in a data set. Dispersion: Standard deviation = A measure of variation. Measures average variation of data points from mean of the data set Range = the difference between the largest and smallest values in a set of data Confidence Interval: (data must be normal) The interval within which the mean is expected to fall at a given level of significance. Normal or significantly skewed data: Skewedness value Data is normal if the value is zero or close to zero Data is skewed if the value is significantly different from zero Descriptive Statistics Number of employees Central Tendency: Mean = 26.8... Statistics...
2 Pages(500 words)Statistics Project
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.

Let us find you another Assignment on topic Business information for Fly Guys about Excel Spreadsheet and Access Database for FREE!

Contact Us