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, and if your records live in Access, in dBASE or FoxPro files, or in a spreadsheet that has outgrown itself, it brings the tables and records across.
The app
The work you built in Access, in a free app
A small business asks a desktop database for the same jobs: 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, each required, unique or with a default value
- Relationships between tables
- Records to type, sort, filter and search
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 grouped and totalled, to print or save as a PDF
- 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 decides who sees what in the app. The file itself is not encrypted.
Shared records
- Tables linked to PostgreSQL, MySQL or MariaDB
- Several computers working on the same records
- The design stays in your file, the records on the server
The Data Files apps
Apps ready to use, and yours to change
Most people who open a desktop database want an app, not a blank file. Data Files comes with them, each with its tables, forms, queries and reports built and working. Use one as it is, or change any part of it in the same designers you use for your own.
Ready-made databases, empty and ready for your records
- Contacts
an address book, with a phone list to print
- Inventory
suppliers, products and stock movements
- Membership
members, their payments and the renewals coming due
- Customers and sales
companies, the people there, the deals in hand and each call or meeting
- Lending library
books, borrowers and loans
Each comes with a form for each table, the queries it needs and its reports.
Twenty-five sample businesses
A whole business in one database, from a corner store, a café and a pharmacy to builders, a clinic, lettings and a guest house. Each has its tables, forms, queries, reports and print templates for the paperwork that business sends. Open one with a year of invented records to see how it works, or empty to start using it.
- Larkspur Corner Store
- Bramblegate Wine and Deli
- Little Fig Cafe
- Saffron Lane Pizza and Curry
- Hazel Row Flowers
- Tansy Row Pharmacy
- Northbank Trading
- Granite and Grain Woodworks
- Kilnside Builders
- Copperbeech Motors
- Marigold Hair and Beauty
- Copper Pole Barbers
- Ironbridge Repairs
- Quarrybank Motors
- Fernhollow Cleaning
- Bramble Studio
- Tannery Yard Fitness
- Cedar Lane Clinic
- Lantern Learning Centre
- Rowanmere Community Trust
- Hollybrook Lettings
- Fernleigh Estates
- Gullhaven Guest House
- Copperfield House
- Wrenmoor Garden Centre
The sample businesses, to download with their guides
The ready-made databases, on film
Plays from YouTube when you press play. Watch on YouTube Contacts
Plays from YouTube when you press play. Watch on YouTube Inventory
Plays from YouTube when you press play. Watch on YouTube Membership
Plays from YouTube when you press play. Watch on YouTube Customers and sales
Plays from YouTube when you press play. Watch on YouTube Lending library
Sample businesses
A working database for a business like yours
Pick a business from the Data Files start screen, with its records to look around or empty for your own.
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 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
- The records 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 is refused. Take the password off in Access first, then import it.
1. Start with the tables
Import a copy of the Access file into a new database, and check each table’s count of records against Access before you go further.
2. Then the links between them
Set up the relationships, so the forms and queries you build next can follow them.
3. 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.
Your other database files, too
Data Files opens a SQLite database (.sqlite, .sqlite3 or .db) 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 files, workbooks, and old Lotus 1-2-3, SYLK and DIF files.
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.
How-to films, in order
Short films, one task each. Nothing loads from YouTube until you press play.
Plays from YouTube when you press play. Watch on YouTube 1. What is Rutba Office Data Files? Tables, records and one file you keep
Plays from YouTube when you press play. Watch on YouTube 2. Start a database in Rutba Office Data Files: ready-made, a sample business or empty
Plays from YouTube when you press play. Watch on YouTube 3. Make a table in Rutba Office Data Files and design its fields
Plays from YouTube when you press play. Watch on YouTube 4. Required, unique and default values in Rutba Office Data Files
Plays from YouTube when you press play. Watch on YouTube 5. Type records into Rutba Office Data Files, then sort, filter and search them
Plays from YouTube when you press play. Watch on YouTube 6. Import a CSV file or a spreadsheet into Rutba Office Data Files as new tables
Plays from YouTube when you press play. Watch on YouTube 7. Relationships in Rutba Office Data Files: link sales to customers and lines to sales
Plays from YouTube when you press play. Watch on YouTube 8. Your first query in Rutba Office Data Files: fields, sorting and criteria
Plays from YouTube when you press play. Watch on YouTube 9. Totals in Rutba Office Data Files queries: count, sum and average by group
Plays from YouTube when you press play. Watch on YouTube 10. Join tables in a Rutba Office Data Files query: best sellers from sales and products
Plays from YouTube when you press play. Watch on YouTube 11. See and write SQL in Rutba Office Data Files
Plays from YouTube when you press play. Watch on YouTube 12. Make a form in Rutba Office Data Files and lay it out
Plays from YouTube when you press play. Watch on YouTube 13. Pick records by name in Rutba Office Data Files forms, and search long lists
Plays from YouTube when you press play. Watch on YouTube 14. Subforms in Rutba Office Data Files: a sale and its lines on one screen
Plays from YouTube when you press play. Watch on YouTube 15. Reports in Rutba Office Data Files: grouped, totalled, printed or saved as PDF
Plays from YouTube when you press play. Watch on YouTube 16. Print templates in Rutba Office Data Files: a till receipt, an invoice and a letter
Plays from YouTube when you press play. Watch on YouTube 17. Mail merge in Rutba Office Documents from a Data Files table
The Data Files films, in order, on YouTubeHow-to films for the other apps
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.
Microsoft and Microsoft Access are trademarks of the Microsoft group of companies. Rutba Office is not made by or connected with Microsoft.