• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  • Level: GCSE
  • Subject: ICT
  • Word count: 858

The Role of Alfieri in the play

Extracts from this document...


Design Specification This database is created for Varndean e-Learning so that John Burton can save his customers information on his computer system. Using this database he should be able to get a lot of information about any customer, including address, telephone number and name. User Requirements John Burton wants the system to be able to store customer information, their address, name, telephone number, What they have bought and how much they have bought. He also wants it to be able to print out reports as well, this will help him keep track of what the customers buy and how many customers buy the same product. It also has to be able to produce graphs so that John Burton can compare each product. Information Sources All my information came from the interview with John Burton told me what he would like and what the system has to be able to do. ...read more.


What products were sold and the prices. Processes What was purchased and who purchased what. When the customers bought a product. John Burton also wants to see what profit he's getting and keep track of all that's been sold or returned due to disk failures. Computers or the telephone would pass this information. I would believe System Implementation 1. Create Tables: - enter in values Customer name(set as primary Key), address, telephone number, what product was purchased, how many copies of the product was purchased and data purchased. 2. Create a Query using the simple Query wizard, insert all the available fields. Just click next until you get to the end, at the end click finish. 3. Create a form using the form wizard, select all the options that you want to have for the Form. Select the style you want. You should end up with something like this: 4. ...read more.


Instead of using "number" as the data type, use Text so that you can put in a input mask which will allow you to input the 0 that you cant put in. Like so: I've already set the input mask in, all you have to do is click the button at the side to set the input mask, it will have a wizard which will take you through and then the 0 problem will be solved like so: One of the other problems is creating the graphs in Microsoft Excel. When you save as/Export the form, and open it in Microsoft Excel, when you have create a graph you may find the problem that it has a lot of values which have nothing to do with what you want. I.e. date purchased, address etc, like so: To correct this problem, in the Query section on Microsoft Access, you have to deleted a few values so it ends up like this: Now when you Save as/Export to Excel and make a graph then it should look like this: Database Richard Green ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. Design Section

    what it needs to be like because I have all the things to make it such as Macro's, List boxed, combo boxes, Option buttons, Sliders, Scroll bars, Indexes, Check boxes, and Pivot tables. * What features your solution have - Microsoft Excel will allow me uses the things I need

  2. System requirements analysis

    For example a doctor can only view their patient's history but not another doctor's patient's history. The important files such as patient history and salary are password protected to enter and view and only the receptionist can view them. Research The aim of this research is to compare what inputs are needed in a medical centre and a travel agency.

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