Excel as front end to Access database
$30-250 SGD
Paid on delivery
Hi
I am running a small business in Singapore and it has come to my attention that we have no software for forming quotes efficiently.
I would like to be able to use Excel as the front end to an Access database (the UI will basically be userforms in Excel) of prices for various sizes and models. If it can be all done in Access it would be even better.
What I want to achieve is to be able to obtain prices in quotes simply by inputting model and sizes (ie Model A 150 x 150)
I have attached a sample price list to be used in the access database.
Thank You.
Project ID: #1395171
About the project
Awarded to:
17 freelancers are bidding on average $104 for this job
Hello. We can offer you to create it fully in Access. Please check our reviews and examples in your inbox
Hi, I could easy do this task... Method : Create a user form in excel, Where the user will enter the inputs Create a connection to the access database and excel Query the access database and retrieve the approp More
Hi I can do this and for quotation you can use Infopath which is more easy and good in preparing reports like this if you award me this project i can show you an example in next 2 days. Hope you will like this. MS Info More
Hi. For the past 3 years I have been creating Tools wherein the UI is useform in Excel and use Access as Database. The tools that I've created is being used by BPO agents in tracking their work. Thanks.