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

Design - In my project I am using three tables, the customer table, the hire table, and the stock table.

Extracts from this document...


Design In my project I am using three tables, the customer table, the hire table, and the stock table. Below I will sketch out an outline of the tables. Customer Field Name Data Type Length Validation Default Lookup Customer No Autonumber 1 - - - Title Text 3 - Mr Mr, Mrs, Miss, Sir, Rev Initial Text 1 - - - Surname Text 15 - - - Address Text 20 - - - Post Code Text 8 - - - Phone Number Number 12 length must equal 12 - - Ward Number Text 7 - - Ward 1 - Ward 10 Discharged Yes/No - - No - * Customer No - Autonumber to represent the customer ID number * Title - Title of customer. Lookup for Mr, Mrs, Miss, Sir and Rev. Defaults to MR. * Initial - Customer's first initial * Surname - Customer's surname * Address - Address of customer * Post Code - Postcode of Customer * Phone Number - Phone number of customer. ...read more.


ID Individual Stock Number Customer ID Status Date Out Date Due Back Calculate Date Due Back Queries I will make the following queries; Overdue - Find Overdue items, and who currently has them Due back this week - Query to find items which are due back within a week. Stock Information - Query to show information on a selected item, by using a prompt for item ID and item stock number. Weekly Stock Report - Query which will list all stock and its current location, status etc. Update Date Due Back - Update query to update due back field in hire form. Reports I will make reports of the following queries; * Date Due Back This Week, date due back sorted into ascending order * Stock Information * Weekly Stock Report * Overdue Method Of Data Entry To create a new customer Customer No Title Initial Surname Address Post Code Phone Number Ward Number Discharged * Click on the create new record * Customer No automatically goes to the next autonumber * Fill out the rest of the fields, the ward number is a lookup for the ten wards. ...read more.


Miss Russell currently has two junior crutches, a junior neck brace and a junior wheelchair which are due back on 23/02/2003 and 13/02/03 for the junior wheelchair. The wheelchair is currently overdue, and my overdue query will show this. Miss Russell's other items are due to be returned within the week, so they should be on the Due This Week query, I will show a printout to prove my project is working correctly. The stock information query below shows that the junior wheelchair, stock #1 is in Miss Russell's possession. I will now show that Miss Russell has returned the wheelchair, however it needs repaired, and Miss Russell requires a replacement. I will change the settings on the Stock - Hire Linked table, and click the calculate Date Due Button These changes now appear in my tables and my weekly stock report. I will also show how I can add new items and customers. I will add a Mr Wilson, living in Gall Street, and in ward 5. This also shows my phone number validation, as I have purposely entered 11 numbers instead of 12. My main table now shows Mr Wilson. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science 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 AS and A Level Computer Science essays

  1. Computing Project

    Name Data Type Length Validation Example Data Comment Film Title The Matrix The name of the DVD Film Genre String 20 Characters Max Must only Contain letters Horror The genre of the film Length String 5 Characters 01.30 How long the film lasts for Age Certificate 2 Characters Must only

  2. AS ICT Corsework - Mr Brookes K-Fit Ltd

    you, what about a main office where all the orders are taken in a major city? Mr Brookes - I have already invested almost all my money so that couldn't really be an option for me. Ben Allington - Well how about an emailing order service where a spreadsheet is

  1. Computing Project

    Do you think providing each student with a card that you can scan to book and start lessons would be a good idea? No I don't think this would be a practical, students will lose these cards costing me money to replace them, another option would be for me to keep the cards and scan them when I need to.

  2. Logo design

    If you make a mistake, it can be easily fixed on a spreadsheet, whereas if you were to do it manually, it would be so much harder because you would have to keep starting again. This saves time as well as money.

  1. You have been asked to create a database to handle various account combinations of ...

    under investigation it is unlikely that it will communicate the main point to users. Models produced on a standard A4 sheet of paper are more likely o represent manageable 'chunks' or a system that users can comprehend, comment on file, post to other users and so on.

  2. Spare Parts Database Project

    Wong; The problem that the business is facing is the loss of record as there is not a good Database. 6. Self: Do your business give credit facilities to the client? Mr. Wong; Yes, if we do not give credit facilities to clients, we would never get a good clientele.

  1. Video Club Database Project

    Michael: Yes as it is usually the case everywhere. Self: What are the expenses which you make each year? Mr. Michael: When films are damaged I incurred a loss. Self: What types of films do you sells? Mr. Michael: I sell all types of films. Self: Do you own or rent this place?

  2. Security Project

    > Ensuring the whole building is secure and has an intruder alarm alert. To do this CCTV (closed circuit television system) can be installed. This is to prevent unwanted students from entering the premises and means that burglars will be restricted from entering the site, as they will be detected.

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