build apps by user

Step by Step Guide of Creating a To-Do Application

Let’s have a look at how to create a workable database worksheet just by using some mouse clicks only. You will find that the process is just like working with a spreadsheet – open a new worksheet, add some cell captions and change some cell (or column) widths. This is a real life example to manage works of to-do items.

Create a New Worksheet With a Single Click

Let’s start by creating a new workbook, and then customize the default worksheet inside the workbook to create the To-Do worksheet.
When the program is started, click the “+” button on the top left corner to create a new workbook.
create a new database workbook
A screen prompts you to enter the workbook name and select location. The workbook name is generated automatically, you can decide on using it or enter another name for it.
enter new database workbook name and selection location
Let’s assume a workbook “Book3” is created. You can choose to use one of the 3 default worksheets inside the workbook. You can also choose to create a new one by choosing a vacant cell and clicking the “+”. Either way, you will get a new blank worksheet.
create a new database worksheet
Assuming you have clicked “Sheet 1”, the worksheet appears. This is already a workable worksheet, and you can really start using it to organize your data. In the record form, you can enter the content of a record entry into the single value cells and multiple value cells as well. After data is entered, you can store the record entry by clicking the “Save” button.
a ready to use database worksheet

Edit Cell Descriptions

The default worksheet consists of a lot of cells, and the default cell captions are A.A, A.B, …, A1.A, A1.B, … etc. Before really entering data on the worksheet, let’s edit the captions of the cells that are needed for a To-Do item.
To edit the caption of a cell, click the top right button “..” on each of the cell.
click out the cell setting page
A cell properties screen pops up, you can change the caption of the cell in the top row of the screen.
change cell caption in cell setting screen
Edit the cell caption and click Save button.
update cell caption and save
The data that are required for a To-Do item is its work item description, creation date and status. Therefore, these cell captions are needed – “Work Item”, “Created Date” and “Status”. Since “Work Item” is expected to need more space, it is placed in the second line of cells in the worksheet.
add single and multiple value cell captions
Apart from the simple “Work Item” and “Status” of an work item, this “To-Do” worksheet can also store the details of each work item. The “Details” can be added to the multiple value cells that are already included in the default worksheet. In this way, you can add multiple lines of content to the “Details”.
To cater for the “Details”, two columns are added here, “Plan” is for actions that will be taken and “Answer” is for solution or feedback of that action.
add multiple value cell captions

Change Cell Widths

The required cells are in place now. The next step is to alter the widths of the cells that need to hold longer texts. These cells are “Work Item”, “Plan” and “Answer”.
Since the default width value of a single value cell is 1000, the width of “Work Item” is set to 3000 to triple it.
change the cell width of a cell
You will find that the widths of single cells are relative to each other, and the actual widths vary with the width of the record form.
single value cell's width
Since “Plan” and “Answer” are multiple value cells, the widths are fixed – they do not change with the width of the record form. Since the default width value of a multiple cell is 2000, let’s change it to 8000 for both of the cells.
setting the widths of multiple value cells
the 2 column widths are set.

Change Worksheet Name

We have created the basic content of a To-Do record entry. The worksheet name is still remained as “Sheet 1”, so let’s give a name to it. You can click the “Main Menu” button on the top right corner of the worksheet, or just click the “x” in the top right to exit the worksheet, in order to open the Main Menu.
worksheet name is displayed in the bottom left corner.
In the Main Menu, click the “Worksheet Setting” button.
go to worksheet setting to change worksheet name.
In worksheet setting, you select the entry “Sheet1” in browse pane by clicking the row. In input pane, change the value of the cell caption “Sheet1” to “To Do” and then save it.
select the worksheet setting record and change sheet caption.
Exit Worksheet Setting and get to the Main Menu, and you will see the name of “Sheet1” is changed to “To Do”.
worksheet name is changed to to-do.

Apply Changes to Date Field – “Created Date”

In the worksheet, the cells “Work Item”, “Status”, “Plan” and “Answer” are all text items, and since the default data type of a cell is “Text”, these cells have no need to change. For the cell “Created Date”, we would like to work with date value, and therefore let’s change its data type to “Date”.
Go to worksheet setting and select “Sheet1”. Go to Record Form’s Cell Properties to look for the setting of the cell “Created Date”. Click into the cell in the column “Type” and change the value from “Text” to “Date”. The value of “Size” will automatically change to “0”.
After that, press the “Save” button to save this setting, and then click the “Update DB Tables” button in order to change the data type in the actual database which stores the data. Whenever the data type of a cell is changed, it is necessary to apply the change to the actual database by clicking “Update DB Tables”.
change data type of a cell.
Since the creation date of a To-Do record is usually the same date as it is entered, let’s add “Today” as the default initial value of “Created Date”.
Initial value of a cell can be set in worksheet setting or on-screen cell setting screen.
add default value to a Date cell.
Click the “..” button on the top right of the cell to open the cell setting screen of “Created Date” from the worksheet. In “Initial Value”, select “Today”.
add default value from cell setting screen.
Now, let’s try input a few record entries. The default value of the key cell “DocNo” is AutoNumber with a preset formula. You have no need to do anything, and the record will be saved with DocNo : A000001, A000002, … and so on. The cell DocNo is the primary key cell, or you can call it the unique identifier of the record entry.
entering record entries in a worksheet with auto record numbers.

Edit List View (Browse Pane)

The original record list view displayed in browse pane is like below. It’s time to make some adjustments to it.
change column caption in browse pane.
Change Column Caption
The column heads of Entry List View, or Browse Pane, are still using its original caption – A.A, A.B, A.C, … Let’s change them to the same captions used in Input Pane.
Follow the same step to go to worksheet setting and select “Sheet1”. This time, let’s scroll down to the Record List’s Column Properties. In Column Caption, select the captions for each of the used columns. The used columns are A.A – Created Date, A.B – Status,and A.E – Work Item.
change column caption in browse pane.
change column captions of browse pane in worksheet setting.
Change Column Width
Since the text is expected to be longer for Work Item, let’s increase its column width for better viewing. Default column width is 2000, let’s make it to 6000.
change column width of columns in browse pane.
column width is enlarged.
Up to now, you can say that setting of the worksheet is completed, since you can use it to store To-Do items already. You can see that creating a worksheet for organizing data is just simple and easy. All that need to do is to create a blank new worksheet and change some cell captions and cell widths.
BAU DB is equipped with more powerful features like manipulating data with formula and printing reports on Excel spreadsheets. These features are introduced in the following sections.