Part1: Creating a New Database.

Open Microsoft Access 2007, and click on the Blank database icon .

When you do that, the window below will come up, browse to the folder that you wan to create the file in.

Here you can change the database name to what ever you want to call it, and you can change the extension from Database4.accdb to Database4.mdb if you want. The mdb extension is more accessible if more then one person is working on the file they all might not have Access 2007.  When you are finished hit the Create button.

You should now see the window below.

Part2: Adding information into a table using design view.

Right click on the Table1 label and select Design View

When you do that the table will ask you for a name. Type in a name, the name will correspond to what ever you are making the database about. If you are making it about Baseball stats, or store client information your database will reflect this. I will call mine, stats, click ok.

With that you should be in the new window below.

Fill in your table with the data. Right click on the Stats tab and save it

Part3: Creating a second table and relationships.

Click on the create tab and click on the table.

From here you can repeat, step 2. However, change the table name. I created a second table called injury as shown below. Save the table and close both the Stats and injury tables.

To Create the Relationships click on Database Tools and click on Relationships.

When you do that you should see the two tables you have created.

Click on Injury, and add it. Do the same for the stats table, when you are finished click close.

You should now see the window below.

To create a Relationship click and drag, PLY_ID2 to PLY_ID, when you do that window below will come up.

Fill in the information shown and click Create. That is it, now you have a Relationship between the two tables.

Finished:
Well that is it. Hope it is what you expected. If you have, any questions or comments feel free to e-mail me or leave a message on the forum. If you are having a hard time with the tutorial email me and I will try to help.

This Tutorial was Created By Mark
© 2007 pixeldigest.com. All Rights Reserved.