how to obtain database connectivity between Excel 2007 and Access 2007

You can either use a query linked to a worksheet (using the tools on the Data menu) and link the form to that, or you will have to use ADO/DAO to return the data as a recordset that you can populate the form with.
It would be much simpler to build the form in Access though.

See for example here. You will need to change provider to use Microsoft.ACE.OLEDB.12.0 rather than Jet.4.0