Examine the DatabaseBuilder to understand its function and use.

Download the DatabaseBuilder named "MyPleasure Lesson 1", and store it in your Tutorial JumpStart folder and open it in your Excel application.

In general:
The DatabaseBuilder is an MS Excel sheet that is loaded with functions and code-behind scripts. To prevent these functions and scripts for accidental damage, the sheets are locked with a general password, thus making it inpossible to overwrite cells. This password is " MySheets" and will apply all over the DatabaseBuilder. You can turn it of, at your own risk. (Make backups!)

The Tables and Fields:
The DatabaseBuilder can contain 20 tables at once.
Any table can hold up to 100 tablefields.

For the ApplicationBuilder to be able to build your application, it is necessary that all names in your database follow the convention that JumpStart DNN dictates.
The DatabaseBuilder takes care of these convention by adding certain codes to the names of the tables and the table fieldnames.
For instance the "Primary"  and " Secundary"  prefixes are needed to distinguish the table- and fieldnames in the SQL database. The guarantee the uniqueness of the names within your database, and over your applications.
The conventions for the extentions on the tablefieldnames take care for the correct building of the code that make up your application.

The DatabaseBuilder Tabs.
There are 14 tabs in your DatabaseBuilder, some are optional, the others are oliged and will build your application in the ApplicationBuilder. Some are not in use.

 TabName Use   Function Remarks 
 Calculations Optional  This is a helper tab that enables you to create calculated content.  In this example we use it as the primary information on the contribution fee.
 Conventions Obliged  This tab contains your application information.  In the top rows are the application name, the primary and secundary prefix and so on. You have to set them prior to building your application.
 Tables Obliged  This tab contains the names of the tables that make up your application.  Try to arrange your tablenames in a logical order. The tables will get a number, so it makes sense to get them in a convenient order. Primary tables on top, secondary tables to the bottom.
 YC_TUT_00_Template Not in use  The template tab is only used when you run out of Table tabs.  Create a new tab at the end of your DatabaseBuilder and copy-paste the template content to the new inserted tab. Then open the script page and also the script page of the new tab. Copy paste the script from the Template to the new tab.
 YC_TUT_01_YCSociety Obliged  The Society table keeps the contribution data.  This table contains just three records: Adult fee, Child fee and Spouse fee.
 YC_TUT_02_YCActivities Obliged  The Activities table keeps the Activity information.  This table contains just five records: Parasailing, Hanggliding, Hiking, Rafting and Camping. The information consist of date and cost information along the Activity Officer.
 YC_TUT_03_YCOfficers Obliged  The Officers table keeps the Activity Officers information.  This table contains just five records with the Activity Officer name in it. It has NO role information in it, because any Officer is a registered user, so most of this data is stored in DNN's system tables. Any number of officers can be added by the administrator.
 YC_TUT_04_YCMembers Obliged  The Memberstable keeps the Member information.  This table contains a number of member records with the needed data. Because members do not need to be registered on the website, it is the administrator's task to add new un-registered members after they have payed thier contribution fee.
 XYC_TUT_05_ Not in use  Reserve table.  When you need to expand your application with more tables, you can use this reserve tab. Just fill in a new tablename in the " Tables"  tab and this tab will set ready for your new dataset.
 XYC_TUT_06_ Not in use  Reserve table.  Same as above....
 XDataYC_TUT_01_YCSociety Optional  This tab contains test data for the Society table.  The top row of the DataTab holds the fieldnames of the corresponding TableTab. The data in the record in this tab will partially origine in the " Calculation"  tab.
 XDataYC_TUT_03_YCOfficers Optional  This tab contains test data for the Officers table.  These are the Activity Officers names, stored in five records.
 XDataYC_TUT_02_YCActivities Optional  This tab contains test data for the Activitiestable.  The five activities are stored in this tab, along with their properties, the fieldnames in the top row. Again, these correspond with the fieldnames in the TableTab
 XDataYC_TUT_04_YCMembers Optional  This tab contains test data for the Memberstable.  The same as above, but for the members. This tab contains a number of test members that can be used to re-fill the table after modifications in your DatabaseBuilder.

You're done with this lesson

---->  To Lesson 3: The content of the DatabaseBuilder