IT Implementation

Authors Avatar

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 need changing:

I then need to save the database my closing it and clicking yes when it asks me if I want to save:

Changing the Member’s Table

When looking through the table, I found that the ‘Telephone Number’ field’s data type was set to number:

 

I need to change this because when the data type is set to ‘Number’ it doesn’t show the zero at the beginning of the number. I changed it to ‘Text’, as this allows the field to have the zero at the beginning.

Creating the Car’s Table

The way that I made the car’s table is basically the same as the Member’s table except that the fields used were different.

I click on ‘Create a Table in Design View’ again and entered the field names:

I then set the data types with them all being Text except ‘Member ID’ which is set to AutoNumber and ‘Year Made’ which is set to Date/Time.

I then saved the table, naming in Tbl_Car just as I had done with the Customer table.

Join now!

Changing the Car’s Table

When looking through the table, I found that the ‘Car reg number’ field was set to 50 characters long:

I changed the ‘Field Size’ to 10 characters long, as no registration number is more than that and it creates space on my database.

Creating the Loans Table

The way loan’s table was created in basically the same way as the Member’s table and the Car’s table except that the fields ...

This is a preview of the whole essay