• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Choice of software

Extracts from this document...

Introduction

2.2 Choice of Software In this section I am going to explain the software choices I have made for each task. I compared Microsoft access, Microsoft excel and the current system, to see the advantages of both programs. The following comparison table shows the functions required (taken from 'Desired outcomes and performance criteria') and the software compatibility for each task. Function Approach MS Access MS Excel Current System the system will show all detail of current monthly contract ? ? the system will allow customers details can be added and deleted as necessary ? ? the system will produce a unique customer reference number ? the system will match customer detail with product preference ?? the system will give a running total of profit/loss balance ? ...read more.

Middle

Microsoft access does not have the sum function and would be inappropriate to use for this task. The decision is made to use Microsoft excel for task 1. ? Task 2 - setting up a database to record customer details and to alert when direct debit payments are due from monthly contract customers. From the table Microsoft access is the best option for this task as a lot of information can be stored and data can be input, searched and sorted quickly and easily. The query function is available in Microsoft access but not in Microsoft excel and as this is a vital function, excel will not be suitable for this task. Microsoft access allows different queries to be made using the same parameter. ...read more.

Conclusion

The ability to link databases, to do query searches and to flag up low stock reminders is vital for this task and these functions cannot be managed by Microsoft excel. Microsoft access allows different queries to be made using the same parameter. By inputting different product types into the parameter value box, all the products details for that brand should be flagged up. Microsoft access is reusable and allows data to be carried to other databases and applications (mail merge). The decision is made to use Microsoft access for task 3. ? Current system - paper records. Mail merge - the personal details in the task 2 database and product preference in the task 3 database can be linked together and then linked with mail merge so that Asia Talk can send bulk letters to customers. Customers can be informed of special deals, events or new product releases. This feature is only available with Microsoft access. ?? ?? ?? ?? ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Software essays

  1. Selecting the best software for a theatre business.

    Bob can not calculate how many days that the he has held a particular share. 3. Bob can not put all shares into ranking to compare their performances. 4. Bob can not hold formulas at any point that are able to work.

  2. Reviewing different multimedia presentations.

    right place in the body and rotate so it is right to where it is meant to be. This is a good feature because it is a good educational tool as what it does is it makes you think about where each body part goes in the body.

  1. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    This is a meaningless total, If it does not appear, it means that the numbers or items have not been typed in correctly, or not all the variables had been keyed in and left blank. Control Total -This does the same as the Hash total but has a meaning.

  2. A new IT system in a Dubai Marauders Rugby Football Club

    Database of Members Containing Members' Details and Contacts Microsoft Access A Query of the Database to Find all Adults Who are not Currently in a Team to Create a Barbarian Team Microsoft Access An Enrolment Form for Applicants to Provide Information for the Database Microsoft Word An Accounting Solution for

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    In additional to this, spreadsheets allow the teacher to easily enter student results, instead of having to write them out by hand. Additionally, Excel is a portable application; it can be sent through e-mail, stored on a USB stick or synchronised with PDA's, not only that but Excel can also

  2. AQA GCSE ICT Specification B

    Name, Logo and Address Projected Dispatch Date Customer Title, Initial and Surname Delivery Address Date of Order Order Details Name to be printed on product Projected Dispatch Date = Date of order + two weeks Output 3: List of Customers and Orders Between Two Dates Information on Output Inputs Required

  1. The aim of my project is to make the task of the allocation of ...

    It is also highly flexible in its ability to re-enter data in the event of, for example, the changing of the cost to put on a certain show, which could easily be achieved by simply imputing a new number into the sheet.

  2. Produce a spreadsheet for a successful and potential company

    Investigation and analysis of the problem Belle du jour - Background information Belle du jour is a single business that sells dresses for special occasions. It was first established in 1994 and since the year 2000 they feel that expanding the company will bring a lot of success.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work