• 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. Video Club Database Project

    FORMS The menu structure was set up as specified in the design section. Forms were used as follows: Main Menu This is specified as the start-up form and loads automatically when database is opened. All buttons either opening other form or reports, or quitting the database, were placed using wizards.

  1. I have been given the task to design a database for a company called ...

    There are several rules for passwords, these include: * Passwords should be at least 6 characters * Passwords must not be displayed on the screen but must be masked by asterisks. * Files containing passwords must be encrypted * Passwords must be kept confidential * Passwords must be changed regularly

  2. Spare Parts Database Project

    It should take less than one minute to trace a sparepart for a customer. 1.5 Data flows The following is the data flow of the proposed system. Item ID, Item detail Detail Customer Id, name, address Item ID, Make Transaction ID, Customer ID Item ID Transaction ID Item ID,

  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. Computer Aided Design Package

    made by a company called Autodesk, both IMSI and AutoCAD sell other products that are like CAD, but they will not be suitable for the tasks that Engineering ? Us require of it. Upon further investigation I have discovered one problem with TurboCAD that DeltaCAD and AutoCAD don't have is

  1. Robot Prototype design principles.

    While not count completed Generate random position Display position Wait for response Score accuracy Count ++ Read system time Calculate average time Write to screen ---------------------------------------------------- Measure average time Combine results from different users Take user suggestions Principles of HCI (by Sutcliffe)

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

    This is because the participant has to force his/herself to read the word and not say the colour of it. This therefore means that, according to Kahneman, the central processor has trouble deciding between tasks (in this case, between reading the actual word or the colour of it).

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