Thomas Wallace: Lectures and Resources - A collection of website design lectures and resources

Creating a Simple Database for Your Web Site

1. Open MS Access 2003 and create a new Database. It will ask you to save the file and you should save it in the data folder inside the dbexample folder we just created. For consistency let’s name the new database itviolet.mdb. You should now have a database named itviolet.mdb in the data directory.
   
2. Create a new table in the database and create four fields named StudentID (Auto Number), FirstName (text), LastName(text), and Email (text) making sure that there are no spaces in the names. Next close the table and it will prompt you to save the table. Name the table”EmailAddress” and hit ok.
3. Add some data to the table you just created (6 or more records)
4. Close the Database.