build your own apps

BAU DB Documentation

You will find that BAU DB is just easy to learn too!

Excel Spreadsheet Reporting

Let’s get to the fun part again to see how to create various styles of reports easily using Excel spreadsheet. In general, there are 2 steps in creating a report. The first step is to create a BAU DB worksheet for retrieving and collecting the necessary report data. The second step is to create an Excel spreadsheet report template file. After that, press a button to move the data from the BAU DB worksheet onto the report template of Excel spreadsheet.

Worksheet Properties

Let’s have a closer look at each of the worksheet property settings that can provide more conveniences to your work.

SQL Formula – The Core Element

Let’s learn about the basic structure of SQL formula that is used to manipulate data and the formula functions that help simplify much of your work.