• 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)

    This is the first step CCTVs do in reducing crime. The fear of being caught on camera stops the crime from happening in the first place. If a crime is captured, then it can be used as evidence in a court case.

  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

    As you can see, the addition in the formula states a specific sheet and cell (a cell on sheet1). This is to prevent confusion within the formula with the cell B16 on the current sheet (sheet7). With this addition in place, the sheet should look like this: Printouts of each report, with screenshots of each worksheet and showing formulas used.

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

    date of issuing the name of the member, ISBN number of book and members ID number. Stationary: the readers card, book card which remains in each book pocket made up of card board until the book is borrowed. PROCESS Books out: * There is a stamp for the blains library

  2. System requirements analysis

    * Patient and insurance company balances displayed in every patient-related view * Budget billing plan specific to the individual patient * Custom fields available for user-defined information * Automatic computation of all managed care data * Easy viewing of managed care issues such as capitation, referral tracking, copayments, number of

  1. Database design.

    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 Output from queries and reports The output from the queries allowed me to create a letter.

  2. Normalisation.Normalisation is a process used to come up with the best possible design for ...

    Screenshots of my database Screenshot 1: Bookings Table Screenshot 2: Courses Table Screenshot 3: Members table Screenshot 4: Tutors table Screenshot 5: Front page Screenshot 6: Student link from front page Screenshot 7: Tutors link from front page Screenshot 8: Bookings link from front page Screenshot 9: Application from for

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