Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Neither it is mine. In fact I hate Access only one bit less than Pascal.
But still for what you want to do, considering you plan to use VB anyway, it makes much more sense to do it in Access itself. It should actually be easier than doing the same from within VS.
Access VBA is not greatly different from VB6 and building forms is much easier. Do you plan on using lots of fancy ActiveX controls?
If your app is very simple it may not need any coding at all!