A free Access alternative for introductory database lessons

For schools without Access licences and students working on Chromebooks, Macs, or a home computer, DB Studio provides a browser-based way to learn introductory database concepts. It is not a full replacement for Microsoft Access.

Students can practise tables in design view, Access-style field types, primary keys, the Lookup Wizard, relationships, a query designer, forms, and reports.

DB Studio table design view showing fields, field types, and properties
The table designer uses familiar database concepts; the interface can be switched between English and Ukrainian.
Comparison for introductory lessons

Comparison for introductory lessons

Comparison of DB Studio, Microsoft Access, and LibreOffice Base
CapabilityDB StudioMicrosoft AccessLibreOffice Base
Cost and installFree (Runs in the browser)Paid (Microsoft 365, Windows desktop app)Free (Desktop install (Windows, macOS, Linux))
Works on Chromebooks/tabletsYes (In a modern browser; designers need a desktop)No (Windows only)No (Desktop install only)
Tables, field types, primary keysYes (12 Access-style types)YesYes
Relationships with referential integrityYesYesYes
Visual query designerYes (Select, update, delete, append, make-table; no crosstab)Yes (Includes crosstab)Yes
SQLYes (SQLite SQL with hints for Access syntax)Yes (Access SQL)Yes (HSQLDB/Firebird SQL)
FormsPartial (Form designer with basic controls and subforms)Yes (Full form designer)Yes
ReportsPartial (Report wizard with grouping and totals; simple column layout; print via browser)Yes (Full report designer, PDF export)Yes (Report builder)
Macros and VBANo (Not supported)YesPartial (Macros in LibreOffice Basic)
Works offlinePartial (After the first online visit)YesYes
Ukrainian interfaceYesYesYes
Where data is storedPartial (In this browser on this device; export to .sqlite)Yes (A .accdb file you save)Yes (An .odb file you save)

Cost and install

DB Studio
Free (Runs in the browser)
Microsoft Access
Paid (Microsoft 365, Windows desktop app)
LibreOffice Base
Free (Desktop install (Windows, macOS, Linux))

Works on Chromebooks/tablets

DB Studio
Yes (In a modern browser; designers need a desktop)
Microsoft Access
No (Windows only)
LibreOffice Base
No (Desktop install only)

Tables, field types, primary keys

DB Studio
Yes (12 Access-style types)
Microsoft Access
Yes
LibreOffice Base
Yes

Relationships with referential integrity

DB Studio
Yes
Microsoft Access
Yes
LibreOffice Base
Yes

Visual query designer

DB Studio
Yes (Select, update, delete, append, make-table; no crosstab)
Microsoft Access
Yes (Includes crosstab)
LibreOffice Base
Yes

SQL

DB Studio
Yes (SQLite SQL with hints for Access syntax)
Microsoft Access
Yes (Access SQL)
LibreOffice Base
Yes (HSQLDB/Firebird SQL)

Forms

DB Studio
Partial (Form designer with basic controls and subforms)
Microsoft Access
Yes (Full form designer)
LibreOffice Base
Yes

Reports

DB Studio
Partial (Report wizard with grouping and totals; simple column layout; print via browser)
Microsoft Access
Yes (Full report designer, PDF export)
LibreOffice Base
Yes (Report builder)

Macros and VBA

DB Studio
No (Not supported)
Microsoft Access
Yes
LibreOffice Base
Partial (Macros in LibreOffice Basic)

Works offline

DB Studio
Partial (After the first online visit)
Microsoft Access
Yes
LibreOffice Base
Yes

Ukrainian interface

DB Studio
Yes
Microsoft Access
Yes
LibreOffice Base
Yes

Where data is stored

DB Studio
Partial (In this browser on this device; export to .sqlite)
Microsoft Access
Yes (A .accdb file you save)
LibreOffice Base
Yes (An .odb file you save)

Comparison reflects DB Studio version 0.1.0 and general product descriptions of Access and Base for introductory lessons; check those products' current documentation.

Opening Access files

Opening Access files

Imported

  • Tables and their data
  • Field types
  • Simple Number, Currency, and percent formats
  • Lookups (table or value list)
  • Relationships — enforced only when Access enforced them and the data is clean
  • Image attachments

Not imported

  • Queries, forms, reports, macros, and VBA modules
  • Primary keys other than AutoNumber
  • Indexes, validation rules, default values, and cascade options
  • Non-image attachments and OLE objects
  • Linked tables

For a guided walkthrough, see Import an Access file into DB Studio

Encrypted or password-protected files are refused. The whole file is read into memory, so very large files may not open. Nothing is uploaded; import happens in your browser.

Rebuilding queries in the query designer can be a useful learning exercise.

When to choose Access or Base instead

When to choose Access or Base instead

A desktop database may be the better fit if you need:

  • Macros or VBA
  • Complex forms and reports
  • Crosstab queries
  • Multi-user files on a shared drive
  • Exact Access compatibility
Learn it step by step
Frequently asked questions

Frequently asked questions

Can I save back to .accdb?
No. Export a .sqlite database, CSV, or SQL instead.
Will my Access queries work?
Access queries are not imported. Rebuild them in the query designer; SQL hints can help with Access syntax.
Is my file uploaded?
No. The import happens in your browser, and database contents never leave your device.
Can I use it at home without installing anything?
Yes. Open DB Studio in a modern browser; after the first online visit it also works offline.
Can I import or export Excel files?
No Excel import or export is available. You can export CSV.