PRACTICE CREATING A DATABASE AND WEB DESIGN


DATABASE

WEB DESIGN



In the following excercises, you will learn to practice creating a database using Microsoft Access and building a web page using a Microsoft Word.




DATABASE

WHAT IS A DATABASE?

A database is a collection of information, such as how many students are in each classroom at Desert View Elementary School or even an address book of all your friends at school. Your database can be stored in a notebook or better yet in the computer.

Creating the database

Let us look at an example of what is in a database. We will make a small database of an address book of your favorite friends at school.

First thing we need to do is decide what type of information we want in our address database. We will want the following information:


If you were using a piece of paper you would divide the paper into four parts. Either you fold the paper or draw a line to make four columns. You would label the top of each column with First and Last name, Street Address, Telephone Number, and Zip Code. Under each column heading you fill in the information - data.


AN EXAMPLE OF DATABASE WITH LABELS AND FIELDS.
FIRST AND LAST NAME STREET ADDRESS TELEPHONE NUMBER ZIP CODE
Julio Cesar 1234 Tornado 505.589.1180 88063
Maruco Salvadori 345 McNutt 505.589.2134 88063
Daisy Fuentes 6789 Palo Alto 505.589.6439 88063

You do the same on a computer. You have to tell the computer you want to create columns, categories or fields, to store your information. After you created your categories or fields, type the information.

If your friend changes telephone number or changes street address, you can change the information in a table. Just like you would do in word process.

AN EXAMPLE OF CHANGING INFORMATION ON A DATABASE.
FIRST AND LAST NAME STREET ADDRESS TELEPHONE NUMBER ZIP CODE
Julio Cesar 1234 Tornado 505.589.1180 88063
Maruco Salvadori 345 McNutt 505.589.2134 88063
Daisy Fuentes 9087 La Quinta 505.589.6439 88063


The database that we would like you to build is from the information you collect from Keystone Wetland. Think of this as a scavenger hunt.

You will be using Microsoft ACCESS to create your database.

Open the Microsoft ACCESS application and click on "Blank Database" button. Then click OK. You will be presented with a dialog box, which will ask for a name of the database you are creating. Give it a name you or leave it as be and click the "Create" button.

You will be presented with another dialog box. Click the tab "Table" and click the button "New."

Another dialog will appear, click "Design View" and click "OK."

This will take you to the design table where you will add your headings. In the column "Field," type the first heading. Click the "Enter" button three times. Type in the second field and click "Enter" button three times. Keep doing the same until you finish typing all of the field names.

You will be typing the following information in the appropriate fields. This particular database is for water birds found at Keystone Wetland.

Click the "View" button underneath the File name. You will have three dialog boxes open. Just type Yes, Ok, and Yes. You have just created your database where you can start typing the information you gathered. Make sure you save your work.

AN EXAMPLE OF DATABASE FOR WATER BIRDS.
Location/Grid Common Name Scientific Name Number Sex Juvenile Mature
d d d d d d d
d d d d d d d
d d d d d d d

Top of Page




WEB DESIGN


For more information