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

Introduction

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.

Middle

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.

Conclusion

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

  1. Database design for a games shop.

    Furthermore MR. Walcott has already got a laptop with Microsoft access installed in it so he does not have to spend any money on buying a software. Also they are advanced in ICT so using and maintaining this software should not be a problem.

  2. AQA GCSE ICT Specification B

    I will implement questionnaires and discussion groups, as well as observing users doing their jobs to achieve this. Finally, I will decide upon the most economically viable and effective solution to the problem. Specification I will further detail the requirements of the system, addressing each one individually and planning exactly how the system will function.

  1. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    Backup: Back up copies of files should be kept in case the original is damaged or lost and cannot be use. Because of the importance of certain files, back up copies of it should be taken at regular intervals in case it is stolen, lost, damaged or corrupted.

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

    In this way it's easy to record the no. of customers and the no. of cassettes coming in and out of the shop. 2. Use cards: this is also another manual way of maintaining the shop. It is also an easy manual way.

  1. Excel - Analyse

    Ball Mouse * Using a ball decreases accuracy. * Dirt and dust can cause the mouse to move rigidly and unsmooth. * Works using old technology, (serial port). The latest mouse's work using USB, these are more responsive and accurate, * They are cheap to buy.

  2. Project 1b; Film Database

    Both need to be entered separately in these two rows. The screen print below shows the query in the design view: The following screen print shows the result of this query: The software Microsoft Access is quite suitable for this task, because it specialises on the sorting and filtering of data.

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