ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel as a database (https://www.excelbanter.com/excel-discussion-misc-queries/27150-excel-database.html)

Rao Ratan Singh

Excel as a database
 
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.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Rao Ratan Singh" wrote in message
...
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





All times are GMT +1. The time now is 08:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com