• 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

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

Extracts from this document...

Introduction

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.

Middle

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.

Conclusion

�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. Control Unit, Memory Unit, and Arithmetic Logic Unit. The CPU or Central Processing ...

    An interrupt is the message which the secondary device can send to the processor which tells the processor that all the data in the buffer has been used up and that it wants some more. The example used here was communication between primary and secondary storage, but the same is

  2. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    The standard system also allows you to enter personal or general notifications for your employees. These are printed on the remuneration statement as additional information. This additional information, for example, general company information or birthday greetings can be entered in the Notifications infotype (0128).

  1. Identify the constituent parts of a total computer system.

    Larger computers such as mainframes operate differently from the simple PC. They can process two or more programs at the same time and may have to deal with many users at the same time. This sort of operation requires very complex operating systems.

  2. Computing Project

    Brief summary of features used Some of the components of Delphi I used were: ADO table Function - This component allowed me to link a specific table in a database in Access to Delphi, which then allowed me to enter details into edit boxes on Delphi which then automatically updated in the tables in Access.

  1. GCSE I.T Security Case Study - Riverside Leisure Centre

    7/Personal data shall not be transferred to a country or territory outside the European Economic Area, unless that country or territory ensures an adequate level of protection for the rights and freedoms of data subjects in relation to the processing of personal data.

  2. Smart Card System

    Each TCP packet contains the starting sequence number of the data in that packet, and the sequence number (called the acknowledgment number) of the last byte received from the remote peer. With this information, a sliding-window protocol is implemented. Forward and reverse sequence numbers are completely independent, and each TCP

  1. With diagrams compare and contrast the relative advantages and disadvantages of digital transmission over ...

    A modem attached to a computer converts digital data to an analogue signal that it uses to modulate a carrier frequency. This frequency is transmitted over a line, frequently as an audio signal over a telephone line, to another modem that converts it back into a copy of the original data.

  2. System I designed in order to produce a promotion package for her newly formed ...

    9/10/00 - Find out, and analyse the views of, potential users of mail order services and CD shops 11/10/00 - Use an analysis of my completed questionnaires etc justify my design specification. This should include statements about structure, ease of use, quality of user documentation, types of output and presentation

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