• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1102

My database is on a video rental shop.

Extracts from this document...


Introduction: My database is on a video rental shop. My uncle Ronnie has been recording his data all by hand since 1982. He now wants to modernise his shop and record his video rental details on to the computer. He has asked me to create a database this will be created using Microsoft Access and this is my report on how the database was created. What will the database enable you to do when you to do? This database will enable me to: * See who took out the video * Which video they have taken out * When it is due back * If they paid or not * It will also let me focus more on the important aspects of the business, as the renting information will be much easier to access rather than me always writing the customers details when they rent a video from my shop. What data is needed? For this database to work well I will have to collect the following the data. ...read more.


* Then I have linked video ID from the table renting to video ID from the table video on a one to one relationship. Also linking these tables helps keep the information accurate as linking the tables enforces data integrity. I will link my tables together like this: * First I will drag customer id from the first table to customer id on the second and then video id on the second table to video id to the third table. 4. Describe how you put your plan for tables and relationships onto access. I will put my tables in my database by going to new and starting a new table. I will also add a primary key to all my tables. 5. Describe how you entered the data into your tables. I put my data straight onto my tables, as they were all ready set up to fill in the data. 6 Describe how you have searched (query) and reported any findings Have you clearly described what you were searching for? ...read more.


I realised this after showing it to my uncle Ronnie who owns a video shop. He said that it still is very helpful but can be improved a lot more, for example he said I needed to add something to my database that will enable me to check how many videos there are in the shop. For example, a person takes out "Romeo must die"; I need to find a way that will tell me how many "Romeo must die" films remain in my shop. All my tables were suitable as their names suited them and the fields were suitable for example I put "yes/no" fields in suitable places along with the others. After doing this basic database I have thought of many ways to extend my database further, but the main and most important one I have already explained above. another problem I had, was when I realised someone had been going through my files without my permission. at first I did not know what to do but then I realised I had password protection available so I used it. DATABASE REPORT Vipan Bagga 10c Mr Jogia ...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. To start my project I have chosen that I would do a spreadsheet for ...

    This will help the user get around the spreadsheet very fast and quick. For my project I have used Excel and the Flexi data. Before I have already mentioned why excel is the best program for creating this system. Flexi data was used to get the customer's data.

  2. Designing a leaflet to advertise an electronics shop.

    This has to be an attractive leaflet, so I want you to add colour. Secondly there are far too many pictures of the products. I only want maximum of four on each page. Lastly I want you to put more detail about the company, such as email address, phone number, address and the company slogan: "because you're worth it".

  1. Planning a spreadsheet database for a gun shop.

    that flash phones were facing and how I helped them and the manager out. The problem brother john was facing was: * Finding the calculations of how many phones they have, * Calculating how many they sell over a period of time * The amount of profit or loss that

  2. Documentation of video shop database.

    (Diagram on the next page) Then a table appears showing all the records in that file. Below is the table for members. You can also see a design view of the tables. It tells you what all the field titles mean.

  1. Setting up a database in microsoft access.

    The button was ready to use in 'Form View'. If I did not want to just go to the next record etc, but go from my welcome page to the database where all the records were I created the button slightly differently.

  2. Research, collect and describe graphics

    http://www.aria.co.uk/ http://www.comet.co.uk/ Target Audience People who want to navigate around help sites within the Paypal website easily People who want to navigate to other options within the Google website more easily. People who want to navigate through all of Aria's product areas in one quick place.

  1. Database design for a games shop.

    So when they decides he should chase up a customer he cant be bothered to look for their details in the folder. They need to be more organized there for they will need to group information into a table. More over blockgamester receive a high volume of phone call and email regarding a specific game or information about their rental.

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

    Backup: Back up copies of files should be kept in case the original is damaged or lost and cannot be use. Because of the importance of certain files, back up copies of it should be taken at regular intervals in case it is stolen, lost, damaged or corrupted.

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