• 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. The purpose of this document is to define the Context of Cain Motors Information ...

    > It should be able to run searches, produce reports and add, delete records and query dates and vehicle records, so that reminders can be sent to customers. > Training will be given to Mr Cain and his employees individually so that they understand how to use the new system.

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

    Reports ? I could print my reports at any time and I could lay them out exactly as I wanted them to be orientated.


    medulla spinalis; while the white substance forms the bulk of the commissural portions of the nerve centers and the peripheral nerves. The Nervous System 6 Neuroglia, the peculiar ground substance in which are imbedded the true nervous constituents of the brain and medulla spinalis, consists of cells and fibers.

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

    Turnover and profits of Tesco in 1997-1998 The turnover and profits for the year ending 28th February 1998 were as follows: * Group Turnover (incl VAT) - �17.8 billion (�17,800 million), an increase of 18.7% on the previous twelve months.

  1. business plan and organise event

    This will help me to understand which game everyone preferred, and which was the most interesting. This will ensure that my event is run successfully. 2.2 - Primary research Primary research is the research which I do, a first hand collection of new and original information directly from the public i.e.

  2. Business options

    Norton also has a feature which gives the users the ability to monitor the health of their network which is very useful as it gives the necessary tools to view the health of the network as well as the security of the network.

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

    In the business culture, managers in Spain usually prefer to have accurate answers to questions and give precise instructions in order to minimize conflict which is seen as threatening. In addition, Spanish managers will rarely be convinced by other people's arguments during negotiations.

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

    Some people may be scared to voice their opinions. The reason why I haven't chosen to do a group discussion is because some people might not voice their opinions and most people might just agree with others to get out of it. Questionnaires Advantages: You get a lot of different people taking your questionnaire so you will get a wide range of answers.

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