• 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
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17

Setting up a database for a shop selling P.C.'s.

Extracts from this document...


Specification Analysis This computer company is based on the choosing of the customers of which specific parts needed and will be delivered within a week (just log on to our e mail, phone e.t.c). It has been put on-line and can be also be visited in stores worldwide. The biggest store is in Birmingham. Currently my uncle runs the store called tiny and specialises in selling 'Pc computers'. However for external features specific cases can be designed to determine the best result. In this case black/silver grey is very well contrast of colours for a computer. I will use design templates to experiment with the appearance and ask various people what they think using questionnaires and interviews picking people randomly. Personal computers are a collection of parts assembled together in the correct position. The parts only function when everything is installed and each part contributes to the motherboard. Additionally the computer is the CPU covered with a casing. Judging by the necessity of the project there needs to be updates regularly and current sales of the prices due to special celebrations such as Christmas. Also the monitor needs to be taken into consideration because the customer who is going to buy this product needs to be able to have a matching casing and a reasonable sized monitor influenced by health and safety. Causes stress on the eyes, flickering of the screen, dizziness, headache and even the eye hurting since a long period of computer usage. Accessories are also needed i.e. the input such as the mouse (mouse pad for comfort), keyboard, speakers, scanner, printer and graphical user interface. Adjustable chair to prevent back strain, high quality screen to prevent eyestrain leading to stress and RSI. Ergonomic keyboard to prevent wrist strain. Foot rest to prevent back pain and change in working patterns to allow change in muscles and cause less stress and RSI. ...read more.


and uses up less electricity is replacing the pictures by finding a similar picture on the internet and text and be re-typed which doesn't take long. If there is a lot of text or for another reason go to a public place that has the facility of a scanner or even visit a family or friend. Is an alternative method and proved inexpensive. Printer ? File or document can be saved on disk or sent via e-mail from one computer (no printer) to another computer, which has the facility to print (can be retrieved when logged on to a computer which is attached to a printer). E-mail can be prioritised to denote importance to the symbol by marking the symbol on the work. Found either in public places e.g. Internet Caf� or go to family and friends, saved on disk using the disk drive. Is an alternative method and proved inexpensive. DVD ? Specially designed to watch movies on computer or listen to music, which is only used for leisure activities and is not relevant. Re-writer ? Re-writer drive can copy CD's illegally if it has been labelled as copyright and to exclude this piece of technology would decrease the rate of illegal activity and prevent people from breaking the data protection act called software piracy. Also used to make a back up of saved work but a disk can carry out same function. Digital camera Can be used for Sending pictures to ? Used to send graphical pictures to a recipient, which is mostly used for leisure activities and can use chat lines or internet. Also used for businesses but is a very expensive piece of technology. Video conferencing Very costly and both parties need ? Both members need specialist equipment to communicate and this proves the method is costly. Other methods of communication such as the internet using chat lines or e-mail where you can send or receive e-mails. ...read more.


�896.09 is returned in C16 18 Test Vlookup in in C21 returns correct values from the computer worksheet Type PC returned in C21 Entering the total cost for computer parts 19 Test the prices are looked correctly from the table contaning computer parts. Select Company i.e Tiny 84643 C21 should return to �896.09 Calculating the total cost of the Quote: 20 Test the formula C16 Data for test 19 above Bill worked out on spreadsheet using autosum i.e �896.09 Automating the filing of quotes: 21 Test the macro where no data is entered No data entered Warning sign should appear 22 Shortcut key for entering data e.g. date Date, company name, address of company Fast method of input preventing re-typing Clearing the current screen to enter a new quote 23 Test macro 'clear screen' after using spreadsheet Whole of quotes spreadsheet Screen should be clear 24 Test macro 'clear screen' after quoets been filled Forename, surname, Address 1, Adress2 and postcode Screen should be clear Printing the Qoute 25 Test details are taken from the quotes sheet to the pinted quote worksheet sheet Computer parts and details Details display correctly on the pinted quote worksheet Adding the user options 26 Test Pint Quote Test macro button Print Quote 27 Test links to other worksheet Test Macro button Be able to switch to chosen sheet and back to quotes worksheet Customerising the interface and finishing touches 28 Test the auto-open macro sarts the systerm correctly Starts the system System loads and removes Excel stranmdard features 29 Test the auto-open macro closes the systerm correctly Close the system down System closes Excel stranmdard features Add the front end and further options 30 Test the help button None, test macro button On screen help messages given 31 Test the auto-open again macro sarts the systerm correctly Start the system up System loads up front page. 32 Test the exit macro button None, test macro button System closes down User testing 33 Install the system in the officw at Tin for a week for Reek and his employees and see if it meets his requirements. ...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 Computer Science 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 Computer Science essays

  1. Peer reviewed

    HCI shortened for Human Computer Interaction is the study of the human and computer ...

    3 star(s)

    in order for it to be used for both right and left handed users. As this is important that designer should not rely on the user always inputting data or using the mouse using preferred hands. Information processing; Information processing is basically how information is processed and the speeds and

  2. Computing Project

    begin//begin adofilms.Open;//open adofilms adofilms.last; dvdid:=adofilms['dvdid'];// insert the value of the variable dvdid into the field DVDID in the access table end; DVDid:=DVDid+1;//add 1 to whatever value the variable DVDID is ADOFilms.Append; ADOFilms ['DVDId']:=DVDid;//insert the value of the variable dvdid into the field DVDID in the access table ADOFilms ['filmtitle']:=LblEdFilmTitle.Text;//whatever is

  1. System Analysis The aim of the Jewellery store system is to make the work ...

    THREE VIEW OF THE SYSTEM Logical data models (LDM) Logical data models represent the abstract structure of some domain of information. They are often diagrammatic in nature and are most typically used in business processes that seek to capture things of importance to an organization and how they relate to one another.

  2. Computer Maintainance - anti-virus, cookie deletion, drive scanning

    Then click on the "Clear browsing data" button. Click on the Close button when you've finished. To remove cookies in Internet Explorer 8: Click "Safety" on the Command bar Select "Delete Browsing History" Select the option for cookies and click Delete.

  1. Evalutation of a Spreadsheet

    This is done by limiting the range of data that can be entered into a cell. This is beneficial because it would decrease the likelihood of errors being made, and could even help minimise the risk of fraud.

  2. Introduction of Communication

    Advantages It is often less time-consuming to send a text message than to make a phone call or send an e-mail. SMS can be used to send a message to a large number of people at a time, either from a list of contacts.

  1. Explain the different techniques of gathering information to answer an IT Technical problem or ...

    This would mean that Microsoft, Cisco, IBM IT Technical Support would be very efficient as in the amount of work completed perhaps because they are company orientated. Work pressure This would depend on the type of company it is. If it is a very big company like Microsoft the work

  2. Implementing New Technology In To A Business

    Organisations must be careful when moving staff to different jobs that they do not want as they might not have the skills to do their job. Employees Some employees do not adapt to change easily, some staff might have to be moved to roles they do not like and not have the skill they need to carry out the job.

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