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

Constraints; input processing and output table for Computer Creations

Extracts from this document...

Introduction

Constraints For the system to be well used, the user must have IT skills in knowing how to control different types of commands made on spreadsheets. If the employee, who has to use the systems, has no IT skills, they need detailed training to make sure that they know fully well how to use the system. They need training on how to enter data using the macros. If the employee uses the wrong command button at the wrong time, the data entered is likely to get lost or deleted. Also, if the system is used in a different way from how it is instructed, there is a possible chance that the layout and the designs will completely change. Input, process and output of the new system Worksheet Description of data required Data source, collection and timing Method of data input Data processing Data output Data sheet- where all the details of the products are stored:- Computers, laptops, hardware, software and the price of each product. - 8 computer brands with their prices - 5 laptop brands with their prices - 6 hardware with their prices - 4 software with their prices These data will be provided by the manager of the company. The information of all the products will be entered using the keyboard. The font used on the sheet is Arial with the font size 10 and the colour is grey. ...read more.

Middle

sheet - A command button 'View Quote' which will open a userform, displaying all the details from the page, and will also allow the user to print out the quote. The data which can be changed on this sheet is the product's prices. The user has to choose an option from the drop down list. Once an option is chosen from the drop down list, the price of the item will automatically appear. The macro 'View Quote', loads the userform, showing all the details on the page and on this userform, there will be a command button which once pressed will load the printing options. Invoice sheet- shows all the customer details with their desired products. Also shows the total price of all the products (with or without the VAT) Data needed are of the products:- - Computer with catalogue number and price - Laptop with catalogue number and price - Hardware with catalogue number and price - Software with catalogue number and price All the data on this sheet will come from the data sheet This sheet shows the product details, the subtotal, total price and the customer details. The data will entered using a keyboard and a mouse. The date will be shown in the cell I5. It will automatically update itself as it has the following formula =NOW(). ...read more.

Conclusion

The font of the main title is Lucida Calligraphy. This sheet will store the details directly from the invoice sheet, therefore the following text should be entered:- - Invoice number in cell A4- this column (A) should store all the customer invoice numbers - Customer name in cell B4- - this column (B) should store all the customer's name - Address 1 in cell C4 and Address 2 in cell D4 - these columns (C and D) should store all the customer's address lines - Post Code in cell E4- this column (E) should store all the customer's post code - Telephone number in cell F4- this column (F) should store all the customer's telephone number - Total price in cell G4- this column (G) should store the total money spend by the customer. The macros on this page are:- - The computer logo which takes the user to the main menu - A command button 'Data' which will take the user to the data sheet - A command button 'Quote' which will take the user to the quote sheet - A command button 'Invoice' which will take the user to the invoice sheet There is no changes that is needed to be made in this sheet There is no output data on this sheet ?? ?? ?? ?? Rebecca Gracian ...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 Information Systems and Communication 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 Information Systems and Communication essays

  1. Marked by a teacher

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    These will be separated into quantitative and qualitative objectives. Quantitative Objectives * System will hold details of customers; * A new customer can be entered into the system in less than 2 minutes; * Customer records can be located in less than 10 seconds; * System will automatically identify customers

  2. The data Processing Cycle and processing methods

    Sorting data Sorting data is not necessary but it keeps the company more organised. For example in the payroll department the employee who as the lowest record number will be listed at the start of the database, and the employee with the highest employee number will be listed at the bottom of the database.

  1. Communication and Employability Skills for IT

    Toleration is especially important in team work. In some aspects of a job employees may need to show no actions of tolerance to members who are of greater authority. An example of this may be an employee jeopardising other works of employee's as they do not meet deadlines.

  2. Installing and Upgrading Software

    make the chance of an accident occurring as low as possible. It is usually impossible to remove risks entirely. Risk assessments should cover all kinds of hazards but where employees are using computers; the health and safety regulations apply. Under the regulations user have to do following: Analyse workstations and assess and reduce risks.

  1. Applications and Extensions - Computer Experience.

    The Millennium Bug Although it is called 'The Millennium Bug' it is not a virus, you can't catch it and it certainly doesn't creep around at the bottom of your garden. Quite simply it is the name given to what happens when computers and electronic systems can't recognise the year

  2. Custom Load Trucking

    A budget has been set at �50,000 and the project will have to be completed between 12th November 2007 and 25th January 2008. A total of 10 hours a week should be spent on the project. 2.2 Problem Custom Load Trucking is a nationwide trucking firm that specialises in rapid movement of high-technology equipment.

  1. Business and Information Technology, What are the input, processing and output of UPS package ...

    The company spends more than $1 billion into technology and systems to keep a high level of customer service. Use of scan-able barcode attached with every single package has reduced the time and labor to find the useful information about it.

  2. Communication & Employability Skills for IT. OCR Cambridge Technicals Unit 1 LO1-P1

    Integrity- Here the employee must obey and follow the laws and procedures of the workplace, such as fire procedures. This also includes a sense of trust between the employee and the employers, they must know that the employee will not be inappropriate and get influenced badly by others.

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