• 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
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  • Level: GCSE
  • Subject: ICT
  • Word count: 2276

IT Implementation

Extracts from this document...

Introduction

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.

Middle

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.

Conclusion

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. Database design for a games shop.

    Evaluate User feedback Dear Haseeb I would like to thank you for a brilliant piece of work which you have produced, the final database system is absolutely outstanding. The database has met all the requirements I set you. Firstly I would like to tell you what I like about the

  2. Reviewing different multimedia presentations.

    With this screen shot what it is showing is the way when you put a body part in wrong it has come up with this message box which tells you if you have the rotation wrong or the positioning wrong or both.

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

    Once I had selected the formula icon, a box appeared listing all the different functions you could choose. I selected "VLOOKUP." If the function you are looking for is not in the list provided, then most likely it is not presenting the full list of functions, it is maybe showing "the most recently used."

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

  1. ICT BTEC UNIT 2 - REPORT

    which will make your computer extremely fast and will be a hell of a lot quicker responding to commands. Unlike the Dell Precision WorkStation T3400 only has a Intel Core 2 Duo processor which isn't as fast as the Quad Core but can be just as efficient when executing programs.

  2. Spreadsheet Report

    5 Describe the formulas and functions you entered into your worksheets Here is an explanation of the formulas that I used I entered the formula and pressed this button auto sum and clicked on the edge of a cell and dragged it across so it would calculate the formula for me.

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

    Then I sat with the waiters to collect the information they are currently narrating to the customers and recorded it on paper. I also asked the waiters for the popular cuisine that was liked by customers and ordered by them mostly.

  2. Spreadsheet for a basketball company

    Restrict users from entering any anonymous value in the seating area 6. Calculate the company's income and expenditure for every match and based on these results, calculate the total profit for that specific match 7. Automate graphs relative to the company's income, expenditure and both of them in opposition to each other automatically 8.

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