• 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

    Output -Some important details about the fixture, the time, the venue and the players who are involve with the match and the position they are playing. I will include a space on the team sheet to show the positions of the players.

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

    A check is kept on how much stock is in the warehouse. When the warehouse needs new stock, an order is placed with the appropriate suppliers - or with the organisation's main warehouse - and the goods are delivered. How/Why Sainsbury uses Internet?

  1. Hospital Information System

    Participants feel information system in a hospital assists in decision making, medical audit and in various other important purposes. Participants felt that the existing system resulted in longer time for consultation and delay in investigation results. Majority of the participants feel that the system can help in education and research if developed in an appropriate approach.

  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

    hospital every day and the system uses all of this data about the staff and it uses it to work out their salary at the end of each month and the system also creates a payslip for each of the staff members in the hospital.

  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