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

Lewis Healthworks Customer Management System

Extracts from this document...


IDENTIFY I have decided to create a database containing customer information for Lewis Healthworks. This will keep individual records on each customer in an organised and easily accessible format. My database will hold: * Information on my customers * Information on the different types of classes Healthworks offer * Details of which members are attending what class It is incredibly important to "know your customer" and my database will allow for this. In addition, the centre will potentially make more money, as they will be able to advertise classes in a more direct manner, as they will have a target audience, thanks to the customer information held on the database. The database package I will be using is Microsoft Access, which is part of Microsoft Office 2000. This program is very widely used among businesses and comes as standard with the vast majority of computers on the market. It is also extremely easy to use. Furthermore, it will be sensible to stick to Microsoft, as the spreadsheet that I have already created for Lewis Healthworks was produced in Microsoft Excel. I will be using a Pentium III network computer and a laser printer, as this will allow me to produce high quality print out of a database. Furthermore, I will be using a RAM, which takes up 128k, and a Hardisk, which takes up 10Gb. There are two types of database - flat file and relational. A flat file database consists of only one set of data and is very simple. Examples of flat file databases are Pinpoint and Microsoft Works. A relational database is more complex and it is the one I will be using. It is very powerful, and can hold large amounts of data that can be accessed in many different ways. Microsoft Access is an example of a relational database. In larger databases, where many users are accessing the data at the same time, complex software, called DBMS (Database Management System) ...read more.


I will then ensure that I do not accidentally change any details that may affect the relationships. DESIGN: Why is it important to have each category of data in my system? Members Table: The membership number is essential in this table because it is the primary key that allows the relationships to exist. It also makes each customer record individual - there will be no two customers that have the same membership number. The remaining categories serve the purpose of allowing the center to have numerous ways in which they can contact the customer. They can ring to adjust bookings or just as easily send information to their home or e-mail address. Classes Table: Similarly to the membership number in the members table, the class reference number is also a primary key and is essential in linking the three tables together. The remaining categories are general information of the classes that the customer is likely to want to know when he or she makes a booking. Bookings Table: This is where the customer actually makes a booking, so therefore this is where the tables are linked and there are three primary keys. The membership number of the customer that is making the booking, the class reference of the class they wish to book and in addition the date they wish to book the class for. There will not be two bookings where all this information is identical. The remaining categories in the table are not essential, but just provide the customer and center with extra information that makes the booking more clear. Will my system be successful? At this moment I am pretty sure that my system will be successful. I have taken all potential problems into consideration. The only issue that may have to be addressed in the future is whether the workers at Lewis Healthworks will be able to operate the system. ...read more.


I think that the easy layout of the system makes it very user friendly. The front page and the use of macros are very helpful. I would give it an 8/10 again. I cannot find anything particularly confusing, but I do feel that if I did not have a prior knowledge of Microsoft Access, then I would have some difficulties with familiarising myself with the system. Do you think that this type of system would be of benefit Lewis Healthworks? Is it better than the current system? I myself find the current system very hard to use and often get frustrated with losing important papers with customer information. I feel that this system would be much easier to use and would help Lewis Healthworks become more technology - orientated. After all, we are in the 21st Century! Computers are everywhere! Are there improvements that you would make to the system? As far as I can see, the designed system covers the vast majority of the aspects the paper based data system has. However, I do not think that all the features of Microsoft Access are used to their full extent. For example, I would recommend that mail merge is integrated into the system because, at Lewis Healthworks, we do send out many letters. Therefore, overall, what rating would you give the effectiveness of the system? I would definitely give it no lower than an 8/10. I sincerely hope that Lewis Healthworks implement a similar system as soon as possible. I asked my user to attempt to create a query to find customer information on all the male members. A print out of the query is provided after this sheet. I asked my user how easily they created they this query. I found the creation of the query incredibly easy. The easy layout of Microsoft Access helped me a great deal, and I was able to interrogate the data, and get the information I needed in less than two minutes. I.T coursework Jake Hickie ...read more.

The above preview is unformatted text

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

  1. Evaluation of a database set up in microsoft access.

    Field sizes/types/properties ? I used field type and properties in every field, so that they could only certain pieces of information if needed. ? I could chose what other people inserted into the fields. ? And I could make the information inserted have validation rules which restrict what information can be edited.

  2. business plan and organise event

    Also once I have conducted the interview I would need to analyse all the interviews and write a report on the information which I have found out. 2.3 - Market Research If I want my tournament to be successful I will need to find out what my target market are


    The nervous tissues are composed of nerve cells and their various processes, together with a supporting tissue called neuroglia, which, however, is found only in the brain and medulla spinalis. Certain long processes of the nerve cells are of special importance, and it is convenient to consider them apart from the cells; they are known as nerve fibers.

  2. In this coursework I need to produce a detailed business report on one medium-sized ...

    Examples: hundreds of MultiSave, Link Save and Special Offer promotions in all stores every month. Product range Objective: to give customers what they want under one roof. Examples: constant development of new and exciting food products; introduction of clothing, CDs and videos.

  1. Business options

    I also used CNET to find user reviews so that I could read about how the software is used by casual internet users. These sources were very useful because not only did they give general information about the software but they also gave information about how the software operates on a day to day basis.

  2. Concepts & Principles of International Management - Management Style Manual & Survival Guide for ...

    Thus, most Spaniards will look for support and approval of family, friends and co-workers before acting on their own. The Spanish believe if you are not a part of a group, neighbourhood, town or business organisation then you are not an integral part of society.

  1. Estate agent.I will be creating a system that will help my client to let ...

    The details of the house they wish the estate agent to sell must be taken down. Processes: The customer's details must be written down. The house details must be taken down. The house must be designated to an employee. Outputs: The workload of the employee will be up.

  2. The purpose of the new system is to extend the current computerised room booking ...

    external room booking form from Estates Department and they will fill it and send it back to Estates Department. Then the Estates Department will send that form to the person who is allocated that room, if the room is available the 'owner' will sign that form and send it back to Estates Department.

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