Year 8 - Term 2A Home Learning

To store and organize data efficiently

To create graphics and images

To browse the internet

To write and edit documents

To keep record of things

So we can look through it when needed

To make information harder to find

To find something easily

To store data

To give each record a unique identifier

To organize data into columns

To allow multiple records with the same code

Stores data on physical paper

Requires manual updates

Stores data digitally for easy access and searching

Is more prone to errors

Stores all data in a single table

Organizes data into multiple linked tables

Is more prone to errors

Allows complex data management

A field that stores text data

A unique identifier for each record

A type of data that can be stored

A field that stores dates

Number, Text, Autonumber, Date/time

Image, Sound, Video, Animation

Book, Article, Journal, Magazine

Circle, Square, Triangle, Rectangle

Text

Number

Date/Time

Autonumber

Usually consists of numbers

Can be repeated across records

Used to access specific records in a database

Includes the word 'ID' after the name

A primary key is a unique identifier for each record, ensuring each record can be recognized and referenced.

A primary key is a type of data that stores names and addresses.

A primary key is a password used to access the database.

A primary key is a shared value among multiple records.