• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12

Design of Customer Input Form

Extracts from this document...

Introduction

Design of Input/Output

Design of Customer Input Form

image39.pngimage46.pngimage00.pngimage01.png

image59.png

image67.pngimage71.png

image77.pngimage88.pngimage02.png

image08.pngimage16.pngimage20.pngimage26.png

image32.pngimage35.pngimage36.png

image20.pngimage41.pngimage40.pngimage36.pngimage42.pngimage38.pngimage37.png

image44.pngimage43.pngimage36.png

image48.pngimage47.pngimage49.pngimage45.png

image50.pngimage52.pngimage51.pngimage49.pngimage47.png

image58.pngimage57.pngimage36.pngimage36.pngimage20.pngimage56.pngimage60.pngimage55.pngimage53.pngimage54.pngimage47.pngimage61.png

Design of Sports Hall

...read more.

Middle

image87.pngimage84.pngimage85.png

image92.pngimage93.pngimage94.pngimage95.pngimage91.pngimage11.png

image96.pngimage97.png

image04.pngimage03.pngimage05.png

image09.pngimage06.pngimage07.png

image10.pngimage11.pngimage11.pngimage11.png

image15.pngimage13.pngimage14.pngimage12.png


Design Of Customer Report (Sorted by surname)

image18.pngimage22.pngimage23.pngimage21.pngimage19.pngimage24.pngimage17.pngimage25.pngimage18.png

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.

image27.pngimage28.pngimage29.png

image33.pngimage30.pngimage31.png

image34.png


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

...read more.

Conclusion

OpenFrmCustomer/ OpenFrmReservation – These is assigned to a button in either the Reservation form or the Member form. When it is clicked, the other form opens ‘on top’ of the reservation form. This is useful if you want to switch easily between the two forms.

Open MSWord – This does exactly what it says on the tin. When the button to which it is assigned is clicked, Microsoft Word is automatically opened, from where you can open the mail merge letter. I would have liked it to automatically open the mail merge template, but I haven’t been able to do this.

OpenRptCustomer/OpenRptReservation – This opens up a report with a list of all the reservations or members on it. Again, this is assigned to a button in the relevant forms.

SaveCustomerFrm/SaveReservationFrm – This is assigned to a button, which, when pressed, saves the form.

Open Member Labels – This is assigned to a button in the Member Form. When it is clicked, it open up the ‘Customer Labels” report, which can then be printed onto labels and sent to members with relevant information.


Hardware and software

Hardware Recommended

PC with monitor, keyboard and printer – E.g. Emachines Intel Celeron 1.8GHz PC. Includes Monitor, PC, Keyboard, Mouse, Printer & Speakers. Also contains Windows XP                                      
image98.jpg

Price £599

Software Needed

Microsoft Office Professional. Licence for 1 computer only.

Price £519image99.jpg

Alex Mladek

...read more.

This student written piece of work is one of many that can be found in our AS and A Level Fields & Forces 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 Fields & Forces essays

  1. Peer reviewed

    Investigating the forces acting on a trolley on a ramp

    5 star(s)

    = 8.416ms-2 And for when O = 3.3�; g = 0.3367 / (0.05756 - (0.02793 x 0.99834)) = 11.346ms-2 Finally, it is necessary to change the percentage error of 43.56% into a value for each result; When O = 10.8�; g = 10.237ms-2 �43.56% = 10.237 ms-2 �4.459 When O

  2. New Technological Advances in Wing Design

    Both teams face rigorous safety challenges before their ideas can be put into action. Air Friction Reduction At any subsonic speed (a speed below the speed of sound) air runs smoothly over the wings of an aeroplane without any distress.

  1. movement in sports

    The preliminary work served another purpose as well which was determining how to make the best use of the equipment. After looking at different ideas, it was decided that the clamp would be ideal if it was attached to the stool rather the edge of the table as this would allow the masses to move more freely.

  2. Physics Coursework, Visit to Holly House

    These magnets produce a 0.5 tesla to 2 tesla magnetic fields, allowing for much higher quality imaging. This is an extremely large number, and the average MRI scanner has a magnetic field that is 10,000 times larger than the magnetic field of the earth.

  1. Investigating a factor affecting the voltage output of a transformer.

    Preliminary work Firstly I wanted to determine what distance between the primary and secondary coils gives the optimum conversion of primary voltage to secondary voltage. As shown in the table below, this distance is 0cm. Secondly I wished to know what the best range of nominal voltages is.

  2. Investigation of the plants on the school field.

    - - - - - - - - - - - - - - - Graph: I have put my results into a graph so that my findings are easier to understand, and any trends or patterns will stand out.

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