×

Objectives

Students will be able to:

  • understand that databases power the Internet
  • understand that databases are composed of records and fields
  • be able to design a table with an appropriate primary key
  • be able to design basic search queries using and and or
 

Databases

Databases are everywhere. You probably interact with them everyday.

For example, think about Twitter (now known as X). Where are all the tweets stored? Where are all the users' details stored?

A database!

In this unit we will take a look at the general nature of databases.

This unit will introduce you to the basic concepts of database technology:

  • tables, records and fields
  • search queries and filters
  • grouping and sorting data
  • calculated fields
  • data validation
  • data verification

Setup

Windows users may use Microsoft Office. The common applications that everyone uses are MS Word and MS Excel.

But there is another amazing application that fewer people use - MS Access.

MS Access allows you do design database management systems on your computer.

In this course, we will use an online sandbox to design database management systems. Click the button and create an account.

Units