Step 2. Getting Ready for Takeoff

The Database

Now you need a database. It will act as your “data source” in GoLive, and we’ll explain what that is in Step 4. We’ve created a simple Microsoft Access database and included it with our ASP sample site, but of course, you can create one yourself. Whatever database tool you choose (Access is just one example), you’ll need to know what data this file will hold based on the information you want to store and/or present to your viewers.

Our sample database has one table that contains five fields: an AutoID field that gives each record a unique identifier, plus four user-defined fields for:

• First Name
• Last Name
• Phone
• Password

The database should also be password-protected (we didn’t password-protect our sample, though, so you can use it as a starter), which you can do in Access by choosing Tools > Security > Set Database Password.

When your database has these or similar elements, set it aside.

Placeholder Pages in GoLive

Now, back to your GoLive site. You’ll need to mock up two main pages with placeholder content. At this point don’t worry about Dynamic Content, just focus on visual layout. The firspage is a Search page where a person can enter keywords and search your directory. Name this page index.html or whatever suits you. The page should contain the following minimum elements:

• Search Form with text field and submit button
• Table to display the search results in a row by row format
• Form for login using last name and password in order to edit a record

The second page is an Edit page, where an individual who logs in can update their record. Call this page edit.html or any other appropriate name. You can work with our sample pages if you like, or at least view them to see the page elements you’ll need.