Rutba Office · Data Files

Data Files, a free alternative to Microsoft Access

Data Files is the database in Rutba Office, free for home and business use. A database is one file of related tables, with the queries, forms and reports you build on them. It comes with Data Files apps ready to use: ready-made databases for contacts, stock, members, customers and a lending library, and sample businesses from a corner store to a guest house. If your records live in Microsoft Access, in dBASE or FoxPro files, or in a spreadsheet that has outgrown itself, Data Files brings the tables and records across, and you build the rest in its own designers.

Data Files in Rutba Office
File one .rbase file Imports Access, dBASE, CSV, workbooks Ready to use Templates and sample businesses Opens SQLite, read only Shared records PostgreSQL, MySQL, MariaDB Price Free for home and business Licence AGPL 3.0 + commercial
Watch the film · 1:22

Rutba Office Data Files: a free database for when a spreadsheet is not enough

Data Files in Rutba Office starts you on a working database for a business like yours: twenty-five sample businesses, each with a year of invented records or empty for your own, and a Start Here guide.

Plays from YouTube, with English subtitles. Nothing is loaded from YouTube until you press play. Watch it on YouTube, or see more films on the Rutba Office channel.

Data Files apps

Apps ready to use, and yours to change

Most people who open Access want an app, not a blank database. Data Files comes with them: each one has its tables, forms, queries and reports built and working. Use it as it is, or change any part of it in the same designers you would use for your own. Rutba Office keeps the designs up to date by itself.

Ready-made databases

Start empty, with the design already done

  • Contacts, an address book
  • Inventory: suppliers, products and stock movements
  • Membership: members and their payments
  • Customers and sales: companies, people, opportunities and activities
  • Lending library: books, borrowers and loans

Each comes with a form for each table, the queries it needs and its reports.

Sample businesses

A whole business, with a year of invented records or none

  • Twenty-five of them, from a corner store, a café and a pharmacy to builders, a clinic, lettings and a guest house
  • Tables, forms, queries, reports and print templates for the paperwork that business sends
  • Open one with its records to see how it works, or empty to start using it

The sample businesses on office.rutba.io

Data Files on office.rutba.io, with its films and templates together

Watch the films

The ready-made databases, on film

Contacts: a free ready-made address book in Rutba Office Data FilesContacts is one of the five ready-made databases in Rutba Office Data Files: an empty address book for your own people.
Inventory: a free ready-made stock database in Rutba Office Data FilesInventory is one of the five ready-made databases in Rutba Office Data Files: an empty stock list with your suppliers and every movement in and out.
Membership: a free ready-made members database in Rutba Office Data FilesMembership is one of the five ready-made databases in Rutba Office Data Files: an empty list of members, what they have paid and the renewals coming due.
Customers and sales: a free ready-made customer database in Rutba Office Data FilesCustomers and sales is one of the five ready-made databases in Rutba Office Data Files: the companies you sell to, the people there and the deals in hand.
Lending library: a free ready-made library database in Rutba Office Data FilesLending library is one of the five ready-made databases in Rutba Office Data Files: books, borrowers and loans, for a school, a club or an office shelf.

Plays from YouTube, with English subtitles. Nothing is loaded from YouTube until you press play. More films on the Rutba Office channel.

Watch the films

The Data Files apps for each kind of business, on film

Retail and food

Larkspur Corner Store: a free shop database in Rutba Office Data FilesLarkspur Corner Store is one of the free sample databases in Rutba Office Data Files: an invented neighbourhood shop with a year of trading and over twenty thousand receipts.
Bramblegate Wine and Deli: a free database for a shop that sells by dateBramblegate Wine and Deli is one of the free sample databases in Rutba Office Data Files: an invented deli and wine shop where stock lives in batches, sold earliest date first.
Little Fig Cafe: a free cafe database with recipe costing in Rutba Office Data FilesLittle Fig Cafe is one of the free sample databases in Rutba Office Data Files: an invented all-day cafe with eight staff.
Saffron Lane Pizza and Curry: a free takeaway database in Rutba Office Data FilesSaffron Lane Pizza and Curry is one of the free sample databases in Rutba Office Data Files: an invented takeaway with phone, walk-in and online orders and its own drivers.
Hazel Row Flowers: a free florist database in Rutba Office Data FilesHazel Row Flowers is one of the free sample databases in Rutba Office Data Files: an invented florist with a shop counter, deliveries, weekly contracts and weddings.
Tansy Row Pharmacy: a free pharmacy records database in Rutba Office Data FilesTansy Row Pharmacy is one of the free sample databases in Rutba Office Data Files: an invented community pharmacy keeping stock by batch and expiry.

