Setting Up the Database

Before building your database application, you will need to first create your database and then create a data source.

 

  1. Create the database and name it Tutorial.
     

  2. You will create a table that stores employee contact information.

    Name the table Employees and use the following data.
     

Location

FirstName

LastName

Department

Email

Phone

Login

Password

Jacksonville

John

Smith

IT

jsmith@mjsports.com

904-444-1234

jsmith

jsmith

Orlando

Bill

Jones

Marketing

bjones@mjsports.com

407-555-1234

bjones

bjones

Miami

Mary

White

IT

mary@mjsports.com

305-777-1234

mwhite

mwhite

Jacksonville

Paula

Moore

Customer Service

pmoore@mjsports.com

904-444-5678

pmoore

pmoore

Tampa

Carl

Williams

Finance

cwilliams@mjsports.com

831-999-1234

cwilliams

cwilliams

Tampa

Lisa

Jackson

Marketing

ljackson@mjsports.com

831-999-5678

ljackson

ljackson

Orlando

Jane

Bennett

Human Resources

jbennett@mjsports.com

407-555-5678

jbennett

jbennett

Miami

Ted

Davis

Customer Service

ted@@mjsports.com

305-777-5678

tdavis

tdavis

 

Note: If using MS Access, you can download the Employees table here.

 

  1. Create a Data Source and name it tutorial.
     

  2. Download the tutorial template and save.
     

  3. Add the database component toolbar that corresponds with the platform you will be publishing to.

 

You are ready to start building your Web site application!