While I've never attempted it, the trickiest part of the process is getting your detached Sql Server database file attached to a Sql Server instance on the target installation machine. The Package and Deployment Wizard can't help you with that. It all has to be coded into the run-time version of your ADP. A place to start looking at some for that:
As far as the Package and Deployment Wizard is concerned, there's not much difference between packaging a ADP and a MDB, 'cept the with an ADP you can include MSDE with the package and have that installed as well, and your ADP package will obviously need to include a copy of your detached .mdf (Sql Server db) file.