Database Intro
Computers are great at storing data! and I mean any kind of data!
Computers store large amounts of data. One option is to store data in spreadsheets. These is often used when calculations are needed eg sales data or staff salary data.
Websites also rely on data being stored. For example, a social networking site will store information about people, their hobbies, their contact list, their posts and likes. This data is stored in a database.
In this intro course, you will learn how to:

set up a database table

understand datatypes

enter, delete and edit data

use sorting and filtering techniques

design queries

create forms

create a simple Graphical User Interface

A social website uses a database to store data about its users. Here is some of the data.
A Social Website
ID First Name Last Name Nickname Favorite Food Likes
1 Yukiko Yamaguchi Yuki spaghetti 32
2 Xa Ling Xaxa chocolate 15
3 Su Yang Suya chocolate 13
4 Baz Faulkner Baz spaghetti 31
5 William Frouge Billy ice-cream 17
6 Georgina Nguyen George ice-cream 43
How many people like spaghetti?
Who got the most likes?
How many people are in the database?

Good database software will allow us to answer these questions quickly if we know the techniques.
Watch this video to learn the basics of sorting and filtering data in a database.
Task! Download "Social Net" and open it in Microsoft Access.
If you can't open the file in your database application, try downloading "Social Net 2". It is a csv file. Try importing it into your database application.
Open an evidence document, eg a Google Doc, and paste screenshots of these tasks:
  1. 1. Sort the data in ascending order of Likes
  2. 2. Screenshot the result and save it in a document eg a Google Document
  3. 3. Sort the data in ascending order of Favorite Food
  4. 4. Screenshot the result and save it in your document
  5. 5. Filter the data to show only records of people who like orange juice
  6. 6. Screenshot the result and save it in your document
  7. 7. Tricky! Filter the data to show only people who like cola AND spaghetti
  8. 8. Screenshot the result and save it in your document
  9. Very Tricky! Can you figure out how to create a pie chart showing how many people like cola, orange juice and coffee?