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

Introduction

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.

Middle

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.

Conclusion

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. Creating a Database Coursework

    A reason for this could be the customer has become married; therefore the surname will have to be altered for legal purposes. Also, the customer may have moved house so, the Address will have to change to the current one in use. Creating a Simple Query What is a query?

  1. Database design for a games shop.

    It cuts out the mistakes which will aid blockgamester if they are in a rush or forget to enter something. Data validation Data will be validated before it can be stored in the laptop. Common mistakes like a telephone number which have 11 digits, if by mistake there are not 11 digits an error message will appear.

  2. Database Review of Document

    In this way I can ensure that with the validation rules and training, the data contained within the database is reliable and meaningful. With the improved validation rules, it would easier and faster to pull out information when required. V)

  1. Reviewing different multimedia presentations.

    When you hover your mouse over the braking section it shows you an image of the braking system. How easy was it to understand what you had to do? To begin with it was quite easy to find out what to do but when I wanted to go back to

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    Once I had selected my specific range I clicked the square icon again, to maximise the box on the screen. In the criteria box, I typed in what I wanted it to count, in this case I wanted it to count all the percentage which were greater than or equal to 70%, so I typed in ">=70%" and pressed ok.

  1. bookings database

    Other than the improvements I have mentioned, there are no other improvements I would make to the form. Task 5- Main menu Performance criteria-quantitative Quantitative performance indicators Have I done it? Output will be on screen Yes Screen title is Main Menu Yes Room availability command button (input)

  2. AQA GCSE ICT Specification B

    Characters - - - - Yes No No - John Date Date/Time Short Date 00/00/0000 Short Date =Date() Today's Date Yes No No - 11/03/2008 CustomerSurname Text 20 Characters - - - - Yes No No - Simpson CustomerTitle Text - - - - Table Lookup Check Yes No No

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