Just a quick comment. If you are going to distribute the application, retail. A viable alternative to an Access frontend is to use VB
to create your forms use an Access backend. Even though the fronted is using the Access database, the end user is not required to have Access installed on their machines.
If you are comfortable with VBA in Access, the transition to VB
will be minimal.