Hyperlink within Database 2007

I am creating a rather extensive database in Access 2007 that is going to
have many tables. To make this database user-friendly I want to create
Hyperlinks that link to tables within the database. Here is a basic idea of
what I want to do:

In Table 1 I have a field with Location Identifiers the run from 01 to
31. I'd like to create hyperlinks in this feild. For example 01 represents
Maryland. Pertinent info for Maryland is listed on Table 2. Is it possible to
create a hyperlink on the field/row location for 01 to link the user to table
2?

Any help on this would be extremely appreciated. Thank You!!