• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Mr B Monk has asked me to help him develop a database system for his new upgraded video shop.

Extracts from this document...


Database Report!!! User Requirements Mr B Monk has asked me to help him develop a database system for his new upgraded video shop. I will do this by using 'Microsoft Access'. This will hopefully give my client a clear understanding of what videos each customer has taken out and which customer has returned or not returned the videos. ...read more.


Data Needed To develop the database I will need the following data: > Customer's first name > Customer's surname > Address > Telephone number > Date of Birth > Customer ID > Video ID > Video/DVD films > Rating > Genre > Date borrowed > Date returned I will get this information from the video shop. ...read more.


For the customer ID I decided to use 'auto number'. This means that when I type in the data for the customer ID the numbers will come automatically in ascending order. For the customer's first name, customers last name, address and phone number I used 'text' for obvious reasons. I decided to write the date of birth in 'date/time', so that it will be presented in that format. ...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.

    All the pictures in the leaflet are the same size. The special offers are on last page of the leaflet. The leaflet is colorful and attractive, it also meets all the users objective which I was meant to achieve User feedback critical and relevant Dear Haseeb

  2. My database is on a video rental shop.

    I am searching for what video has been taken out and by whom. I also have the customer details, which will help me, get hold of the person if ever, needed and also I have date of birth so under aged people cant take videos out.

  1. Planning a spreadsheet database for a gun shop.

    password protected Burma Road Birmingham Bra 4bb Tel: 06531234321 Dear Mr Butt I am very impressed with the work that you have produced for our company and I would like to thank you for your time, effort, the computer you brought me and producing the spreadsheet.

  2. AQA GCSE ICT Specification B

    Customer Name and details b. Ordered item c. Personalization details d. Prices (calculated with a calculator); i. Net cost ii. VAT iii. Total cost 3. This information is given to the customer. 4. If they are happy with the order, stage 5 is carried out; if not, stage 2 is repeated.

  1. Documentation of video shop database.

    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.

  2. Setting up a database in microsoft access.

    Producing Graphs - To create a graph I went into the 'Report' tab, and clicked 'New', and then selected 'Chart Wizard'.

  1. A new IT system in a Dubai Marauders Rugby Football Club

    the Club's Finances Microsoft Excel Able to Create Quick Personalised Letters to be Sent En Masse (Mail Merge) Microsoft Access Microsoft Word Create a Leaflet and Posters for upcoming 7s Tournament Microsoft Publisher Advertising of the Club Online on a Website Microsoft WordPad To Create a Pitch Schedule that can

  2. Database design for a games shop.

    of the customers and which game do they want or have they got. MR. Walcott and Ben need to find a quick and easy way to be more organized and maximize profits. Lastly not keep the customers waiting. Alternative solutions By now it is made obvious to us that Blockgamester is clearly struggling to be organized.

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