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

Database Section

Extracts from this document...

Introduction

Software For my database project I am going to be designing a computer system, which will be able to handle data. My user owns and runs their own DVD rental shop called "DVDs-2-Rent". At the present time, all customers are stored in a filing cabinet kept on individual cards. To solve this problem I could use a Spreadsheet, Word Processor or Database programme. I am going to use a Database software package called 'Microsoft Access', as I think this is the best possible solution to the problem am trying to solve. By using 'Microsoft Access' you can keep a large amount of information stored on a database that is related to a particular topic and would become unmanageable in Spreadsheet form (i.e. I am going to use a database to hold information about DVDs and customers). Also another advantage is that data can be altered and changed easily. By using this software I will also be able to run queries for different information about DVDs for both the user and the customer. This means that if my user needs to search for a particular type of information about DVD or customer details (i.e. ...read more.

Middle

I will also need to produce two onscreen forms, which allow the user to enter details about what the user is trying to find out: * Find all DVDs of a certain genre (i.e. Find all the romantic comedy DVDs) * Find all DVDs of a certain certification (i.e. U, PG, 12, 15, 18) Information for each of my user's customers will need to include: * Unique Identification Code * First Name * Surname * Date of Birth * Address * 1st Line - House Name/Number * 2nd Line - Street name * 3rd Line - Town * 4th Line - County * 5th Line - Postcode * Contact Number(s) * Proof of Identification (Passport, Driving License) * Email Address (Reminders, Special Offers) Information that must be held about each DVD: * Individual/ Unique ID number for the DVD * Name of the DVD * Certification (U, PG, 12,15,18). * Genre of the film (Horror, Comedy, Romantic, Drama Action etc). * Date of release Information that must be held about the loan transaction: * Holder of the DVD (ID/Name) * DVD (ID or Title) * Date on loan * Date due back * Amount due (�) ...read more.

Conclusion

Using a validation rule reduces user input error. Fields I will need to validate to reduce input error: Customer table: * Gender - ("M for male, "F" for female) * Date of Birth - (Input mask - 00/00/0000) * Post code - (Input mask - >LL00\ 0LL) The user will need to update information in this table when new customers complete the membership forms supplied by "DVDs-2-Rent". A new record will need to be inserted into the table by going to Insert =>New record and once it is entered the customers will then need to be sorted into ascending order. When a customer ends their membership, the user will need to delete the member's record by clicking the arrow on the left of the table => delete record on the correct record to be deleted. The user will need to alter the data in the record when, for example, the customer changes their address or contact details to valid information so if the user needs to contact them then they can refer back to the database that should display the updated information for the customer. Jess Kimber "Analyse Section" Jan 07 ...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.

    formulas work and make sense To make sure all the formulas work e.g. adding All the formulas have been used including VLOOKUP 3 Grammar Should all be corrected No Grammar mistakes All grammar has been corrected and checked 4 Layout Should be according to plan Should be according to plan

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    If I was to re-write this formula again, I would add that section in, as there is a high possibility that a child may need to improve in both areas, and it may confuse the end user if it does not do so.

  1. Analysis section for database project based on a hotel booking system

    Database allows the use of tables to present the list of all information such as; list of guests and their details, lists of rooms and their details and lists of all the bookings that have taken place with the dates and by whom.

  2. bookings database

    The font is bold and has a larger font than the other command button. This is effective for the user because this command button is the most frequently used by the user. As it bold and centred, the user will automatically see this command button first.

  1. AQA GCSE ICT Specification B

    The 'Sales Summary' page must display an 'Enter Two Dates' box before opening This allows a user to find all sales records between two dates. 9. Drop down boxes must show every option, and not be hidden by other boxes.

  2. ICT BTEC UNIT 2 - REPORT

    The disadvantages would be that it doesn't let you put your own documents in such as HTML or Word documents, and some might say it's too basic. First Page version 3 final CPU = 75 MHz Pentium processors HDD Space = 50 Mb Graphic Card = GeForce 8800 ultra Monitor

  1. Powerpoint review project

    data loss and I will store the original and back up file themselves into a folder which will be named 'PowerPoint'. This strategy will help me to find the files and to open them safely. I will avoid losing my work by saving the presentation and other work every 5

  2. Analyse - Database

    Below is a table of the computer input and how it will be verified. Computer Input Verification The fields for the tables and the records The information collected will be typed into the tables and a copy will be printed.

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