There are two things:
you can download a runtime environment for the different versions of ms office from microsoft. So in case the target computer does not have the version of i.e. ms access you are using to deploy your software, the runtime environment will do.
Beside versioning problemsthere is also the problem that you may use controls, something external to the ms access environment you are using. These controls usually need to be registered on the target machine. In case you have many controls, you also will have many steps to register all the controls for your software to work as intended. These kind of functions are usually handled by a setup program.
for visual office 2007 the easy to use setup program generator is included. Besides following links i might provide, check first microsoft msn regards ms access setup program. Though i rarely used it, with ms office 2000 developer a cd is coming called Micosoft office 2000 developer Tools (version 1.5) I think on this cd ms bundled everything you need to deploy a ms access application.
This link promises to build a setup program (i am not sure, whether it really is ms access) with a few mouse clicks)
http://visualsetup.software.informer.com/4.0/
beside that i found it promising to google as follows:
http://tinyurl.com/ya5rwwv
http://visualsetup.software.informer.com/4.0/