Day 2 - Hours 1-2

Hour 1-2: Introduction to Airtable Bases, Tables, Views, and Fields

Part 1: Explanation of Airtable Bases, Tables, Views, and Fields

Airtable Bases: A base is a collection of related tables that work together to store and organize your data, similar to a database.

Airtable Tables: A table is a collection of records (rows) and fields (columns) that store your data, similar to a spreadsheet.

Airtable Views: Views are different ways to visualize and organize the data in your table. They can be filtered, sorted, and grouped according to your needs.

Airtable Fields: Fields are the columns in a table that store individual pieces of data. Each field has a specific type, such as text, number, date, or attachment.

Part 2: Real-world examples to illustrate the concepts

Base example: A project management base that includes tables for tasks, team members, and clients.

Table example: A "tasks" table in the project management base with records for each task and fields for task name, assignee, due date, and status.

View example: A "completed tasks" view in the tasks table that filters and shows only the tasks with a "completed" status.

Field example: A "due date" field in the tasks table that stores the date when a task is due.

Part 3: Hands-on exercise: Creating a base and adding tables

Step 1: Sign in to your Airtable account and click "Add a base."

Step 2: Choose "Start from scratch" and give your base a name (e.g., "Project Management").

Step 3: Click on the newly created base, and you'll see a default table named "Table 1." Rename it to "Tasks."

Step 4: Add two more tables to the base by clicking the "+" icon next to the "Tasks" table. Name them "Team Members" and "Clients."

In this hour, students will learn about the fundamental concepts of Airtable, including bases, tables, views, and fields, through explanations and real-world examples. They will also get hands-on experience by creating a base and adding tables to it.

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.