Design of Customer Input Form

Design of Customer Input Form

Design of Sports Hall Reservation Form

======================================

[IMAGE]

Design of Menu System

=====================

aaaaaaaaaaaa,aaaaaaaaaaaa,aaaaaaaaaaaa,aaaaaaaaaaaa,aaaaaaaaaaaa,aaaaaaaaaaaa

Design Of Customer Report (Sorted by surname)

[IMAGE]

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

================

[IMAGE]

101 15.00,12/11/02

102 12.00,15/11/02

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

[IMAGE]

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.

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