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


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.


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.


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


    My fifth objective was that the database must contain records on Names, Gender, and DOB. This was all achieved (check database) After looking back at my database, I think that I have done a good job, but I believe it could be improved.

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

  1. AQA GCSE ICT Specification B

    others were simply left out. Evidence Limitations This was not tested fully, only a small random selection of data validations was tested. Some fields were left un-validated. Refinements The system could be tested by allowing a small focus group of 'practice customers' use the system.

  2. Evaluating a relational database solution

    I could sort information by different fields just by selecting 'ascending' or 'descending'. Not only could I do simple searches, but complex searches were just as easy, I only had to type in a little more information. Sometimes it was quite confusing when I was searching for specific dates, because

  1. Setting up a database in microsoft access.

    To design the front welcome page of my database I went into the 'Form' tab, then selected 'Design View'. This then set me up with a clear record that I could design how ever I wanted. Editing Records - This was quite simple to do.

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

    I have also decided to carry on this project using a relational database software package. This is because of the below reasons: 1. Database application packages are specifically designed to create computer-based files to store and process information in place of manual filling systems such as the one in use at Luxury Hotel.

  1. Database design for a games shop.

    be input without computer using autonumber Delete autonumber field and enter data Cant enter data 3 Customer search query will search database correctly Enter information of member when prompted Details about member will appear 4 Buttons allow user to browse through recorded forms Press button Buttons will run macros 5 Valid Password Type qwerty(incorrect password)

  2. Hire Shop - creating a database.

    I'm hoping to include the following fields in my database to make it successful in giving all the information needed. Name Surname Address Telephone Number What has been hired? How long has it been hired for. Price The alternatives to lotus approach could be flexidata, which is another well used database type software.

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