Databases Reference
In-Depth Information
Figure 5-8.
Choosing between database and websheet applications
Database Applications from Spreadsheets
When creating a database application from the wizard, you're quickly faced with a question: where is your data
coming from? One of the options listed in Figure
5-4
lets you create an application based on data from an existing
spreadsheet. If you choose this option, the Create Application Wizard provides steps for loading data into a
single table and at the same time creates an application that allows you to manage and manipulate that data. The
application is very simple, using a report and form combination such as that shown in Figure
5-9
. Creating a
database application from a spreadsheet is a fast and easy way to get from a single-page spreadsheet to a working
online application that can be expanded with additional tools and functionality.
Figure 5-9.
The application pages from a spreadsheet application
Database Applications from Scratch
When you create a database application from scratch, the wizard offers many interesting options. You can create any
number of pages and link pages to different tables of data. Additional steps give advanced options that, when planned
for, are very powerful. Creating an application from scratch is the method used in the ticketing application exercise.
Here is what to do to begin the creation process:
1.
Navigate to the Application Builder, and click the
Create
button to initiate the Create
Application Wizard.
2.
Select
Database
as the application type, and click
Next
.
The following subsections describe the remainder of the creation process in detail. Each subsection contains one
or more subsequent steps in the creation process. Read the descriptions, and follow the steps as described.
