• 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


    It is in the former that nervous impressions are received, stored, and transformed into efferent impulses, and by the latter that they are conducted. Hence the gray substance forms the essential constituent of all the ganglionic centers, both those in the isolated ganglia and those aggregated in the brain and

  2. Business options

    However if you just want standard protection then you can just install the program and leave it. Q. Does it matter if you use a wireless network? Are there any constraints on what kind of internet security you can use or do they all work the same?

  1. The Entourage System: A Feasibility Study

    All three options have been carefully considered and AB Software Solutions Co. highly recommend the Advanced Systems Option. The recommended registration fee for a casting director is �250 per user per year. From our analysis (see Appendix 2), this is a figure that should attract sufficient numbers of users to

  2. ICT Coursework Two - Database Project

    Data Type Field Size Validation Description Customer ID Text 7 Input mask: LL00\0900 Members chosen ID number Surname 20 -- Members Surname (Alphabetic order) Forename 50 Members Forename Telephone 13 Input mask: 0\ 20\-0000\-0000 Member's telephone number Gender 1 Input mask: L "M" or "F" Member's gender (M or F)

  1. In this report I intend to create a detailed report of Tesco's.

    Berry when I visited Tesco. Tesco has a bad reputation for quality this is most probably down to its very cheap prices but for your money you are actually getting a high quality product. They have an economy range which sells food extremely cheaply they also have a "finest range" which is slightly more expensive but is to a very much higher standard.

  2. The purpose of this document is to define the Context of Cain Motors Information ...

    Systems Impact: The booking system can run independently of the existing database. The system will be loaded as part of a new version; data migration from the manual records will be required. Staff will require some training to use the new system.

  1. Converting a Formerly Paper Based System to Excel

    All the calculations should be made by the system. To make this as simple as possible it should be done by number reference to a menu. All the calculations should be made by the system. They should then be printed so they can be used as receipts.

  2. 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.

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