• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1426

Choice of software - I have decided to construct the system on Microsoft Access.

Extracts from this document...

Introduction

DESIGN Choice of software I have decided to construct the system on Microsoft Access. The software allows easy use and enables data and information to be presented in a clear straight forward way. This is due to a number of features contained within Access. By utilising some of these features, I will be able to construct a system, which is easy to understand as well as being user friendly. Access will allow me to construct tables by which data and information is recorded through the use of forms. This will allow the user to record data with the greatest of ease. There are a number of other key features, which will be used to construct the appointment system. These are as follows; * Macros: These will allow me to automatically execute an operation at the click of a button. * Queries: These provide an easy way of asking questions of the database and getting it to produce useful and relevant information to those questions. * Reports: This is a way of presenting data on the screen or in print format, for example generating a report on the progress of a job. * Protection: This feature will enable me to protect the system from unauthorised access to data and information stored on the system. * Data validation: This will help the user to enter the correct information at certain locations. ...read more.

Middle

Output data The output data is the data that is retrieved after the processing. The output data is as follows: * An appointment for the client. * The day and time of the appointment for the client. This can be printed out on request. * The clients details stored on the database for the garages reference. Normalisation of data Un-normalised form (0NF) CLIENT (ClientID, Title, Surname, Forename, Address1, Address2, Adress3, Address4, Telephonenumber) Repeating data (Jobnumber, servicetype, MechanicID, Title, Surnamne, Forename, Address1, Address2, Address3, Address4, Homenumber, Mobilenumber, appointmentdate, starttime, finishingtime, cost) First Normal Form (1NF) CLIENT (ClientID, Title, Surname, Forename, Address1, Address2, Adress3, Address4, Telephonenumber) APPOINTMENT (Jobnumber, servicetype, MechanicID, Title, Surnamne, Forename, Address1, Address2, Address3, Address4, Homenumber, Mobilenumber, appointmentdate, starttime, finishingtime, cost) Second Normal Form (2NF) CLIENT (ClientID, Title, Surname, Forename, Address1, Address2, Adress3, Address4, Telephonenumber) MECHANIC (MechanicID, Title, Surnamne, Forename, Address1, Address2, Address3, Address4, Homenumber, Mobilenumber) APPOINTMENT (Jobnumber, servicetype, MechanicID, ClientID, appointmentdate, starttime, finishingtime, cost) Third Normal Form (3NF) CLIENT (ClientID, Title, Surname, Forename, Address1, Address2, Adress3, Address4, Telephonenumber) MECHANIC (MechanicID, Title, Surnamne, Forename, Address1, Address2, Address3, Address4, Homenumber, Mobilenumber) SERVICE (servicetype, cost) APPOINTMENT (Jobnumber, servicetype, MechanicID, ClientID, appointmentdate, starttime, finishingtime, cost) Security The appointment system will be protected via the protection feature of Access. There is a password option, which will not be activated once the system is completely constructed. ...read more.

Conclusion

Addres4 Text Customer address4 50 General text No Telephone number Text Customer telephone number 50 General text Customer table Primary key Field name Data type Description Field size Format Input mask Default value Validation rule Validation text Yes MechanicID Autonumber MechanicID number Long integer General number No Title Text Mechanic title 50 General text Mr No Surname Text Mechanic surname 50 General text No Forename Text Mechanic first name 50 General text No Address1 Text Mechanic address1 50 General text No Address2 Text Mechanic address2 50 General text Ilford No Address3 Text Mechanic address3 50 General text Essex No Address4 Text Mechanic address4 50 General text No Home telephone number Text Mechanic telephone number 50 General text No Mobile number Text Mechanic mobile number 50 General text Mechanic table Appointment table Primary key Field name Data type Description Field size Format Input mask Default value Validation rule Validation text Yes Jobnumber Autonumber Job number Long integer General number No CustomerID Number Customer Id Long integer General number No MechanicID Number Mechanic Id Long integer General number No Appointmentdate Date/time Appointment date Short date =Date() No Starttime Date/time Start time Short time No Finishingtime Date/time Finishing time Short time No Servicetype Text Type of service 50 Service table Field name Data type Description Field size Format Input mask Default value Validation rule Validation text Servicetype Text Type of service Cost Currency Cost of the service 25 Currency ICT DESIGN YASSIR ELAMIN ...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. Introduction for a Software

    - I will also provide an area for coaches to include any additional information about the fixture such as what the player should be wearing etc. Input - The Data that are being entered to the database and in this case, which will be the information mentioned in Output in this table.

  2. In this (2b) report I am going to investigate software application, Input and Output ...

    and it gave the potential for creating new markets and in reinvigorating old ones. INPUT DEVICES An input device is any peripheral (piece of computer hardware equipment) used to proved data and control signals to an information processing system (such as a compute).

  1. Hospital Information System

    They also feel that the existing system does not help either in making the OPD consultations quicker or in generating quick laboratory reports. 2.1.3 Key Findings: Present study reveals, the existing system requires up gradation to meet the requirements of the managers and the clinicians.

  2. ICT Access

    The database needs to incorporate easy navigation and a useful supply of property details. The previous owners recorded property details on headed paper and organised them in secure files however Mr. Hock wants to adapt a system, which allows him to search a property or client reference number or distinctive element prompting the details.

  1. System requirements analysis

    The system also stores each of the staff's details a well such as their name and the job that they do in the hospital as well as their salary and the amount of salary that they get paid and also the number of hours that they have worked in the

  2. ICT AQA 2006-2008 Problem 2, Theme Park Software

    The use of Microsoft Offices' Excel was one of the first ideas; the reason for this was simply that; I had experience with the package, while knowing that the main features I needed were available. The application can be used in a wide variety of contexts.

  1. This system is to be used by members of staff to access information about ...

    Possible Software Now I must choose which format of database software to use in this particular situation. There are two different database software packages available to use in this project. They are Microsoft Access and Microsoft Works. Selected Database Software I have chosen to go with Microsoft Access because it

  2. The new system is required to calculate the costs of a new car as ...

    The collection of date of birth has led Mr. Cruiser to realise that many of the new, younger drivers are into the modifying scene and therefore his business strategy is aimed as such. After conducting an initial interview with Mr.

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