Nobody downloaded yet

MS Excel and Access in Financial Calculations of Business Operations - Coursework Example

Comments (0) Cite this document
Summary
The purpose of this paper is to analyze the Microsoft Excel and Acess tools in terms of business financial calculations. As is evident from the discussion presented, all the requirements can be implemented using both MS Access and MS Excel, however, a few issues shall be noted…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER94.1% of users find it useful
MS Excel and Access in Financial Calculations of Business Operations
Read TextPreview

Extract of sample "MS Excel and Access in Financial Calculations of Business Operations"

Download file to see previous pages As for the customer records, the basic information is necessary which includes
Reward system is a marketing method devised by Flyguys to facilitate and attract the customer. The system that is proposed is required to cater to its requirements. The system should keep track of how many partial journeys or full journey a particular customer has made and whether they are eligible for a reward, 50% discount on their next respective flight. The system is required to implement this discount on the next booking which means a connection with bookings record is necessary (FLIGHT MANAGEMENT COMPUTER, 2015). Moreover, the system should reset the count as well or another method could use the mod function to find how many flights shall be counted for a discount for a certain customer.
The third and quite important requirement by Flyguys is reporting mechanism. This is an extremely important aspect of any business so that it can study, analyze and tune its working (Couch, 2013). This is also important in terms of bureaucratic and policy matter within the company and to keep at par with the external environment (Couch, 2013). The reports feature, combined with carefully constructed queries, in MS Access is of special importance here. This also leaves the Excel’s filters and reporting methods far behind in terms of efficiency and ease of use.
A workbook titled “Customers” is used to hold records and lookup functions are used to access and modify the contents where necessary. Filters can be used to create reports of specific records (McFedries, 2013). ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
  • CHICAGO
(MS Excel and Access in Financial Calculations of Business Operations Coursework - 1, n.d.)
MS Excel and Access in Financial Calculations of Business Operations Coursework - 1. Retrieved from https://studentshare.org/information-technology/1878133-fly-guys-report
(MS Excel and Access in Financial Calculations of Business Operations Coursework - 1)
MS Excel and Access in Financial Calculations of Business Operations Coursework - 1. https://studentshare.org/information-technology/1878133-fly-guys-report.
“MS Excel and Access in Financial Calculations of Business Operations Coursework - 1”, n.d. https://studentshare.org/information-technology/1878133-fly-guys-report.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF MS Excel and Access in Financial Calculations of Business Operations

Calculations

...and liabilities of business. Balance sheet cannot account for both cash outflows and cash inflows. Another importance of statement of cash flow is that it shows how efficient an organization is able to generate income (cash inflows) from its operation (Baker 2005). Other financial statements such as balance sheet which only shows assets and liabilities of business but cannot show shows how efficient an organization is able to generate income (cash inflows) from its operation (Philips 2008). Another importance of cash to those whose use it is that it is a report of funds that have been used during a specific period of time for various...
6 Pages(1500 words)Assignment

Dissertation (Distance Learning Of MS Access)

...of the most prominent areas of education and learning, where the application of the technology is at its peak. Furthermore, the more technology is applied in right direction, the more distance learning will get popular. This project would be yet another step into that progress. Purpose The outcome of this project would be an MS-Access based Tutorial database. As tutorials are major source of learning for distance learners, thus this product will be helpful to them to a great extent. The aim of this project is to develop a database of tutorials for the distant learners. This database tutorial is a web-based tutorial. The user of this database will be provided with the user interface in order to fetch...
8 Pages(2000 words)Essay

MS Excel

...1. Describe ways in which the use of MS Excel as a tool for interpreting data can be used by a manager of an organization. Microsoft Excel is a toolthat the various members of an organization utilize for various purposes and reasons. Among the most prominent users of Excel are the managers who happen to serve as the decision-makers in the firm. These people gain the most from the numerous tools that the software offers its users. Managers can utilize Excel in several ways and for several scenarios as well. Primarily though, the spreadsheet is most valuable when managers ponder on and engage in the decision making process. Its value lies in the fact that...
2 Pages(500 words)Essay

MS-Access and Net framework