Trade, making and building

Northbank Trading: a free order to invoice database in Rutba Office Data FilesNorthbank Trading is one of the free sample databases in Rutba Office Data Files: an invented wholesaler of specialty foods.
Granite and Grain Woodworks: a free furniture workshop database in Rutba Office Data FilesGranite and Grain Woodworks is one of the free sample databases in Rutba Office Data Files: an invented furniture workshop that makes to order.
Kilnside Builders: a free database for a building firm in Rutba Office Data FilesKilnside Builders is one of the free sample databases in Rutba Office Data Files: an invented building firm doing extensions, lofts and kitchens.
Copperbeech Motors: a free used car dealer database, in detailCopperbeech Motors is one of the free sample databases in Rutba Office Data Files: an invented used car dealer.

Services

Marigold Hair and Beauty: a free salon database in Rutba Office Data FilesMarigold Hair and Beauty is one of the free sample databases in Rutba Office Data Files: an invented salon with stylists, therapists, a retail shelf and gift vouchers.
Copper Pole Barbers: a free barber shop database in Rutba Office Data FilesCopper Pole Barbers is one of the free sample databases in Rutba Office Data Files: an invented barber shop with walk-ins, bookings, loyalty cards and self-employed barbers who rent a chair.
Ironbridge Repairs: a free repair shop database in Rutba Office Data FilesIronbridge Repairs is one of the free sample databases in Rutba Office Data Files: an invented repair shop for phones, tablets, laptops and small appliances.
Quarrybank Motors: a free garage database for MOTs and servicesQuarrybank Motors is one of the free sample databases in Rutba Office Data Files: an invented garage doing MOTs, services and repairs.
Fernhollow Cleaning: a free contract cleaning database in Rutba Office Data FilesFernhollow Cleaning is one of the free sample databases in Rutba Office Data Files: an invented cleaning firm with office contracts, one-off jobs and a team of cleaners.
Bramble Studio: a free time and projects database for a studioBramble Studio is one of the free sample databases in Rutba Office Data Files: an invented design studio working on fixed fees and by the hour.
Tannery Yard Fitness: a free gym membership database in Rutba Office Data FilesTannery Yard Fitness is one of the free sample databases in Rutba Office Data Files: an invented gym with members on monthly plans, a class timetable and personal trainers.

Health, education and community

Cedar Lane Clinic: a free private clinic database in Rutba Office Data FilesCedar Lane Clinic is one of the free sample databases in Rutba Office Data Files: an invented private clinic that bills its patients and their insurers.
Lantern Learning Centre: a free tuition centre database in Rutba Office Data FilesLantern Learning Centre is one of the free sample databases in Rutba Office Data Files: an invented tuition centre with after-school classes, holiday courses and evening classes.
Rowanmere Community Trust: a free charity and members databaseRowanmere Community Trust is one of the free sample databases in Rutba Office Data Files: an invented community charity with members, supporters, events, volunteers and grants.

Property, hospitality and the office

