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

    The problem with this though is that it will take up a lot of space whereas if you keep it saved on the computer it wont take up much space at all. You could use notepad to write out the memos and design it.

  2. GCSE Excel Project ICT

    'Customer' View Sheet 5 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 7 Black and White Formula View 'Customer' View Printout Report Evidence that each test in the test plan was carried out

  1. Hardware & Software Requirements for Database

    that my data base does not require more use of space as the hospitals have to use this space for other information. ==> A Random access memory (usually known by its acronym, RAM) is a type of data storage used in computers.

  2. a level ict project

    Validation Method Date employed Must be a date in the year 2003 Input mask that only allows long dates between 01/01/03 to 01/01/04 House Name The number must be less than 400 Validation rule set to permit numbers below

  1. Access Database

    What do you think of the layout of my hand drawn plans? 5. Is the colour combination used good, is the style of the page good? 6. Overall, what do you think of the hand drawn plans, should I redo do them, or keep it as it is? 7.

  2. System requirements analysis

    patient and/or guarantor name, date of birth, social security number, phone number, insurance policy number, account number, transaction number, medical record number, and user-definable fields * Procedure and diagnosis code tracking with auto recall for immunizations, mammography, annual check up, etc.

  1. Creating a computer system for a video rental shop

    Water such as flooding; computers must not be placed in lower levels or in basement Heat, dust, etc. Work place must maintain good ventilation and also maintain good cleaning guidelines Good Management measures include: * Maintaining and inventory of departmental computer equipment.

  2. Brainstorm of the places where we use computers

    mail merge, spread sheet formulas Word Processing > Microsoft Word: This programs enables you to Do Fax template documents, Invoices and basics such as Letters Presentation Software > Microsoft PowerPoint: PowerPoint presentations allow students to present class to their class on an interactive board.

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