• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Create a database.

Extracts from this document...

Introduction

Analysis I am a manager of a music store and I have decided to computerise my shop. I need to create a database that can hold all the information I need to know about my customers. I also want to set up a membership system so I can record the more regular customers. I have been running the store for a year, and by computerisation I hope to increase my profit and my output. The system I am using at the moment is sheets of paper that can record my input, output, profits etc. I also have to record my staff wages. I have a filing cabinet so I cam record all of the data I have collected. There are many problems with the existing system. The worst problem is the time it takes to do all the files. Also I sometimes loose the pieces of paper, meaning I loose valuable data and have to record it again. ...read more.

Middle

The computerised system will have all the software I need to be able to run my music store. It will have Microsoft Word, for writing letters and reports. I will have Microsoft Excel for databases where I can record my staff and profits. I will also be able to use the E-Mail services to send information to my staff. I can also use other software like PowerPoint to give presentations. When I have set up my system I can search for information on the database. I can do simple and complex searches: Simple I can search for what type of music the customers like to listen to. I can search for the last CD the customer bought. I can search for their address. I can search for people who have a shop within 2 miles. I can search for the most popular album of the week. ...read more.

Conclusion

I hope to expand this number, and the computerised system will help. I will also have about ten staff members, which I will need to record. I will need to perform many calculations. I will need to calculate my profits, wages, amount of goods sold and new stock bought. I should be able to do all of these calculations using formulae on my database. People who are going to use my database other than me, such as staff, will need to be able to understand it. Also they will need to be able to know how to use it. This includes searches, editing data and insert formulae. I chose the database over other software because it is simple quick and will save time and money. You can use formulae instead of having to work it out yourself. You can easily edit or insert data. Finally, you can search the whole database very easily to find what you want quickly. Key features in the database will be: formulae, searches, forms, and reports. Nick Shute 10SB I.T Mr John ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Smarts Leisure Park Database Booking System

    the corner and click properties: In then turned all dividing lines, scroll bars, and navigation bars off: After I had turned all of these off the form view then looked like this: After I had done this I must now design the layout of the form in general, in keeping with the designs that I have drawn.

  2. Designing a database to manage stock in a clothes shop.

    customers by telling them what season the clothes, in my case were manufactured in. This would attract more customers as the owner could provide important additional information like the supplier name and the product information for example the number of articles sold all over the world.

  1. Ict Powerpoint Coursework

    the presentation should be easy to read for all users - The presentation should be child friendly and be viewable for all ages ANALYSIS Hardware Image of hardware , Brand , Small amount of info Description of hardware Analyze of hardware (Advantages & Disadvantages)

  2. GCSE Database Project ICT

    Droplet size 3 Pl (minimum) with Variable-sized Droplet Technology Ink system Epson DURABrite(tm) Ultra Ink Print resolution Up to 5760 x 1440 optimised dpi on suitable media using RPM (Resolution Performance Management) Print speed Black text A4 Up to 37 ppm (Fastest), 25 ppm (Business quality)* Colour text A4 Up to 20 ppm (Fastest), 11 ppm (Business quality)* Photo 10x15 cm Approx.

  1. Organising the database at Costsloadsless.

    employee would remember the customers name, when it is due to be back in the store, so the employee would remember if that customer has to be fined, he/she would also need to remember if the customer is an member, so he/she remembers to advertise good offers out so they

  2. The purpose of my database is to help customer's choose which Music cd or ...

    FIELD NAME DESCRIPTION 1 CD ID Number of cd 2 CD NAME Name of cd 3 DATE OF RELEASE Date cd was released 4 POPULARITY Popularity of cd in percentage (number sold) 5 PERFORMER The performer of the album (singer/artisrt)

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