Create New Worksheet > Add Cell Descriptions > Change Cell Widths > Change Worksheet Name > Apply Changes of Date Field > Add Input Selection > Edit Record List View > On-Going Changes
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
This section is about handling of application files (workbook file), editing of worksheets and managing 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
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
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
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.