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

  2. Creating a computer system for a video rental shop

    Tables Video table Borrowing table Member table reservation table Queries Video query videos out Request Reservation Fine Notification Full details Forms Full details form Borrowing form Member form reservation form Reservation form Transaction form Video form Full menu form Full details Review reports Printing reports Opening forms Reports Overdue and

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

  2. ICT PROJECT

    Uncheck the gridlines, row and column headings, sheet tabs, scroll bars Uncheck the formula bar and status bar and click ok Select A1 'mcrAuto_Close' Click tool, options Uncheck the gridlines, row and column headings, sheet tabs, scroll bars Uncheck the formula bar and status bar and click ok Select A1

  1. Computer project Alevels

    * DOCTOR DETAILS When you click on the button "DOCTOR DETAILS" under the section member details on the MAIN MENU a screen appears as shown below. This contains all the information about the all the registered doctors You can also select the queries under 'QUICK REFERENCE" section of the MAIN MENU.

  2. GCSE Excel Project ICT

    Now, click enter on the cell and check the value within: This is not the value we wanted, this is because the active formula within the cell was: =VLOOKUP($D$4,Shells,1). The logical assumption would be an error in the properties of the formula, which would be the correct assumption the specific

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