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

    the same response from all of them here is the message my database gave me whilst performing certain actions but overall I realized it was just a little glitch. Also I have more information about the problems I had and how I solved them.

  2. Database Review of Document

    place to ensure no accidental deletion and make sure there are up to date backups to make sure there are no losses of data. VI) There is no nice easy way to get round the navigation system and no way to get round the reports.

  1. Reviewing different multimedia presentations.

    Then there is you teenagers in the age range of 13-18 who would use it to learn about the body in detail and then use it as a fun revision tool as it has all the information. Screen shot How does the text/image relate to the aim(s) of the product?

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

    To do this, I did the following: 1) I high-lighted the cell I wanted to complete the function in, and clicked the "Fx" symbol next to the formula bar. 2) An "insert function" box appeared asking for you to select your preferred function. I selected "COUNTIF" and pressed "ok". 3)

  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. ICT BTEC UNIT 2 - REPORT

    Pro is a great program for those who want to make a profitable online business and is overflowing with features to help you design your website. This program automatically creates and obtains a sitemap for your site which save you a lot if time.

  1. Spreadsheet Report

    You can also save your work by clicking on file save or save as. I also changed the width and height of the row and column so it would be easier to understand and it would make it clearer.

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

    I am going to need finish my menu designing: * A paint application. Hardware: 1. A computer 2. The visual display unit: you need at least a monitor of 17,19or21inch to avoid eyestrain and to see your work. 3. A mouse: one of the most important tools for the use of desktop publishing.

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