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.
Print On Spreadsheet > Spreadsheet Template File > Spreadsheet Form Filler > Spreadsheet Reporting > Export To Excel Spreadsheet
Database & Formula
Let’s get to understand the database behind the worksheets and the amazing features of data manipulation simply by applying formulas only.
Tables Of Single & Multiple Value Cells > Linking Of Single/Multiple Tables > Key Table, Field & Index > Use Your Own Database Tables & Fields
Create Selection List > Pull In Cell Value > Calculation Of Cell Value > Processing Data After Saving Record
Edit Worksheet, Manage Database
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.
Worksheet Caption & Location > Key Cell (or Entry Number) > Edit Entry Form > Tables of Single/Multi Cells
Edit List Views > Create Filters For List View > Read-Only Worksheet > Different Worksheets Same Tables
Using MDB Viewer Plus > Mapping Column Headers > Import Spreadsheet > Import Related Tables > Using MS Access
More On Manipulating Data with Formulas
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.
Pull In Single Cell Value > Pull In Multiple Cell Values > Pull In Cell Value From Two Tables > Grouping Of Values
Executing Formulas In Sequence > Formula Looping On Multiple Value Cells > Add Conditions In Formula > Multiple Return Values Of Query Formula > Use Formula To Remove Records
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.
Create Report Worksheet > Data Range Selection Cells > “Go” Button > Formula To Retrieve Data > Total Counting Cells > Save Up Report Data
Format Report On Excel Spreadsheet > Cell Values > Report Directives (Dot Dot Command) > Combine Using Excel Formulas > Generate Report > Multiple Spreadsheet Templates
Worksheet Properties (Editing Worksheet)
Let’s have a closer look at each of the worksheet property settings that can provide more conveniences to your work.
Worksheet Name > Position in Menu Page > Editing Mode > Key Cell (Unique Entry Identifier) > Visual Properties > Document Printing > Synchronization Over the Cloud > Worksheet Use Cases
Basic Column Properties > View Filter & Display Order > Some Visual Properties > Display Related Information > Define Filter Boxes
SQL – The Core Element
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.
SQL Functions for Manipulating Data
More on Select Formula
Calculate the Sum of Rows of Data
Uses of SQL Formula in Worksheet
Let’s learn about how to apply SQL formulas in the worksheet.
Uses of Formula in Worksheet
Replacing Values in Formula