• 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

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

    4 star(s)

    out you can rub the pencil out and write in the text. The problem here is that the rubbed out work can look messy and unprofessional. A non ICT solution for storing the documents is that you could store all of these documents in a closet or in a filing cabinet instead of the computers memory.

  2. Hardware & Software Requirements for Database

    The costs involved are in varies of prices depending on the size of the memory. If the hospital computers contain a RAM of 256 MB then they would need to buy a extra 256 MB for my database but if they have more then that then they could run my database very effectively.

  1. Financial Model to help organise the year eleven prom

    I used Bell MT for extra information and Arial for headings, to make these stand out from the rest. The sizes of these fonts also have an affect on the appearance the heading fonts were the largest at size 14, then I just worked my way down.

  2. Standalone vs networked computers

    the short run it is costly * Viruses can be spread more easily and quickly to every computer on the network, whereas if it happened to a standalone computer only one would be affected SYNOPSIS Overall, the advantages to your small business of creating a network far outweigh the advantages of keeping the machines standalone.

  1. ICT PROJECT

    Try to delete macro buttons and move them around the sheet on the front end menu To verify sheet protection works correctly User should not be able to move the buttons or type ink text Date of Birth The column of cells will be formatted in the data format, dd/mm/yy

  2. Creating a computer system for a video rental shop

    The degree of the relationship will come under one of three categories: 1. One-to-one, e.g. relationship between Person and National Insurance number which is unique to every person. 2. One -to-many, e.g. relationship between Customer and Order. 3. Many-to-many, relationship between Customer and video System Design Top Down Design A

  1. GCSE Excel Project ICT

    As normally when the reference cell is moved any formulae linked to the cell gets re-written to accommodate the movement, if it's the formula that is moved then the reference is changed but maintains its position relative to the formula cell.

  2. Database design.

    Number 3 >000< No Rent_Customer_ID Customer ID number Number 6 Foreign No Rent_Video_ID Video ID Number Number 4 Foreign >9999< No Rent_date_out Date Of Video Rented out Date __/__/__ No Rent_date_returned Date of video returned Date __/__/__ No Table Customer Entity Types Description Data type Length Key Validation Input Masks

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