• 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. 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. 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. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    To change the cell range just high-light the range you would like, or type the range into the function, either in the formula bar located at the top of the worksheet or into the actual cell itself. I then copied the formula across to the adjacent cell situated to the right, by using autofill.

  2. bookings database

    Yes Unavailable room button (input) Yes Available rooms button (input) Yes Add a new guest button (input) Yes Find a guest button (input) Yes Navigate to other screens (output) Yes Qualitative performance indicators 1. Available room's button should stand out- the button on the 'Main menu' form stands out in the main menu.

  1. AQA GCSE ICT Specification B

    The user needs to use the menu to navigate, and giving access to the navigation panel could harm the system. 2. The database must be called 'Ducks System'. This makes the database more professional, and helps the user find it quickly on the desktop page.

  2. ICT BTEC UNIT 2 - REPORT

    Web Design System Requirements Advantages/ Disadvantages Adobe Dreamweaver CS3 CPU = 2 GHz Intel Centrino HDD Space =1Gb Graphic Card = Inno 3D 880GTX Monitor Resolution =1024*768 RAM = 512 Mb Some features and advantages to Adobe Dreamweaver are it has a great learning resource which includes basic templates for

  1. Powerpoint review project

    The rest of the data will be input by using the PowerPoint files. Some images will also be downloaded on the internet. Once these images have been downloaded I will then input them into my presentation by clicking Insert > Picture > From File or by copying and pasting them in.

  2. Excel - Analyse

    Description of Software Excel is a Microsoft product, so it works together with the various other software packages, such as Microsoft Word, and PowerPoint. Excel is the ideal software to use for formulas and has very few restrictions. The new updated Excel allows the user to edit the data in

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