This updates is about the user manual. Thanks for your requests and suggestions, the documentation is now completed with the basic concepts of the feature of BAU DB and the contents should be sufficient so that you can get your hand in customizing your own database solutions.
BAU DB is an easy-to-use tool which lets you create powerful and flexible solutions to manage business and work. Apart from that, it is also an easy-to-learn tool. This is a summary of what is included in the documentation so far:
The purpose of the first section – “Quick Starter” is to let you start working with BAU DB immediately.
In “Going Straight to Data Entry“, you will know how to use BAU DB in a single click to create a ready-to-use database application and you can go straight to enter the cell captions and save data on the worksheets.
In “Automated Documents Using Excel“, it explains the simple steps to add some cell captions of BAU DB worksheets into Excel and turn it to a document template immediately so that you can generate automated documents for the data entries you have created.
In “The Actual Database“, it reveals the relationship of worksheets wit the actual database underneath. With this understanding, you can edit your worksheets to add more cells and also apply automation formulas that manipulate the tables and fields of the database.
In “Automating The Data“, you can learn the formulas and apply them to automate selection lists, input validations, calculations and manipulations of data between worksheets.
In “Reusing Pre-Existing Spreadsheet Data“, you will understand how to import your existing data in spreadsheet format into BAU DB worksheets in some simple steps, so that you can continue your works in BAU DB.
In the second section, “More Features” explains more features of BAU DB along with a real life sample, so that you can understand apart from using the default worksheets, BAU DB allows you to create an application from scratch as well.
In “Download The Sample Application“, it shows you the way BAU DB opens an application file is just like Excel opens a workbook file. It also introduces briefly about each worksheets of the application so that you can better understand the examples in the following sections.
In “Settings of a Worksheet“, you will learn how to edit a worksheet with its input cells associated with database fields and different field types. You can also edit the entry list views and the filtering boxes.
In “Data Flows Between Worksheets“, more use cases and examples are shown. You will meet some useful and convenient techniques there.
In “Manipulations of Data After Saving an Entry“, it will shows you the features of data manipulations that simplify things and empower you to apply some formulas to perform some tasks.
In “More Automation Features“, there are more fun and convenient features that sum up and made BAU DB an easy and simple tool for building applications.
Once again, thanks for Jan’s suggestion to add the explanation of database table and field and Ramos’s suggestion to add the steps of importing data into BAU DB. In the coming session, topics like usage of formula, cell properties and reporting will be rolled out. As suggested by Nagendra, forum is also need to build. For the time being, let me know if there are anythings that you want to know and not yet found in the documentation.