Excel Help again

**Warprosper** · 03-15-12, 03:40 PM

Originally Posted by Partyball

Thought of using a database of some sort?

Access has a really good template for invoicing... May want to look into that.

Search results for invoice - Templates - Office.com

**CivilWars** · 03-15-12, 03:42 PM

I know that things would be much easier by using a DB or project management software, but the company I am making it for is a little reluctant to change. If the options are to jump into a DB or manually filling in invoices they will choose to manually do invoices.

**WileECyte** · 03-16-12, 12:31 AM

You could use an Access backend and an Excel front end and I bet they'd be none the wiser.

**Partyball** · 03-19-12, 06:49 AM

Originally Posted by WileECyte

You could use an Access backend and an Excel front end and I bet they'd be none the wiser.

Exactly.

Access can create all of the reports you want with little to no effort.

**Alundil** · 03-24-12, 05:03 PM

Originally Posted by WileECyte

You could use an Access backend and an Excel front end and I bet they'd be none the wiser.

This.

Would also not be a bad idea to build in an access front end as the application too. Then when it gets big enough to warrant a full db solution moving it to mysql or mssql won't be a big shift for them as you can keep the front end and migrate the access db structure to the sql solution.

Sent via highly charged bolt of electricity.