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

  2. ICT GCSE Coursework - Documentation.

    and also provided me with a wide range of models and makes so that I could vary all the cars that I had so that I have a wide range of different cars for a customer to choose from. Once I had collected information of 50 cars on my data

  1. My database is on a video rental shop.

    Have you shown a screen shot of your search criteria table? Have you shown how you set up a report in your search (es)? Have you included a printout of any reports? Have you explained what each printout shows? I have clearly showed what I am searching for and why.

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

  1. What is a computer registry?

    The Group Policy MMC snap-in lets administrators define policy settings that are applied to computers or users. You can implement Group Policy on local computers by using the local Group Policy MMC snap-in, Gpedit.msc. You can implement Group Policy in Active Directory by using the Active Directory Users and Computers MMC snap-in.

  2. Technical Documentation.

    I have also used an 'ISBLANK' statement within this formula, and the purpose of this is to leave the cell blank if it is not necessary for any data to be looked up from the cell. =IF(ISBLANK(F19),"",F19*G19) - This formula works out the total price of he same stock item

  1. Setting up a database in microsoft access.

    I then clicked 'Next'. I could then chose the type of layout that I wanted in my record e.g. 'columnar', 'tabular' or 'justified'. After clicking next I could chose the style I wanted e.g. clouds, colourful, colourful 2, dusk etc.

  2. Database design for a games shop.

    When the folder is missing they just leave the paper lying around. This makes them look unprofessional and it not a good impression on the customers, furthermore when the shop is very busy the service gets very slow and the customers get agitated and leave.

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