Access will do it for you.
1. Go into query design view and create a query that incorporates all the fields you need from the different tables and then save it.
2. Click the query name to select it.
3. Look on the toolbar for the icon with the lightning bolt through it (If no toolbar click view, toolbars, database).
4. Click the little arrow next to it and select autoform.
5. Modify the form in design view for field lengths, etc.
Good Luck!
Feel free to post again if you need some more help.