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

database intro

Extracts from this document...


ICT COURSEWORK This coursework will include the following detail and steps that were used by me to implement this database. This will consist of five sections: * Identify: This will include the problem, which is a brief overview of why the company's data should be looked up automatically, the users, the alternative solutions and the quantitative objectives. * Analyse: I will be explaining the hardware and software, the back up system and security of the database. I will also be showing the flow diagram of how the database I made. * Design: this will include the initial design, final design the user comments and the test plan, which is used to test the reliability of the coursework. * Implement: this will include the evidence of error correction, of testing and of the problem solutions which forms part of the design. * Evaluation: this will include the evaluations of the objectives, the user comments and the further improvements which can be made to enhance the database. Identify Introduction: Saqib video store is a medium size rental shop, which is located in Wimbledon, it's been open since the year 1999 and has been a successful investment ever since. The opening of the video store was a huge success and attracted many people. The shop rents out numerous films of every genre at different price range etc. It consists of at least 5000 loaned videos, 50 members of staff at different job status and about 100 customers that have signed up to this video store. ...read more.


Real User The real users are the staff members of the video shop. The reason for that is because that they are the ones who are going to be using the system. Why is ICT a suitable way of solving this problem: Why is ICT a suitable way of solving this problem: Using an ICT solution will be a suitable way of solving this problem because it is quicker, easier and more accurate to use. Data can be saved on the computer; this allows you to print lost data easily. You can keep large amounts of information in a small place. Searching for records will be quick and fewer staff will be needed to look after the system. A computerized system would save time, would look far more presentable than a paper based one and be more accurate A paper based system is time consuming and errors can be made easily. Duplicates of mistakes on a hand written system are likely and the system would have to be rewritten, which will waste Illegible handwriting would be hard to read and could create errors and confusion. I am going to use a Mc Access so that I can create a database that will store necessary details and allows easy input of data. It will enable to sort and filter information and provide useful reports. It would be easier to create registered forms and input them within the database. ...read more.


MS Excel is a spreadsheet based program which allows you to get the most out of your data. The tools within the software are great and enable you to analyze, capture ad share information which can be protected and controlled more efficiently. Data can be put into charts, graphs and tables. MS Excel has a range of functions (e.g. SUM) that let you analyze numerical information accurately. Microsoft Access (Ms Access) Microsoft Access allows you to create powerful databases solutions that let you analyze, organize and share information more effectively, quickly and easily. Tables from other MS Access and MS Excel files can also be linked to your work checking feature allow common errors in form and reports ,to be tested and fixed faster and if you alter a field is bound to be updated automatically. Most often Access databases are used for mailing lists, phone lists and as address books. Access is a relational database management system that can allow the use of complex searches such as queries. I have chosen the software Microsoft Access: Access is the preferred software over other types of software because of its capability to create complex searches called queries, produce reports, and convenient data entry forms. The database created on Access can also be made relational to link files together and further improve it. Mistakes are limited because of the many and useful validation checks like presence checks, length checks and character type or format checks. The database can also be made password protected to ensure its security. ?? ?? ?? ?? Iram Ahmad Database Coursework Yr 11g ...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 Software 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 Software essays

  1. Planning a spreadsheet database for a gun shop.

    In the spreadsheets that I will be designing I will need to include weekly sales report, monthly sales report, annual sales report, stock control, Vlookup formula. Hardware: I will need a standard computer with the following specifications, 1 GHz 32-bit (x86)

  2. AQA GCSE ICT Specification B

    B: Return to main menu C: Exit 8. View previous orders 9. (Go to 5.) 10. Dates entry form displayed 11. Enter start date 12. Enter end date 13. View Sales summary 14. Choose option: A: Print sales summary B: Return to main menu C: Exit Implementation Hardware and Software Required Hardware Required Acer Extensa 26+17" * Intel Celeron D 430 Processor * (1.8GHz, 800MHz FSB, 512KB Cache)

  1. Youth Club Database Solution

    # symbol being a wildcard for the columns, and the same formula appears in the columns L and N to W. There is a different formula that appears in Column M, and is for working out the average attendance of all the Youth Club members throughout the term or year.

  2. Evaluating a relational database solution

    In Microsoft Access it was easy to do queries because all of the fields I needed to search for information in were laid out into a neat table and I could easily tell where to type the information I was looking for.

  1. Project 1a. ICT

    Third Step: Now, my third step is even simpler, as I have just filled in the text boxes with my full name and form and the title of my full project 1a. My project is in the font of Arial as this gives the child an easy font to read.

  2. Setting up a database in microsoft access.

    I made an empty validation test plan sheet so that you could see what my column titles were and what the table looked like before I had completed filling it in. Testing Queries - I created test queries so that I could be certain that it worked, and my results for these queries would be correct.

  1. Research, collect and describe graphics

    Purpose To show icons which are relevant to subject, act user friendly... To use a symbol to reinforce the horoscope selected, to also link to the original website where the horoscope info. was derived from: www.tarot.com Use of icons to allow user to quickly choose their option w/out reading, to show it's the weather.

  2. GNVQ intermediate ict unit 4

    When I finished drawing the button a macro window opened up called "Assign Macro". I clicked on the Record button and this window opened up I clicked OK. A small widow opened up (shown below) to let me record the macro.

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