Everyone Creates Powerful Business Applications, Easily and Rapidly
BAU DB is a total rethink of database productivity tool that lets you – regular spreadsheet users or application developers, work with data more easily, rapidly, and without the need of complex technical skill. It works like a spreadsheet per se, and links up with Excel spreadsheet actually to provide ease and fun, yet with the power of a database and the ability to exchange data at the same time.
BAU DB helps you manage business-as-usual work with ease.
Create Database Application in a Single Click
Like a spreadsheet, just a single click to create a ready-to-go worksheet which has all the basic features in place – including a searchable list view and a data entry form with single and multiple value cells as well, so that you can start work right away without building anything.
A single click to create a new workbook, and another click to create a new worksheet.
Manipulate Data with Formulas Only, Truly No Code/Low Code
You can manipulate and process data with a set of easy to learn formulas, which is flexible and powerful, no matter you are a regular spreadsheet user or developer. It’s much simpler and faster than conventional coding methods, and allows you to create and change your applications easily and instantly to match with the ever-changing work requirements.
Selection List
With a single formula, create an item list, with data from another worksheet, for entry selection.
Auto Lookup & Calculation
With a formula, when “Article No.” is entered, “Description” and “Unit” are pulled in from another worksheet.
Entry Validation
Input data are checked against a preset formula, and warning message displayed.
Formatted Excel Spreadsheet Template, Have Fun!
Each worksheet of BAU DB is Excel-enabled. Create document and report formats in the familiar Excel spreadsheet as you have always been doing, only that you can now transfer data from a worksheet of BAU DB into the pre-formatted Excel spreadsheet in a single click. Documents in OpenOffice/LibreOffice Calc and WPS Office Spreadsheets can also be used.
In this example, invoice data are “printed” onto a pre-formatted Excel spreadsheet template.
Reduce Repetitive Data Entry
Worksheets of BAU DB can be inter-connected easily by using formulas so that data can be moved between worksheets without manual effort. In this way, data can be entered only once and reused elsewheres.
A use case : data is filled in from the “Customer” worksheet to the “Order” worksheet, which is then turned into the data in the “Invoice” worksheet.
Ready to Share and Collaborate
BAU DB is composed of entry-based (or record-based) database worksheets, which means that you can share the same worksheet and work concurrently with your colleagues at any time.
What Can Be Done With BAU DB?
You can create workbooks and worksheets to manage any kind of data. No matter what your business field is, you can start by using BAU DB to save and organize lists of data instantly, or create work group database solutions for a team, and even build a full fledged business application (erp, enterprise resource planning) that run through the whole operations.
Excel Spreadsheet Experience + Database Power
You are already familiar with running your business using Excel. BAU DB uplifts your user experience by blending Excel spreadsheet and database together, and lets you enjoy the best of both worlds – the power of a database and the ease of a spreadsheet, at the same time.
Build Applications by Users
BAU DB is an office productivity tool that is simple and yet powerful, and everyone can start working on a real database immediately without the need of complex technical skills. As a business user, you can always update your self-made database to keep up with the ever changing business.
Go to Beginner’s Tutorial to see how and why you can create database applications easily and rapidly.