• 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

    Are you male or female? Male Female 3. How old are you? 0 - 18 19 - 34 35 - 54 55+ 4. Do you feel K-Fit Ltd could be improved by a website for ordering and products? Yes No 5.

  1. Computing Project

    yes it would be ideal if I were able to use access to store and interpret all the data. Would you like a printer in your car to print out reports for students? Again I think that the space is an issue we could set up all this in the

  2. Logo design

    such as tax etc Formulae sheet: It is important that no mistakes are made because if the data is wrong, then an employee may earn more or less money than they are supposed to. If it carried on, then in the long run, people may decide to leave the company

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

    Would it be easier if information was copied from table to table or was identified in different sections using the customer ID? -Yes -No 7) Does adding colour make the database more interesting? -Yes -No 8) Would it be a good idea if the database was made more realistic using 3D effects and interesting graphics and writing?

  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

    > Having security staff on duty, so that suspicious characters can be identified. This prevents theft from happening as if he security staff were suspicious of a certain student, and then they could stop them from carrying out that theft.

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