Validation Rule helps ensure that the information entered is sensible, but not entirely correct.
Class List table;
Testing Plan;
User Requirements
The user should be able to send mass mailing to selected members; this would be the need for their problem of having to send each letter individually.
The user should be able to store and retrieve customer information; this would be the need for their problem of having to search for each person’s information in a filing cabinet.
The user should be able to sort customer information alphabetically; this would be the need for their problem of having to order each member’s information alphabetically in a filing cabinet.
The user should be able to track each member and the classes they take.
System should be accessible to all staff members.
It should be able to protect customer information and prevent loss if information by being backed up regularly.
It should be user friendly.
User should be able to check class times and change information easily.
User should be able to edit customer information effectively.
Sources of Information
-Customer information taken from customer application;
- Customer first and surname
- Customer gender
- Customer address
- Customer phone number
- Customer address
- Customer mobile number
- D.O.B
- City
- Postcode
- Customers’ Doctor Name and number
-Class/Activity list taken from Sports centre;
- Class List
- Class cost
- Cost of hiring facilities
- Dates and times of classes
-Member information taken from member database/list;
- Number of members
- Number of members taking a particular class
- Each member’s information
- List of each members class history
Inputs, Process and Output Required
-Inputs are what information goes into the system.
-Processes are what are done with the information.
-Outputs are what comes out of the system.
Software Applications Used
If the system wanted to send a mail merged letter it would have been created using a word processing application such as Microsoft Word and a database creator such as Microsoft Access. This is more suitable than just using Microsoft word as merging a database, with all the member’s information, and will save time as you will not have to type each member’s information out manually. This is better than spreadsheets as it offers a wider range of facilities and options to the user.
For newsletters and other posters, a desktop publishing application would have been used such as Microsoft publisher. They can use various templates which make it easier to design the poster or newsletter.
For letters, reports and other general information a simple letter would have been used. The Sports centre may have had a pre-made template which would have contained header/footer containing their information and their logo. All they would have had to do was enter the information. This would have been done using word processing, such as Microsoft Word as it is easier to enter the information and since letters are mainly formal statements Microsoft words’ template would make it easier to create.
Objectives of the System
The system should be able to create mail merged letters containing all customer information.
The system should be able to store and show customer information.
The system should be able to create new customer information and sort them out alphabetically.
The user should be able to see each member’s information and their history.
The system should be able to log each member’s activities and the classes they take.
The system should have security.
The system should be able to add new class details and check for activity times.
The system should be able to edit customer information and apply it to the database.
