Documentation of video shop database.

6. Then another window will appear and you have now accessed the video databases.

This window appears and shows all the things available on my data base.

The table:

The table is the main design point for the database. You decide what field names and what special checks should be done into the database to reduce the amount of mistakes. To view the table form of the database you click on which table you want to view (video table, video taken out table or the member table click on the label that says TABLES and then double click on what table you want to see.

(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. 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. Click on the boxes and type in each relevant piece of information
3. Then save the new record.

 

Here is the video form-

To add a new video to the database you will have to do the following:

1. Click on the add button to get a blank record.
2. Then click on the boxes and type in all the relevant information. (To help speed up the process click on the combo-box arrow.)
3. Then save the new record.

 

Here is the video taken out form:

Once again I have used the same buttons on this form.

On this video out form you type in the people and videos which have been taken out. This is how you do this:

1. First click on the add button, then find out the I.D number of the video and type it into the box which it is relevant to. 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.