Rutba Office

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

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.

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.

Plays from YouTube when you press play. Watch on YouTube

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. 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. 2. Then the links between them

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

  3. 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.

  1. Plays from YouTube when you press play. Watch on YouTube

    1. What is Rutba Office Data Files? Tables, records and one file you keep

  2. 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

  3. Plays from YouTube when you press play. Watch on YouTube

    3. Make a table in Rutba Office Data Files and design its fields

  4. Plays from YouTube when you press play. Watch on YouTube

    4. Required, unique and default values in Rutba Office Data Files

  5. Plays from YouTube when you press play. Watch on YouTube

    5. Type records into Rutba Office Data Files, then sort, filter and search them

  6. 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

  7. 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

  8. Plays from YouTube when you press play. Watch on YouTube

    8. Your first query in Rutba Office Data Files: fields, sorting and criteria

  9. Plays from YouTube when you press play. Watch on YouTube

    9. Totals in Rutba Office Data Files queries: count, sum and average by group

  10. 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

  11. Plays from YouTube when you press play. Watch on YouTube

    11. See and write SQL in Rutba Office Data Files

  12. Plays from YouTube when you press play. Watch on YouTube

    12. Make a form in Rutba Office Data Files and lay it out

  13. 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

  14. 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

  15. Plays from YouTube when you press play. Watch on YouTube

    15. Reports in Rutba Office Data Files: grouped, totalled, printed or saved as PDF

  16. 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

  17. 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.

One family

The rest of Rutba

One account across all of it. Sign in once and the products know each other.

OFFICE-APPS-DATA-FILES · 9b20c6b