Access 2007 Work in a separate file using ACCDE
Yes, you can (and you should!!) split your application into two Access databases:  


A backend containing all the tables.
Put this somewhere on a central network share.
A frontend containing code, forms, records and so on...basically everything except the actual tables (which are in the backend).
You can link the tables from the backend here, and each user should have his own copy of the frontend on his local machine.
It's quite easy to deploy the frontend in a way that it auto-updates each time a user runs it.


If you split your app this way, you can just deploy it now and your users can start using it.
Later, you can modify the forms and reports (or add new ones) and just deploy a new version of the frontend to your users, without them even really noticing it.