• 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
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  • Level: GCSE
  • Subject: ICT
  • Word count: 3861

E.J.Computers - Introduce an Access database to help make the job of keeping the accounts work easier.

Extracts from this document...

Introduction

Specification - Analysis 3 Introduction 3 Statement of problem 3 Results from questionnaire 4 Information about end user's computer 4 Description of the previous system 5 Input of the previous system 5 Process of the previous system 5 Output of the previous system 5 Data Flow Diagram of the previous system 5 Main problems with the previous system 6 Suggested solutions Error! Bookmark not defined. Objectives of the new system 8 How the objectives will be fulfilled 8 Description of the new system 9 Input of the new system 9 Process of the new system 9 Output of the new system 9 Performance criteria and limitations of the proposed system 9 Qualitative 9 Quantitative 10 Software and Hardware considerations 11 Data security of the new system 12 Use of passwords 12 Differences and similarities between the current system and the proposed ICT solution 13 Specification - Design 14 Possible solutions 14 Reasons and justifications for final choice of software and hardware 14 Outputs required by the end user 15 Inputs and stored data needed to create the outputs 15 Processes that are required to produce the required outputs 16 Knowledge and ability to use advanced package features 16 Relationships 16 Table structures Error! Bookmark not defined. Validation procedures 17 Layout of screens and reports required as output 20 Reports 20 Proposed Test Plan 20 Implementation 20 Testing 25 Evaluation 25 Evaluation Criteria and Success criteria 25 Performance Indicators 25 Limitations 26 User Guide 26 The user guide 26 Technical guide 26 Installation 26 Backup 26 Trouble shooting 26 # AS ICT Project Specification - Analysis Introduction The company I am going to be doing my project on is a small firm named E.J Computers. The company have been around for about a year and a half now and have 3 staff. It's run from a small shop, which they have just recently moved to and they are slowly expanding. ...read more.

Middle

This will make it easier for the end user, so that if he gets a customer asking about certain products that are on sale he can easily do a quick sort and be able to tell the customer. Quantitative With the solution I have made my end-user will be able to find the following: * Begin using the database within 30 seconds of opening it. * Find a customer using name or ID within 15 seconds. * Find a certain product with information within 20 seconds. * Find out if there re any deliveries that need to be made within 20 seconds. System flow chart Software and Hardware considerations Hardware The hardware that I will be using to create my database is as follows: Computer system: 1.0Gghz Celeron Processor 256mb SD RAM 20gb HDD Internal AGP SiS 8.0mb GFX card 15" Cathode Ray Tube (CRT) monitor - Sufficient size display so I can easily see what I am doing. Keyboard - Standard RM keyboard enabling me to get the job done. Mouse - 3 button Key Mouse to make selecting options easier. Laser Printer - Printout copies of the work I am doing to take to my end-user to make sure it suits his needs accordingly. Some of my project will have to be completed at home in my own time on my own computer; my own computer consists of: AMD Athlon XP 1700+ 768mb DDR PC2700 RAM 40gb HDD NVIDIA Geforce4Ti 4800 SE Creative Sound Blaster 5.1 Microsoft Intellimouse Explorer 3.0 Optical (USB) Logitech Internet Navigator(tm) Keyboard Special Edition - Black Software The software that I will be using to create my database is as follows: Microsoft Windows 98 SE Operating System Microsoft Windows NT Network Microsoft Office 2000: Word Access - Mainly using access because it enables me to perform complex searches, have a splash screen and create an advanced database system. ...read more.

Conclusion

Layout of screens and reports required as output Reports Proposed Test Plan Implementation Tables Overview of tables Here are all of the tables in my database. Components Table This table consists of the entire components on sale at E.J. Computers. Design View (components table) Here is my components table in design view. The fields of this table consist of Product ID, Type of Components, Name of Component, Price, Number of Components in Stock, and Description. It also consists of a primary key, which is the product ID. There is also a presence check for the Name of Components field and the Price field. Customer Details Table Design View (Customer Details) This is my Customer Details table in design view; it consists of 9 fields, which are Customer ID, First Name, Surname, Address 1, Address 2, Town, County, Postcode, and Telephone number. Customer ID is my Primary Key and its data type is auto number, the rest of the fields in this table are text fields. Systems Table This is the systems table; this table contains product information on every system for sale at E.J. Computers. Design View (Systems Table) Here is my systems table in design view; it consists of 6 fields, which are, System ID, Type of System, Name of System, Price, Number of Systems in stock, and Description. The System ID field is also the Primary Key for the table. Orders Table Here is my orders table; this table is designed to store all orders that are placed for E.J. Computers so they can keep records of outgoing orders and see which need delivery. Design View (Orders Table) Here is what my Orders table looks like in design view; it consists of 5 fields, which are Orders, Customer ID, Product ID, System ID, and Delivery. The Orders field is the Primary Key. This table was designed so that E.J Computers can keep track of outgoing orders Testing Evaluation Evaluation Criteria and Success criteria Performance Indicators Limitations User Guide The user guide Technical guide Installation Backup Trouble shooting Ross Diaz AQA GCE As ICT Project Page 1 of 26 ...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. Marked by a teacher

    The impact of ICT on the local community. I live in the borough of ...

    4 star(s)

    any current events happening in the borough How it fails to meet the community's needs The website does not necessarily have any disadvantages. But it does need an internet access which a lot of people still don't have or know how to use.

  2. Marked by a teacher

    Planning- design a memo, letter and webpage for Capital FM.

    4 star(s)

    A non ICT solution for the memo is that you could draw it out and where the macro fill-in fields are meant to be, you can in pencil write whatever the fill-in field is, for example "write name here". Then when you come back to the document to fill it

  1. Hardware & Software Requirements for Database

    The costs price for a 256 MB of RAM is about �15 onwards which is not so expensive, as it will benefit the hospital in many other ways then just for my database. ==> A video card, (also referred to as a graphics accelerator card, display adapter, graphics card, and

  2. GCSE Excel Project ICT

    Sheet 6 Black and White Formula View There are not any formulae on this page, so there will be no reason to show it. 'Customer' View Sheet 1 Black and White Formula View 'Customer' View Sheet 2 Black and White Formula View There are not any formulae on this page, so there will be no reason to show it.

  1. Creating a computer system for a video rental shop

    top down design is the technique of cutting down and simplifying a complicated problem into the major tasks which need to be completed and then cutting down the major tasks into modules. It is mainly used in programming but the principle can be used to help design my system.

  2. This project is designed to help non-computerized library to easily keep track of their ...

    * Book card in the reader's card filed in the tray, under the due date for return. DIAGRAM ILLUSTRATING THIS PROCESS Books in: * Books returned on the due date. Due date checked, book card sought under correct date from the issuing tray, retrieved with readers card reads card returns * Book card replaced in book's pocket.

  1. ICT PROJECT

    Select enter mark sheet Select A1 'mcrViewReportSummary' Go pivot table B Refresh data Select cell A1 'mcrViewparentReport' Go pivot table B Refresh data Select cell A1 'mcrReturn' Hide user form 1 Return to main menu Select A1 'mcrCencel' Hide userform1 Reture to main menu Select A1 'mcrAuto_Open' Click tool, options

  2. System requirements analysis

    with the software, you would have to contact a technician to sort out the problem. 3. MedicsElite(tm) (http://www.adsc.com/medicselite.asp) Here is an example of a successful American booking software that could be used by Howard health centre. It has many features, these include: (Quotes from website- http://www.adsc.com/me_details.asp)

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