bau db

build apps by user

A Database Truly Easy Enough (Yet Powerful) That Everyone Can Use

Users can now create self-made databases anytime to streamline their works.

These ready-to-use features organize your data right away without any effort :

Data-Entry Ready

In a single click, a new worksheet is created and ready for data entry, which comes with single value cells and multi-value cells as well.
rapid application development : each worksheet is ready for work, without the need of any development.

Multi-value cells are common to be used in an entry, such as the multiple goods items in an Invoice entry.

List View Ready

Each new worksheet is ready with an entry list view and a search box.
rapid database application development : ready-made list view and search box in each new worksheet.

Multiple List Views

Create more than one list view other than the basic one. It is a convenient way of referencing data or for reporting purpose.
Formula can be used to confine the scope and displaying order of data in each of the list views.
instant database worksheet : multiple list views for each worksheet.

List views for the Sales Order worksheet : All, Delivered & Outstanding Items.

Filtering Box

Define a convenient date range filter or filtering on any cell for displaying data in the list view.
just like using a spreadsheet, filter box is a handy tool for viewing data.

Filter boxes created for the Sales Order worksheet : Order date range, Customer & Article.

On-Screen Report

With a formula, display a summary based on the data in the current list view. The summary info changes dynamically as the range of data in the list view changes.
create instant database report by using a single formula to create a summary report of the data inside the current list view.

Data in the list view (the top part) is summarized in the info pane (the bottom left).

Document/Report Printout

It’s easy to create formatted Excel template, and then export data from BAU DB worksheet for document printout, report or presentation.
bau db links up spreadhseet and database together: pre-formatted excel spreadsheet report/document template

Simply put cell names in a formatted Excel worksheet to create the document template, data are then exported to generate the output document.

Entry with Picture

It’s ready to link pictures or files to an record entry
attach a picture to a database entry in the worksheet

Change the cell input type to “File” and the cell is ready for you to select a picture and display in Info Pane.

Apart from saving your data in an organized manner, these features automate your data and streamline your works — all created simply with a single formula :

Entry Number (Key Cell)

Each entry has an unique identifier, or key. The key can be set to any format with an auto increment number, or with parts of the key in connected with the data of the entry.

bau db is a entry-based application, each worksheet has an unique identifier as the key of each database record

For an Invoice entry, the unique identifier is Invoice No, with part of it retrieved from ‘Invoice Date’.

you can easily define default value of the unique identifier

Default identifier of a new worksheet.

Default Initial Value

Define automated value for a cell. It can be a fixed value or calculated by formula. In a multiple-row cell, the initial value can be a value related to that of the upper row’s cell.

As a convenient database tool, you can assign default initial value to each field

Use current date as the default value of the date fields.

just like using a spreadsheet, default value depends on the upper row values.

Default value is incremented by one to the upper row number.

Entry Selection List

With a formula, create an selection list for entry in a cell. The list of data can be retrieved from another worksheet or petty table.

You can develop application rapidly, use a single formula to create a list of items for data entry selection.

Create a list of available Order No. as workflow entry selection in the Invoice worksheet.

Create a list of articles for entry in the Order worksheet.

Auto Lookup and Calculation

Upon entry of a cell value, automatically fill in values in the other cells. The values can be calculated or retrieved from other worksheets. A formula can fill in multiple rows of values at a time.

using bau db is very much like using spreadsheet, you can use a formula to calculate or extract data from another database worksheet.

“Description” and “Unit” pop out upon entry of “Article No”.

it is a very handy spreadsheet feature, a single formula can fill in data in multiple rows.

Entry of Order No. triggers multiple order items moved into the Invoice worksheet.

Related Info

Same as entry selection, only that the item list created is only for reference purpose to display information relevant to the current entry cell.

define a quick reference of data, use a single formula to display information related to the entry cell.

Display recent prices as the user is entering unit price of an item.

a feature that is more than a spreadsheet, display recent prices when user enter the price of an order.

Can also create related info in List View.

Entry Validation

Before saving an entry, it is checked against validation rules in the preset formulas. If it goes negative, warning or error messages will be displayed.

to ensure the entry data is complied with business rules, create validation rules using formulas.

Item quantity is checked against stock quantity, and a “warning” message is displayed.

an use case of rapid application development: when entering order qty, check if enough stock quantity.

When message type is “error”, the entry cannot proceed saving.

Data Processing

After saving an entry, execute a set of formulas to do some updating and processing on other data records in the database.
process data in other database worksheet with a set of formulas

Formula steps are displayed on the screen when the formulas are processed.

These are the features that make your works more convenient :

Connect With MS Access

BAU DB workbook files use Microsoft Access file (mdb) format. If you have Ms Access, you can extend the functionality with your favorite Access features.
bau db is a database tool which is very much like using a spreadsheet, it converts the power of access database to an easy-to-use spreadsheet-like interface

BAU DB file opened in Ms Access. BAU DB bridges between Excel and Access to provide the benefits of both. That said, you can use all the features of BAU DB without installing Microsoft Access.

Import Spreadsheet Data

You can use either MS Access or MDB Viewer Plus (a free tool) to import spreadsheet data into BAU DB easily and quickly.
import spreadsheet data quickly into BAU DB using MDB Viewer Plus.

With a few clicks, spreadsheet data are imported into the database.

Petty Tables

Petty tables is a place convenient for storing some small data tables that are used for various purposes such as the source of items for entry selection, filtering box, or property setting of the application.
a convenient database tool feature: ready-to-use petty tables facilitate storing of some small data tables.

Data likes currency table can be stored in petty tables.

User Access Control

User access control for defining who can read or update each of the worksheets.
another useful database feature: built-in feature to control access of various users.

Update user access right of each worksheet. Note that this is a feature of BAU DB Pro.

> Go to Quick Starter to see how easily BAU DB works

BAU DB is easy and direct, yet flexible and powerful for any businesses.

Download and get hands-on experience with BAU DB to enjoy its database power and spreadsheet-like ease at the same time.