• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  • Level: GCSE
  • Subject: ICT
  • Word count: 2276

IT Implementation

Extracts from this document...


Implementation I will be explaining below, how I made the database and several different key elements which make up the database of the Car Rental firm. In order to create my tables and files for the car rental system I first had to create the database.: After I opened Access I was presented with a blank screen and I selected 'Create a New File': After that I selected 'blank database' and a save screen appeared so I named my database and saved it to my pendrive: I then created the database with a suitable file name: Then the main database window opened up which gives me the ability to create tables, forms, reports and queries: Creating the Member's Table I start off in the Main Database Menu and make sure it is in table and then double click the 'Create Table in Design View' which creates the table in design view where I can input all the data that I need: I then put my field names in the field names column: Once the data has been entered I need to alter the 'Data Type' as it is automatically set up by Access as 'Text'. Most of the fields are Text with the exception of 'Member_id', 'Date of Birth' and 'Number of cars previously rented' so it is relatively easy to change the ones that ...read more.


With the only difference being that I selected Tbl_Loans in the first step: The finished form looked like this: Customising the Loans Form Then I have to change the design of the Loans form to match the design of the form in the design section and to make the forms look professional and match the company's logo. Firstly I made sure that the form had no record selectors or Navigation buttons as I was going to create my own: I then changed the background of the form to blue: I then changed the font to Trebuchet MS, Size 12, colour white. I also made the background of the text box blue to match the background of the form and made all the text boxes the same size: I then added a title to make it more appealing: Next, I added the Navigation buttons: I then added the logo of the company that I am working for and the form was complete: Changing the Design for the Customer and Car Form I made exactly the same design changes for the customer and car form as I did for the Loans form. They ended up looking like this: I edited the forms to make them match the forms in the design, look professional and match the company's logo. ...read more.


I chose to create a table to show when the cars were made. For this I used Spreadsheet Software. Firstly I had to import data from my database: I went to data, import external data, then import data. I clicked on import data and this box appeared on the screen: This shows all the destinations that my data could be in. I went to the place where my database was and then opened it: A box showing all my tables comes up. I chose the table that I wanted to use (in this case Tbl_Car) and then opened it: This shows all the information that I have in my database. Using this I can select the information that I want for my graph: I then clicked on the chart wizard button and chose a column graph: I clicked next. After that, this is shown on the screen: I clicked on the series tab, this box then opens: I then clicked on the category X axis and chose the X axis category (in this case car name) and I then clicked next. It brings this screen up: From here I can enter the chart title and the labels for the X and Y axes. I then clicked finish; the graph appears on the spreadsheet: ...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 Software 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 Software essays

  1. Evaluating a relational database solution

    I could also sort some of the fields to make it easier for users to work with, and I could chose which orientation I thought looked best for the page e.g. portrait, landscape. I could also change the title of the report to whatever I decided.

  2. The aim of my project is to make the task of the allocation of ...

    It will also allow detailed reference of how many children were there, the amount of adults and concessions, and allow their prices to be changed in an easy change of data All of these are displayed in the sheet in the protected area, they all change automatically when the user inputs any new data.

  1. A02 Implementation Commentary

    Also, if spelling is incorrect, it looks very unprofessional and irresponsible. When data such as Opening Times are inputted, it is essential that they are correct and always up-to-date as customers need to know the vital information. Errors could be made when the data is being typed into the system, or when the original data is being printed/produced.

  2. Database design for a games shop.

    Furthermore MR. Walcott has already got a laptop with Microsoft access installed in it so he does not have to spend any money on buying a software. Also they are advanced in ICT so using and maintaining this software should not be a problem.

  1. Spreadsheet Report

    I set the second worksheet in exactly the same way. -Right clicking on the sheet -Select re-name -Type in "Hiring" 4) I set the third worksheet in precisely the same way. -Right clicking on the sheet -Select re-name -Type in "Commissions" 5)

  2. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    The real user: The real users are the customers who will be looking for the Asian cuisine. This will also benefit Mr. Hussaini's business. ANALYSE: The following are the features of the Microsoft publisher: Software: The following software can be used in the Microsoft publisher: * Columns can be created

  1. Hire Shop - creating a database.

    because it can handle and will be able to do the following: - * The system will consist of two databases, which can be linked so that all the information can be accessed easily. * One of the databases will contain information about the equipment which the music shop is hiring out.

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    To copy the formula I hovered over the bottom right of the first cell, and waited till a black plus sign appeared. Once it had appeared I grabbed it and pulled it down, high-lighting all the cells I wanted the formula to be present in.

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