Let’s start by having a quick look at how and why you can use BAU DB to create database applications easily and rapidly with a real life example.

Let’s get to understand the database behind the worksheets and the amazing features of data manipulation simply by applying formulas only.

This section is about the handling of application files (workbook file), the editing of worksheets and the management of database data and files. Let’s go along with a real-life sample application.

Let’s learn more about the features and techniques to manipulate data by using formulas only. It’s amazing and convenient to automate your works with formulas, which saves much of your manual works.

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.

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

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

Let’s learn about how to apply SQL formulas in the worksheet.