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

Documentation of video shop database.

Extracts from this document...


Documentation of video shop database User guide For the video shop project I created a database on Microsoft access. To get to the database you have to do the following 1. Turn computer on and log onto the computer. 2. Then once the computer has loaded up double click on the icon which looks like this: 3. Once the programme has loaded up a window will appear and to carry on to access the video database click on OK. 4. Then this window appears and to access the video shop databases double click on OTHER folder. 5. Then another window appears and shows you what the other folder contains. It shows that the video database is in this folder. To access it just double click on it using the right mouse button. ...read more.


To access the design view you click on this icon: By clicking on this icon you go to another table which informs you what all the fields mean. Here is the design view for the member table. (On the next page) You can do the same for all the other tables as well. Forms: This is the area in which you can add, edit and delete records. To access a form you have to click on forms on the side and then on double click on what form you want to see. (Diagram on the next page) Here is the Member form- As you can see there are a series of buttons on the form which all have their functions under them. If you would like to add a new member to the file you have to do the following: 1. Click on add. 2. ...read more.


The computer will automatically pick up the title, certificate and the price. 2. Then find out the I.D number of the customer and type it in to the relevant box. The computer also picks up the name and title of the member. 3. Then all you have to do is type in the date due and then save the record. Queries- Queries are searches across the database to identify certain things. I made for I have created three queries to identify the most popular video, the least popular video and for overdue videos. Here is how to access the queries: Click on the queries on the side and then click on the query that you would like to conduct then double click on it. Then a table will appear showing all the relevant information. EXAMPLE: This table below shows all the over due videos. This is how to use the video shop database. ...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. Planning a spreadsheet database for a gun shop.

    was made weekly or monthly My quantitative objectives were:- * Need to calculate the total amount of income each week, * How much profit/loss is made in the shop * How many phones are sold Solution I solved these problems and achieved my quantitative objectives by making Microsoft excel spreadsheet

  2. Designing a leaflet to advertise an electronics shop.

    EVALUATE Evaluation against objectives My leaflet has met all the objectives like on the first page of the newsletter it has the company name/logo at the top I made the logo by using a programme. The leaflet has text boxes and columns on the second page.

  1. Database design for a games shop.

    the downside is that he will have to buy many cabinets and at least 10,000 folders. This will cost a lot of money, but MR. Walcott has already got a laptop so that will be no extra cost. Also this is a very tiring and complicated way for MR.

  2. What is a computer registry?

    We recommend that you follow those instructions exactly. Use Registry Editor Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved.

  1. AQA GCSE ICT Specification B

    12. Each button on the main menu must have a simple explanation. Open the main menu. Each button should have a simple explanation beside it. Testing Against The Test Plan Test 1, 2 + 12 Test 3, 7 Test 4 Test 5 Test 6, 10, 7 Failed (Test 6)

  2. Powerpoint review project

    I will do this by going to Slideshow > Slide transition and choosing the options that I want for the slide timings. Action Buttons I will use these for my slideshow. These will navigate back and forward between the slides.

  1. Database analysis of 'a video lending library'.

    Alternative Solutions: 1. Use a register: This is a manual way of maintaining the business of lending the cassettes from a library. Make 5 sections, section one for customers, section two for cassettes, section three for money paid, section four for cassettes return, section five for current cassettes.

  2. Project 1b; Film Database

    Now I will set up some validation checks on the two data fields certificate and genre. The following screen print shows me setting a validation check up in the design view of my database. This validation rule is for the data field genre: On the next page I will present the other validation rule I set up.

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