OCR Cambridge Nationals in ICT Level 12 R

OCR Cambridge Nationals in ICT (Level 1/2) R 004 Handling Data Using Databases

What is a database? The database is probably the most widely used computer program. It is like an electronic filing cabinet. The benefit of storing data electronically is the ability to search and retrieve information in the blink of eye.

Databases This information available Databases couldisbeoften anything fromtoa multiple small listemployees, of allowing to quickly search for customerthem names and addresses to information. an index of the entire product range of a global company.

Databases and you Someabout Data examples you will of databases have been that stored could on contain a database your information since the are: day you were born. • Register Office (Births) • National Health Service • Banks • Mobile Phone companies.

Websites Many Sites websites like You. Tube oftenand use a ‘back-end’ database to store Meta. Cafe website elements use databases in a content management system, tosuch storeastheir Joomla. video libraries. Larger sites such as Amazon use databases to store and index all of the items they sell.

Games The games industry use databases in their game engines On mobile many game to allow the programmers to builddevices, game worlds, choose link to a database in order to from options and add apps characters. rank the top players.

Interrogating The ability ablerecords to search through amounts Finding twotoorbethree from a storelarge of millions canof data quickly is one the main advantages be done in a and few easily seconds andof saves businesses time of database software. and money as well as adding to employee efficiency.

Reporting Database software not only allows the user to add, store, edit and find information; they also allow the user to report information in the form of reports and graphs. This means lists, tables and searches can be presented in an easy to read format for presenting to a manager.

You will learn… How toto search modify a database in How tochoose create input forms and How test the data for accuracy How to use validation rules How toto and set data types. using existing complex databases. queries. menus. and produce reports. to prevent data errors.

Thank you for using this OCR resource Other OCR resources are available at www. ocr. org. uk To give us feedback on, or ideas about, the OCR resources you have used e-mail resourcesfeedback@ocr. org. uk