Currently I am using excel with VBA to input incoming and outgoing inventory, create invoice, updating invoice details into another sheet etc. As my data info are getting bigger with more rows and column, I am thinking to move to access. But has no clue how to do it.
Is it possible to update details in access using forms and transfer the information back to the same excel book?
Thanks