Before building your database application, you will need to first create your database and then create a data source.
Create the database and name it Tutorial.
You will create a table that stores employee contact
information.
Name the table Employees and
use the following data.
|
Location |
FirstName |
LastName |
Department |
|
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.
Create a Data Source and name it tutorial.
Download
the tutorial template and save.
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!