Hi,
A friend has asked me to help in digitizing his invoice generation.
The problem is he is very scared of using technology.
I have somehow convinced him to atleast try a very basic software.
So he has agreed to try a solution in excel or access since he knows a little bit about them.
Since excel doesnot seem like a good fit for managing a db of invoices, i want to use access.
But i don't know anything about it, tried some tutorials and videos but they seem very advanced.
Currently I just want to create a simple invoice/receipt form that includes the following info linked to tables.
Invoice.No/Date/User/Customer/ItemId/ItemName/Qty/Total
Sub TotalNet Total
Another problem is that he wants to enter the inventory items at the time of sale, meaning he doesnot have a list of items.
My questions:
1- How to start designing this simple solution? How many tables to create and how to link them with the appropriate fields of the invoice?
2- The line items of the invoice will need to be saved in inventory table, how to do that?
3- This is a temporary solution, so will i be able to easily convert access db to sql server db?
Many thanks!
A friend has asked me to help in digitizing his invoice generation.
The problem is he is very scared of using technology.
I have somehow convinced him to atleast try a very basic software.
So he has agreed to try a solution in excel or access since he knows a little bit about them.
Since excel doesnot seem like a good fit for managing a db of invoices, i want to use access.
But i don't know anything about it, tried some tutorials and videos but they seem very advanced.
Currently I just want to create a simple invoice/receipt form that includes the following info linked to tables.
Invoice.No/Date/User/Customer/ItemId/ItemName/Qty/Total
Sub TotalNet Total
Another problem is that he wants to enter the inventory items at the time of sale, meaning he doesnot have a list of items.
My questions:
1- How to start designing this simple solution? How many tables to create and how to link them with the appropriate fields of the invoice?
2- The line items of the invoice will need to be saved in inventory table, how to do that?
3- This is a temporary solution, so will i be able to easily convert access db to sql server db?
Many thanks!
