• 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. Computing Project

    unit URentOutaDVD; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, DBCtrls, DB, ADODB, StdCtrls, Grids, DBGrids, Mask,printers, ExtCtrls; type TFMRentOutaDVD = class(TForm) DSFilms: TDataSource; ADOFilms: TADOTable; ADOMembers: TADOTable; DSMembers: TDataSource; dblkcbxdvd: TDBLookupComboBox; dblkcbxmembers: TDBLookupComboBox; DSLoans: TDataSource;

  2. 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

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

    1.6 SUBSEQUENT ACTIVITIES Purpose The component comprises the activities that you must carry out after payroll (gross - net - payroll). 1.6.1 REMUNERATION STATEMENT Purpose The R/3 System lists all the payments and deductions made for an employee in a clear format on the remuneration statement.

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

    A non-generic application, written for one specific purpose, will normally have fewer configuration options because there will be a more limited user base and the tasks that the users will carry out are more clearly defined. Sometimes a customer's software needs cannot be met by an existing package.

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

    Any data processors that a data controller may use for processing their data must be professional enough to guarantee the privacy and security of the data. It is also the data controller's responsibility to ensure that the data processor carries out the processing as specified according to an agreed contract.

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

    research evidence 17/10/00 - Produce two or three database structures and explain strengths and weaknesses 19/10/00 - Choose design that is most suitable and explain the decision 21/10/00 - Explain how the hardware and software available influenced the design 23/10/00 - Obtain views of potential users of my system using

  1. Explain the component parts of a computer system - Include both hardware, software and ...

    Without software the hardware would be useless. A software package is a program or set of programs together with a full set of documentation. Software programs are usually one of two types: Systems programs or applications. Systems programs - A systems program is one of the programs that controls the computer system or provides facilities.

  2. Infernowear is a new company run by a self-employed creative designer aiming to producing ...

    into the current procedures and work practises so that I can find out exactly what the new proposed data base system has to do. Interview with Company Director Mr B Hull: I conducted an interview with Mr Hull to discover in more detail what the current work practises are and what the new system has to do.

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