1. What is a database?
- What students do
- Explore a lesson database from the catalogue.
- Tutorial / start
- Explore lesson databases
A free, browser-based database workspace for introductory lessons—no account or installation needed.
Use it in a browser on school computers and Chromebooks. After the first online visit, DB Studio also works offline.
Adapt the order and pace to your class. This sequence moves from exploring a database to building and handing in a small project.
| # | Lesson | What students do | Tutorial / start |
|---|---|---|---|
| 1 | What is a database? | Explore a lesson database from the catalogue. | Explore lesson databases |
| 2 | Create a database and a table | Create a database, add a table and choose field types. | Create a databaseCreate a table |
| 3 | Keys and field rules | Set a primary key, edit field properties and try validation rules. | Open DB StudioCreate a table |
| 4 | Work with records | Enter, sort, filter and find data in a datasheet. | Open a lesson database |
| 5 | Lookups and relationships | Connect tables with lookup fields and relationships on a computer. | Open DB StudioCreate a table |
| 6 | Queries: criteria and sorting | Design a query with criteria and sorting, then save it. | Create and save queries |
| 7 | Forms for data entry | Design a form on a desktop; students can also enter data on phones. | Open DB Studio |
| 8 | Reports: groups and totals | Group records, add totals and print with the browser or save as PDF. | Open DB Studio |
| 9 | Project: build a small database | Build a project such as a school library, then export it to hand in. | Save and reopen a database |
Designing tables, relationships, queries, forms and reports requires a desktop computer. Phones and tablets can view and enter data, run SQL and run saved queries.
The catalogue contains three CC BY 4.0 lesson databases. Each opens as an independent copy, and a database works offline once downloaded.
Open the lesson catalogue