... MS-Access and .Net framework MS Access is one among the widely used database. It is used to develop database and maintain them in a hassle free manner. Since the operations in Access is simple, it is considered to be a user friendly database. Access can manage more number of records and those data can be accessed easily. The data stored in Access can be sorted according to the developer's requirements. Apart from sorting filtering is also possible using Access database. Sorting and filtering can be done with much accuracy and effective report generation. These operations can be performed with the use of specialized tools that have been included in MS Access 2007. Access can maintain large database very effectively. The data can... be...
6 Pages(1500 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 own computer terminal and are...
2 Pages(500 words)Essay

Financial services for corporate clients ( Financial analysis + financial calculations)

...the averages since these are the most representative figures for the Gulf Trading Corporation. The company had upper hand over some ratios in profitability and efficiency while it was lagging behind in some of the ratios. Overall, the company has met the industry standards while operating in the tough business environment. PART 2) Common Size Income Statement for Gulf Trading Company   2010 2009       Net Sales 100.00% 100.00% Cost of Sales 70.92% 72.75% Gross Profit 29.08% 27.25% Operating Expenses Distribution 2.77% 1.89% Research & Development 0.82% 0.56% Selling and Administrative 12.34% 13.53% Total Expenses 15.94% 15.97% Operating Income 13.14% 11.28% Interest...
5 Pages(1250 words)Speech or Presentation

Financial questions and calculations

...BASEL Norms - Assignment [School] Number] September BASEL Norms - Assignment a) The two major risk categories dealt with under the Basel 1 Accord were credit risk and market risk. b) Basel 2 includes operational risk c) Tier 3 capital protects against market risk. d) Tier 3 capital will be eliminated because of Tier 3 capital was unsecured subordinated debt and net interim trading book profits. This capital turned out to be dud capital during the financial crisis as the profits which were booked temporarily to cover market risk turned out to be loses. e) January 1, 2019 (Committee) f) Proposals for the Basel 3 Accord include minimum capital requirements. By January 2015, common equity Tier 1 capital...
4 Pages(1000 words)Speech or Presentation

Programming MS Excel to freeze panes

...Programming MS Excel to freeze panes Insert Insert Introduction Freezing panes is the process whereby a section of the worksheet remains constant while you are scrolling other sections of the same worksheet. Freezing panes facilitates the locking of these rows or columns (Johnson, 2007. The aim is to keep particular columns or rows visible when scrolling. To freeze the top row containing headings, you need to select the row then click on menu view. You then select freeze top menu under the submenu freeze panes. Meanwhile, to freeze a number of rows, select the rows then under the freeze panes submenu, you select freeze panes. The same applies to when applying to more than one column. However, to implement...
1 Pages(250 words)Article

Excel

...is considered, then S & P 500 is a better company to invest in. Mean and median are two types of averages and are the most common. Mean is the average which is realized when you add up all the numbers and then divide by the count of the numbers, in this case after calculating the mean value for each of the firms, we realized the following data outputs, Abbots Laboratories 34.51503, Unilever realized a mean of 37.05433 while S & P500 realized a mean of 1654.891. The median is the middle value in the list of various numbers, to obtain median the numbers are listed in numerical order, after calculations we realized the following data, Abbotts Laboratory a median of 34.75, Unilever realized a median of...
11 Pages(2750 words)Essay

Report* NEED sensitivity analysis(MS Excel data tables) and break-even analysis(MS Excel Solver or Goal seek)

..., (2015). Our Instant Build Pricing Calculator. [online] Available at: http://www.grannyflatapprovals.com.au/instant-granny-flat-prices [Accessed 16 May 2015]. Properties.mitula.com.au, (2015). Mitula Homes, Homes For Rent And For Sale In Australia. [online] Available at: http://properties.mitula.com.au [Accessed 16 May 2015]. Flatmates.com.au, (2015). West Pennant Hills Granny Flats for Rent, NSW 2125 - Flatmates.com.au. [online] Available at: https://flatmates.com.au/granny-flats/2125/west-pennant-hills [Accessed 16 May 2015]. Question 6/7/8: Gittins, R. (2012). Cash rate is dominant despite what banks say. [online] The Sydney Morning Herald. Available at:...
2 Pages(500 words)Essay
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 Coursework on topic MS Excel and Access in Financial Calculations of Business Operations for FREE!

Contact Us