We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Completed Database and Documents for the Extreme Sports Club Essay Sample

The whole doc is available only for registered users OPEN DOC
  • Pages:
  • Word count: 1244
  • Category: sports

Get Full Essay

Get access to this section to get all the help you need with your essay and educational goals.

Get Access

Completed Database and Documents for the Extreme Sports Club Essay Sample

After testing the completed system, I visualise Mr Gavin using it in the following way. All of the template documents will be created and stored on his hard disk and accessed through a drop down menu on the homepage. The home page will be displayed by loading a file I will call “Extreme Sports Club Homepage”. By clicking on the drop down menu he will be able to open the relevant template and be able to enter the information needed. He will also be able to print out the finished document. When he closes the document he has just printed he will be able to click on a button on the home page document (that will still be open) and re-launch another template. He will also be able to work on more than one template at a time. Once he has finished his work with the templates he can exit the system by clicking on the X button at the top right hand corner of the homepage window. The templates will remain unchanged when new documents based on the templates are created. (Information on how to input data and process each document will be outlined in the design).

Hardware Requirements

To run the system Mr Gavin will need the following:

* Intel(r) Pentium(r) processor 1.86GHz

* 500 MB RAM

* 200GB hard drive

* DVD/CD-RW Drive

* Broadband Router

* 19″ widescreen TFT display

* A colour laser printer: to present high quality hard copy, required for all documents at high speed; 17 pages per minute

Software Requirements

* Windows XP operating system

* Microsoft Office 2003 with Microsoft Word

Data sources and inputs



Data Source

User Inputs

Home Page

Drop down menu to open the templates: Payment reminders and letter. Company Name and logo will also be placed on the homepage.

The end user will provide advice on which templates to add, the logo and the name of the company.

Selects appropriate template

Payment Reminder

The payment reminder will contain the sports members Customer title firstname, lastname, address, tel no, e-mail,

Payment reminder details: invoice no, item code, price, description, quantity, total;

Subtotal, vat, payment total

It will also contain the company name and logo. Fill in fields will be used in the payment reminder.

Current sports member details gathered at time of purchase over phone, order form or email. The end user will supply the logo and company name.

The end user will input the sports member and payment reminder details. The customer details will be entered by fill in field prompts.

The payment reminder data will be input directly into the embedded spreadsheet


The letter will contain the sports club member’s title, last name, number and name of street, town, county and post code. The date will be updated automatically so that each time the template is used the current date is displayed. The letter will use mail merge. The logo and company name will be inserted.

The letter will be a mail merge. The data file will contain a record for each member. The input field will be: title, last name, address, Town, County and postcode and so on. The date will be updated automatically so that each time the template is used the current date is displayed.

The letter will need to be created and the fields from the data source. Each month a new letter will be created with details about various sport activities. The same or amended information can be used.





Click the Payment reminder button on the main menu: The payment reminder template opens as new document.

Click the letter button on the main menu: The letter template opens as a new document.

The payment reminder

Once opened, fill-in field boxes will appear: Title, last name, number and name of street, town, county, and post code.

Once opened, fill-in field boxes will appear: Title, last name, address, town, county, post code. When the data has been entered and the ok button has been clicked, the data entered will automatically be placed in the appropriate location in the document. Once the data has been entered into the payment reminder, the formulae will automatically calculate: subtotal, VAT, total, grand total. When the print button is clicked a copy of the payment reminder will be printed.


Once the mail merge button has been selected, the data from each record in the data source will replace the field names in the document with the details needed in the letter. When the print button is clicked, the personalized letter will be automatically printed out for each member.





Suggested alternatives


The screen is required to see what you are clicking

It helps you to see what you are doing more easily

A document with a drop down menu could be created. A macro to open each template could be attached to the drop down menu options.

Payment Reminder

The screen helps you to see what data you enter and the printer prints out a copy of the completed payment reminder.

A copy of the completed payment reminder needs to be printed so that it can be sent to the sports members.

The colour printer produces quality hard copies, required for all documents


The screen helps you to see where the data should be entered and the printer prints out a copy of the completed letter

The mail merge will produce as many print out as there are records.

Sports club members like to have a hard copy of the letter to read at their leisure. They may not have a computer so emailing might not be appropriate.

E-mail might be an alternative but not all sports club members have that kind of technology. However all sports club members will obviously have an address, so a printed letter would be better to send.

Data Flow Diagrams


The Letter

The Payment Reminder

The Homepage

Security Requirements

* The homepage and all the templates will be loaded onto all the computers accessible to only staff members.

* A full system back up will be made to CD-RW using the computer manufactures back up utility to ensure the system can be restored in the event of a computer crash.

* The system and templates will be backed up to a CD-RW

* Any changes to the system or templates will require a back up to a new CD-RW

* Any files created from the system will be backed up to a CD-RW at the end of the working day.

* CD-RW backups will be stored either off site or in a locked fire-proof cabinet in the sports club staff room.

* Every time the computers are restarted, a security code will be used to log onto the computers.

* The sports club will use an alarming system, which is tested every week.

* Doors and windows will be locked using keys, which are kept by the Sport club Manager and qualified staff.

We can write a custom essay

According to Your Specific Requirements

Order an essay

You May Also Find These Documents Helpful

Athletes Privilege and Justice

You’re laying down in your bed unable to sleep, yet so tired and exhausted you can’t move a muscle. Your world has fallen apart. Why, you ask? Because the man that raped you is still out there having the time of his life outside of prison because he was never convicted. This struggle is all too real for many young women on college campuses today....

Building Character through Sports

I feel it is important for a person to make at least one sport a part of their life. This is because sports not only keep us healthy physically and mentally but also help to build a person’s character. No matter which sport a person takes up, it helps that person develop perseverance, patience, and humility. If it is a team sports like hockey or...

Coventry Sports Trust Limited

The purpose of this report is to advise Coventry Sports Trust Limited (CST) on the key considerations and their significance on the proposed appointment of a Human Resource Manager. The report will cover the various issues relating to new approaches in Human Resource management, procedures and practices for obtaining suitable employees, principles and procedures for monitoring and rewarding the employee, and employee exit from the...

Nab Wood Sports Centre

I am going to explain how ICT helps the functional areas of Nab Wood Sports Centre to work together. This Centre uses different ICT technologies to run this Sports Centre. These technologies are walkie talkie, Spreadsheet, fax machines, Microsoft processing packages, LAGAN system etc. Microsoft processing packages are used in the functional areas to email each other, to send a memo, write a letter, entering...

Marketing Plan Outline

A. Executive Summary             Classic Sporting Goods is a New York based corporation dealing with manufacture and distribution of high quality sports equipment and gear. This marketing plan outline provides a snapshot of strategies to be used in selling its new product, a ski that changes stiffness by detecting snow conditions, to different world markets. Though competitors are in the process of developing similar products,...

Get Access To The Full Essay
Materials Daily
100,000+ Subjects
2000+ Topics
Free Plagiarism
All Materials
are Cataloged Well

Sorry, but copying text is forbidden on this website. If you need this or any other sample, we can send it to you via email.

By clicking "SEND", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.
Sorry, but only registered users have full access

How about getting this access

Become a member

Your Answer Is Very Helpful For Us
Thank You A Lot!


Emma Taylor


Hi there!
Would you like to get such a paper?
How about getting a customized one?

Can't find What you were Looking for?

Get access to our huge, continuously updated knowledge base

The next update will be in:
14 : 59 : 59
Become a Member