Creating an Access Database
-
Open Access and create a new database by going to File and Clicking on New then click on Blank Database. Save the database by going to File and then Save Database as.
-
Save the file in Access Folder using your last name and the name of the file. It will look something like this: Jansen-Football. Make sure this is saved to your folder within your Microsoft Office class folder.
-
In the Database Window click on Table and then double click on Create table in Design View
-
Type the following fields to set up your table.
Field Name
Data Type
Description
Team
Text
Name of Team
1st Color
Text
1st Color of Team
2nd Color
Text
2nd Color of Team
-
Notice how your "ID" field has the little key icon by it. This means that the ID is the primary key and no two records in this field will be the same. Close your table by clicking on the second X in the upper right hand corner of the Table Window.
-
When it asks you if you want to save your table Click Yes.
-
Name the table Team Colors and press Enter.
-
Double click on your new table and enter the data below. (Remember do not do anything with the ID (AutoNumber) this is the Primary Key that Access automatically assigns for you just tab over it.)
Team
1st Color
2nd Color
Green Bay Packers
Green
Gold
Chicago Bears
Blue
Orange
Minnesota Vikings
Purple
Yellow
Jacksonville Jaguars
Blue
Black
Seattle Seahawks
Blue
White
New England Patriots
Blue
Red
Tennessee Titans
Blue
White
Indianapolis Colts
Blue
White
Dallas Cowboys
Blue
White
New York Giants
Blue
Red
-
Close your table when complete by using the second X on the right side of the window you are working in.
-
Save and Close the database. You are now ready to keep moving down the field. Click here to continue...