If the database is a single .mdb file containing all the objects; tables,
queries, forms etc. then you can simply burn the one file to a CD in the
usual way. If the database is split into a front end containing the queries,
forms etc, and a back end containing just the tables then you'll need to burn
both files to the CD. If in the latter case the files are then loaded onto
another machine, or into folders on the same machine different from the
original locations, the links between the front and back ends would need to
be refreshed using the built in Linked Table Manager.
If the files are loaded onto another machine that machine would need to have
a compatible version of Access installed to open the files, unless you are
able to load the runtime version of Access onto the other machine.