• 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

    Max Must only be numbers 0161 543 6789 The telephone number of a member Date Joined Date 10 characters Must only be numbers 05/06/2004 The date a member joined Additional Notes String 10 characters Any other additional notes that are needed on the member Data Dictionary - (Films)

  2. Computing Project

    boot of my car but I believe that it would be more practical if I had these facilities at home or in the office so the students can enjoy the facilities of a report without the inconvenience. Will you be the only user?

  1. Ilford Cricket Team Data Analysis Project.

    I discovered that I faced the following problems using this manual method: 1. I had the problem of not knowing at any one stage of the game, which team was in a stronger position and what kind of situation each team was in, so it was not possible for the captains and the coach to change tactics etc.

  2. This report aimed to replicate Stroop's (1935) experiment. Using the repeated measures design and ...

    This could be an explanation for the expected delay in the condition where the colour of the word is different to the colour that the word describes. AIMS AND HYPOTHESES Aim The aim of this report is to replicate Stroop's original (1935)

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

    the products to the basket when the link "add to basket" is clicked works correctly. I will go through my products and check that every "add to basket" link works and tells the user that there item has been added.

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

    It is therefore necessary to capture the essence of the business and model around those core concepts to be able to handle changes properly. Be consistent with other models in the system Different models of the same system can be integrated or cross checked against each other for consistency.

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

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

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