Excel as a database

[Rao Ratan Singh]

is there any possibility that i used to print a invoice through excel for my
product sale. is there any way excel can generate monthly sales book as a
database.

Please show me any path

Thanks in advance.

Rao Ratan Singh

 

[Earl Kiosterud]

Rao,

Consider Access for this project. To do this properly, you'll likely need a
table for your products (your inventory or product line), one for your
invoices, one for the items in your invoices, and if you're keeping customer
information, one for your customers. Excel is terrific, but a lot of darn
work to implement related tables, move records around, etc., as your
business flows. Access may be harder to learn, but the payoff is well worth
it.