Datakeepers First Steps

In this lesson, you will learn the basics of databases and create your own simple database called 'My Favorite Animals'.

Warning: Your screen size is quite small for viewing this. Rotate your device into landscape mode if you can.

1 Introduction to Databases
2 Access the Database Tool
3 Create a New Base
4 Add Columns
5 Enter Data
6 Sort Data
7 Filter Data
8 Share Your Database
Quiz

1 - Introduction to Databases

A database is a collection of information organized in a way that makes it easy to find, add, and update data. In this lesson, you'll learn the basics of databases and create your own simple database called 'My Favorite Animals'.

👇 Mark your steps as done as you complete them.

+10 XP

2 - Access the Database Tool

For this project, we'll use a free online tool called Airtable. First, go to Airtable website and sign up for a free account. Once you're signed up, you'll be taken to your Airtable dashboard.

👇 Mark your steps as done as you complete them.

+15 XP

3 - Create a New Base

In Airtable, a 'Base' is like a small database. Click on the 'Add a base' button and choose 'Start from scratch'. Name your new base 'My Favorite Animals' and click 'Create base'.

+20 XP

4 - Add Columns

Now you'll see a blank table. We'll add columns for our animal data. Rename the first column 'Animal Name'. Click on the '+' sign to add a new column and name it 'Type'. Add two more columns named 'Habitat' and 'Diet'.

+20 XP

123learn · Online learning platform

Unlock the full learning experience

You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.

Hundreds of curriculum-aligned lessons

Interactive activities in every lesson

Printable resources & progress tracking

Get started

Copyright Notice
This lesson is copyright of Coding Ireland 2017 - 2026. Unauthorised use, copying or distribution is not allowed.