The Database Wizard helps you to create dbQwikSite database with ease. You can create databases using a variety of techniques in combination. You can convert Excel, text and csv files to tables, you can create a tables based on built in templates, you can design tables yourself. dbQwikSite creates database in MS Access format, these can later be published or converted to MS SQL or mySQL.
There are 2 ways that you can access Database Wizard.
1. Wizard -> Database Wizard
2. Project Wizard -> Create New Project -> Database Web Project -> I don't have database -> Next
The database wizard lets you create new tables in four different ways:
Converting PC Files to Tables
Converting files lets you use existing data that you have in some types of PC files as a database for dbQwikSite. Three file types are supported: CSV, Text, and Excel. When you convert a file into a table dbQwikSite will create a table to contain the file data as well as import the data as records in your new table.
Hint: You can delete fields by right clicking on any field -> Delete field
Using Table Templates
Table template allow you to create new tables in your database, based of common templates. This can greatly speed designing table over manually designing. You pick a table from a list available template. Each table template has a set of template fields. You can can include and exclude suggested fields to create a table that is tailored to your needs.
Hint: You can change field names by right clicking on any field -> Rename
Note that when you create a table from a template it will not contain any data records. You can create an add page in dbQwikSite that you can use to enter sample data.
Designing a Table Manually
You can design tables by typing in the field definition and saving the design into a new table.
Note that when you create a table manually it will not contain any data records. You can create an add page in dbQwikSite that you can use to enter sample data.
Convert a MySQL Script
Import a phpMyAdmin SQL script to clone your MySQL tables
See more on creating mySQL exports and importing