Quick Start

Top  Previous  Next

The best way to get started with dbQwikSite is to run the project wizard. It will guide you through the steps to produce a web site, that you can either run right away or further customize to meet your own design of requirements.

 

 

The project wizard walks you through the process of creating a new project through a series of steps.  This topic will show you how to use the create a new database web project.

 

Step 1: Open or Create a Project

 

Wiz_Project_002

 

Step 2: Choose a Database or Create

The next step is to locate a database.

Here we have a number of choices

1.if you already have a database and have already defined a connection, you can simply use this connection.
2.If you have a database but have not defined a connection you can select this option to run the connection wizard.
3.If you do not have a database, you can use a dbQwik template which has an associated database already.
4.You can create a new database.

 

Wiz_Project_003PPPPPPPP

 

We will use the Create New Database option in this example

Step 3: Create a Database

.

Simply choose the Help me create a dbQwikSite database and click the Next button

 

We then enter the name for our database.

 

Wiz_Project_004

 

The table builder dialog appears:

 

Wiz_Project_005

The table builder is able to create tables from files (pictured above), using built in templates, by designing or from ready a mySQL Script file.

 

You can use the built in templates to create tables based on a wide assortment of table designs:

 

Wiz_Project_006

 

You can use all the available methods in combination to create the tables you want to include in your database.

 

Note:  The database created is MS Access format, but you can use dbQwikSIte's X-Gen technology to later deploy to MS Access, mySQL or MS SQL databases.

 

Step 4: Select Tables and Page Types

 

Once you have opened your database, you can now see all the available tables and Page Types that you can generate for each table.  You can check the combination that you desire as well as adjust table names so that the transform to better web page names.

Wiz_Project_007

 

Step 5: Enter Site Settings

 

You can now tell dbQwikSite about your host setting if you have the information available.  These setting will be used in your pages as default values that you can change later.  But if you know them now, enter them and it will save you the need to enter the setting on individual pages later.  You can also choose a default color theme for your site.

 

Wiz_Project_008

 

Step 6: Start Designing your Pages in the Designer

 

Wiz_Project_009

 

 

---

 

It is possible to produce web pages with dbQwikSite within a few minutes. dbQwikSite uses your existing PC's dataset definitions (DSN Names) and automatically creates connections for the supplied sample projects.  Assuming that you already have defined a database connection for your data, here are the steps needed to produce web pages...

 

1. Click on New Project and select your build method

 

dlg_build_Panel_002

 

2. Choose the data connection for your data

 

dlg_select_Database_001

 

3. Set up your Data Page by clicking the Setup Button

 

dlg_site_Setup_001

 

4. Select the source of data to display on your web page. You can do one of the followings:

 

     4a Load data from a table

 

  edt_get_Records_001

 

    - OR -

 

 4b Load data from a Query accessing several tables.

 

  dlg_SQL_Builder_001

 

5. Click OK

 

 

Your pages are ready for you to preview...

 

dlg_data_Preview_001