<p>Does MS Access 2007 support internal foreign keys within the same table?</p>

Yes.  Create the table with the hierarchy.
id - autonumber - primary key
parent_id - number
value
Go to the relationships screen.  Add the hierarchy table twice.  Connect the id and the parent_id fields.  Enforce referential integrity.