Hollybrook Lettings: a free landlord database for homes and shopsHollybrook Lettings is one of the free sample databases in Rutba Office Data Files: an invented landlord with flats, houses, shops and workshops in one rent roll.
Fernleigh Estates: a free estate and letting agent databaseFernleigh Estates is one of the free sample databases in Rutba Office Data Files: an invented estate and letting agent that sells homes, lets them and manages them for landlords.
Gullhaven Guest House: a free guest house database in Rutba Office Data FilesGullhaven Guest House is one of the free sample databases in Rutba Office Data Files: an invented seaside guest house taking bookings directly and through booking sites.
Copperfield House: a free front desk database in Rutba Office Data FilesCopperfield House is one of the free sample databases in Rutba Office Data Files: the front desk of an invented office building, with nine companies on seven floors.
Wrenmoor Garden Centre: a free staff and payroll database in Rutba Office Data FilesWrenmoor Garden Centre is one of the free sample databases in Rutba Office Data Files, for a business with staff: about thirty people at an invented garden centre.

Plays from YouTube, with English subtitles. Nothing is loaded from YouTube until you press play.

What it does

The work you built in Access, in a free app

The jobs a small business gives a desktop database are the same everywhere: keep the records, find them again, put them on a screen people can type into, and print them. Data Files does those jobs with designers you drive with the mouse, and SQL when you want it.

Tables

  • Fields you design, with required, unique and default values
  • Relationships between tables
  • Typing, sorting and filtering records

Queries

  • Criteria, totals and calculated columns
  • Joins across related tables
  • An SQL view when you would rather type it

Forms

  • Laid out in Design, where you place each field
  • Pick-lists and search
  • Subforms for the records that belong to this one

Reports and printing

  • Reports that choose their own totals
  • Print templates for invoices, receipts, payslips and agreements
  • Letters merged in Documents from a table or a query

People and roles

  • A protected database asks each person to sign in
  • Each role sees only what it is allowed to
  • A log of who changed what

Protection controls who sees what in the app. The file itself is not encrypted.

Shared records

  • Tables linked to PostgreSQL, MySQL or MariaDB
  • Every computer works on the same records
  • The design stays in your file, the records on the server
Moving from Access

What comes across, and what you rebuild

Data Files imports an Access database as new tables: older .mdb files (Jet 3 and Jet 4) and .accdb. It reads the Access file and never changes it. Here is exactly what it brings, so you can plan the move before you start.

Comes across

  • Each table, as a new table in your Data Files database
  • Every record in it, up to about a million rows a table
  • Dates, numbers and currency amounts, as dates, numbers and amounts
  • The file’s own ID numbers, kept when the import finds them

Stays behind

  • Forms and reports. You rebuild them in Data Files’ form and report designers.
  • Saved queries and relationships. You set them up again on the imported tables.
  • Macros and VBA code. Data Files does not run them.
  • Pictures, attachments and other binary fields.
  • A database with a password. Take the password off in Access first, then import it.

Start with the tables

Import the Access file into a new database and check each table’s count of records against Access before you go further.

Then the links between them

Set up the relationships, so the forms and queries you build next can follow them.

Then the screens and the paper

Rebuild the forms people type into and the reports they print, one at a time, starting with the one used most.

Other files

Your other database files, too

Data Files opens a SQLite database (.sqlite, .sqlite3, .db) as it is, read only, and leaves it unchanged. To change its design, save a Data Files copy of it.

It imports, as new tables, dBASE and FoxPro .dbf files (with the memo file beside them), CSV and TSV, workbooks (.xlsx and .ods), and old Lotus 1-2-3, SYLK and DIF files. A table can also be read from a CSV file, a spreadsheet, another database or a web address, and kept up to date.

The Data Files app with a walking club’s database open: the Members table’s twelve records, and down the side its tables, the query Renewals due, two forms and the report Payments by member

A good fit

  • Your Access database is mostly tables, forms, queries and reports
  • You want people to sign in and see only their part
  • You want several computers on the same records, through PostgreSQL, MySQL or MariaDB
  • You would rather not pay a licence for each desk

Think first

  • Your database runs on VBA code and macros. Data Files does not run them, so that work has to be rebuilt.
  • You need it on a Mac or Linux today. The installer is for Windows, and other systems build it from source.

Try it on a copy of your database

Rutba Office is one free download. Import a copy of your Access file into Data Files and see what comes across. Questions about moving a business’s records? Write to us.

Microsoft and Microsoft Access are trademarks of the Microsoft group of companies. Rutba Office is not made by or connected with Microsoft.