Design of Customer Input Form

Authors Avatar

Design of Input/Output

Design of Customer Input Form

Design of Sports Hall Reservation Form


Design of Menu System


Design Of Customer Report (Sorted by surname)

    102              ADG             Brown        116 High Street,                028              £120                  Family                         5

                                                                             Belfast                            9012 5477

   125                 SR                Collins        Farm house, Farm               028                £60                   Single                          2

                                                                           Street, Saintfield         9154 4625

   

   116               AJR             Drennan      12 Portaferry Road,           028                £40                  Single                           4

                                                                             Greyabbey                    4277 8514

Reservation List

  1. 15.00,12/11/02
  2. 12.00,15/11/02
  1.                     11.00,05/01/01

Member Labels

These can be printed onto a page of labels, which can then be stuck to envelopes and sent out to the members of the gym. These addresses can be retrieved from many sources, so you could either use all the members or create a query and search for a specific reason to send out letters.


Data Checking & Controls

I will be using many validation checks in my system, including input mask, length checks and character type checks.

Input Masks

This is a way of ensuring only the correct characters are input into the field, and also in the correct order. This would be especially useful for the postcode field in the customer table, as it would ensure that only feasible postcodes are typed in. It is simple to create; you type a code into the specified text box, and it is automatically created. In this code, an “L” represents a letter and a “9” represents a number. So for a postcode, the code would read “LL00 9LL”; two letters, up to two numbers, one number then two letters to finish.

Join now!

Length Check

This limits the number of characters that can be typed into a field. It is most useful for a field with a specific number of characters like telephone number. A telephone number always contains the same number of characters, so this facility allows you to ensure that no extra numbers are accidentally typed in. It can also be used for other fields without a specific number of characters. For example, it would be extremely unusual for a person to have more than four initials. So, on this field the length check would be four.

Character ...

This is a preview of the whole essay