• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21

Home Office LTD company. Database

Extracts from this document...

Introduction

Implementation In my workbook for the Home Office LTD company, I have designed seven main sheets: 1. Main menu 2. Customer database 3. Product information 4. Generic order form 5. Discount table 6. Monthly review 7. Yearly review Other sheets can be made from these seven base sheets. This is done by edited the information on the relevant sheet, and then "save as" another name to keep both sheets i.e. monthly review... once January is completed, that sheet is saved as "Jan stats", then the info is deleted off the sheet then figures are entered for February then that is saved as "Feb stats". The same can be done for the generic order form and yearly review. Main menu sheet The purpose of this sheet is simply that is it a directory for the user. From any other sheet in the workbook, with a click of a button (which is on every sheet) the user can go back to the main menu and chose from the buttons which sheet they want to go to. With another click of a button, the user is then taken to the sheet that they selected on the main menu sheet. The purpose of this is so that there is little confusion as possible for the user, as when looking through so many figures, stats and information, the user could easily get confused with what sheet they want an where it is. It works by using six macros to get to other sheets and another six to get back to the main menu. Buttons that go to the sheet as stated on the button In the screen shot above, it shows the worksheet working perfectly. With this sheet, there were no problems at all creating it and the macros involved. In this sheet, there are five macros. These were made by pressing the record macro button, while starting on this page, while recording I clicked on to another sheet and then stopped recording the macro. ...read more.

Middle

the message and highlighted cells. Order Form Sheet The purpose of this sheet is to act as an invoice sheet that can be printed off, sent to customers, and filed away for the firm - if they wish to. In addition, it can be "saved as" another file name so that the generic sheet can be used more than once. The delivery charge, sub total, discount given, grand total and the products automatically appear after the product code is typed. Furthermore, the information from this sheet can be transferred to the customer database by clicking the "Send to database" button. This sheet works out everything for the user and the main purpose is to save time for the user as once the formulas have been programmed the totals and so fourth will be correct as long as the requirements do not change. This screenshot shows all the formulas displayed. The vlookup feature formula is linked to the product information sheet. The table used in the product information sheet allow the user to type in the product code in the A column and with the vlookup formula the price of the product would appear. With the price appearing, I used that cell to multiply with the quantity to work out a subtotal. The subtotal is then multiplied with a discount rate to work out another total. The discount is worked out by using another table (discount table), with same process as vlookup, it allows a figure to be entered and the discount automatically appears. Other formulas like the delivery charge are a standard �10 with additional �1 per mile, which is worked out automatically through another formula in cell D28. The installation is manually entered, if the client wishes. The total adds up the sub total with discount, delivery and installation and then the final price. The final price needs to be entered again in cell D32 as this allows the total to be transferred to the customer database along with the other personal information. ...read more.

Conclusion

Throughout the project, I have used one main piece of software, which is Microsoft Excel. The reason for this is that Excel is a massive calculating, database creating, analytical workbook, which can store thousands of pieces of information and can calculate more sums and information from the original. This programme is perfect for the end user as it has everything that they need. It stores clients, creates sheets with analytical monthly and yearly reviews. The software also has a facility that calculates complicated sums, formulas, percentages and so on without any humans having to work it out themselves, they only need to type in the formula once and the programme will remember it. In the programme, other functions allow the user to do things such as transfer data to one sheet to another with the use of a macro. This once recorded, and then need not be edited unless the sheet is dramatically changed. All of these features help the user have a simple workbook where they can create order forms/invoices, keep track of their stocks, hold a list of all their clients, analyse sales and other figures within the sheet to create graphs and charts. The other programme used in the project was Microsoft Word. This is used for typing up my findings and all the details of the project. In addition, Word can be used for the Home Office LTD company as they can create mail - merged letters. This means they can then send out generically created letters and have the clients name, address, etc all personalised in the letter without having to type it out themselves. All they need to do is link the mail merge to the database in Excel, which has all the relevant information. Another package used for the project is Visual Basic; it is within the Excel package. With Visual Basic, it allows the user to create the many macros used. It was perfect for this project as without it, all of the buttons would have been extremely difficult to produce as easily as with Visual Basic. ?? ?? ?? ?? Tarun Nayyar - Implementation ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Management & Manipulation of Information 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 AS and A Level Management & Manipulation of Information essays

  1. Analysis of market, environmental forces, competitors, marketing mix and consumer implementation.

    This issue was considered to be the reason why PSX achieved quick success and one of Nintendo and Sega failings with their last console launches. The company has content: Sony movies and music. It has hardware: TV sets, PCs and game machines.

  2. ICT Solutions for people with Special Needs.

    The act also set up the National Disability Council to advise the government on discrimination against people with disabilities. Disabled Persons Act 1986 The Disabled Persons Act 1986 strengthens the provisions of the Chronically Sick and Disabled Persons Act 1970 and requires Local Authorities to meet the various needs of disabled people.

  1. Designing a booking system for an Estate Agent.

    The data that the system will need are the details of the client such as names, surnames, addresses, contact details, telephone numbers etc. This would be the same for the negotiator only the system will only require the Negotiators names.

  2. Background and investigation for designing a database for a DVD rental shop.

    We roughly have 250 DVDs in stock. This number fluctuates allot as new DVDs are added and removed. 11. Where do you store your DVDs?

  1. Video World Database as ICT project.

    The amount of time it takes to document a new member. With the manual system it can be very time consuming, just entering data for the new member. The form has no tick boxes and Gary has to write it all in full by hand.

  2. A relative of mine works for a corporate firm on CRM (Customer Relationship Management) ...

    a decision making executive an idea of what every one is suggesting in the market. Current Market talk: What are the problems faced by others in the market? Mack Sorrells, president of the Mack W. Sorrells Company Inc., in Rock Wall, Texas, which represents 15 manufacturers that make tools for

  1. Beanie Project.

    So this section starts with a system validation, which shows whether the data system that has been created is suitable for the system that was outlined in the requirements section. Then, there is a somewhat lengthy section about the actual data system that was designed, how it works, whether it

  2. The purpose of this document is to provide a design for an electronic payment ...

    Implementing using this approach will allow more accurate time estimates and suitable allocation of tasks and makes the whole process easier to intellectually manage. The IEEE has a recommended practice for Software Design Descriptions (SDD) and this will be used as a guide when developing the software system.

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