Video Database example essay topic

639 words
The database I created did fulfill all the requirements set by the analysis. The three aspects were created 1) The first one was to create a database of videos so we know what video's we have and so we can carry out searches such has any overdue video's we may have so we can inform the members who have them. The database I created did this well. I was able to carry out searches including searching for overdue which enabled me to know the overdue customers are so we can send letters to them. I could also search for other criteria's such as any particular actor or genre to help with any customer enquires for example. This would help the business and help achieve anything they may need quicker.

2) The second aspect was to create a database of members so we know which customer as which videos. I created this correctly. The database enabled me to know which customer had which videos so I would now what videos are available or not. This database will also help to run the business effectively. This database was linked to the video database to make this work. 3) The third and last aspect specified was to send letters to customers when new promotional offers come in or when customers need to pay fines for having overdue videos.

This was achieved my using the facility of mail merge. This sent letters to all the people with overdue videos without having to keep typing the same letter out. This saved time which could be spent on something else as a result the business will be run more accurately and efficiently. User requirements Being able to add people to the members list quickly. This was achieved by using forms to enter information about member quickly in comparison to entering it normally. This is shown in the user documentation shown how I created the form.

To store information on all video's within the shop to be able to provide information to the customers. Again using the database of videos and using queries achieved this. To find out if a video is available or not. There was a tick box in the video database stating if it was available or not which made it easy to find the available videos. To provide notification of new video new releases. I didn't actually do this requirement although I could of done something similar to the letter I send to customers who owe videos by using mail merge.

Improvements to the system. The system I made was very good however there could " ve been some improvements I could " ve done an outline to a letter of new releases to send to customers by using mail merge this would save time and be more prepared so I could run the business more effectively. Instead of typing the surnames out fully to save time I could " ve given the members a four-letter code, which would make it less time consuming. This would a Some of the fields used in the database could " ve had multiple choice inputting. Such as certificate and genre to reduce time. I could " ve set up a spreadsheet using excel for example to calculate prices of my video's to help the manager of the shop.

The spreadsheet could also be used to calculate staff's wages and produce graphs to show how well the shop was doing. I could " ve also created leaflets using Microsoft publisher to publicize the shop and give it a good image. Overall the system I created was very good but there is room for improvement..