Y8 - 3 - Databases (Lesson 4: Forms)

What is a database?

• a collection of data types which is stored in a jumbled up way

• a collection of fields and columns which is stored in an unorganised way

• A collection of data or information which is stored in an organised way

Choose all examples of paper databases

• Diary

• Microsoft Access

• Phone Directory

• Search Engines

Choose all examples of computer-based databases

• Microsoft Access

• Bourne to Learn

• Search Engines

• Filing Cabinets

What is an advantage of a paper-based database?

• Doesn't need a power supply to use them

• Hard to correct mistakes to entered data

• They can be lost or misplaced

What is an advantage of a computer-based database?

• Expensive to setup

• Easy to sort data into different orders

• They need power to run

Used as a place to store specific information held in a database

• Database

• Field

• Record

All the data about a single person or object.

• Record

• Field

• Table

All the fields and records are stored together here

• Field

• Data Type

• Table

Currency, Date/Time, and Text are all examples of...

• Records

• Fields

• Data Types

Which data type is used to store data about money

• Currency

• Text

• Money

• Date/Time