Hi i need to create a simple data storing access DB where we will enter daily data which shall store in a table. All such stored data shall be retrieved in a prescribed template if date is entered.
we have been doing it in Excel so far. The first sheet will have data entry where we enter all the data. Next page is the format which gets the data from the first sheet and display in prescribed format which we print and submit to the head office.
But we have been creating one excel file every day hence to retreive any data we are unable to automate and have to manually do.
For example i want to see the consumption of fuel on a particular month, then i have to open 30 different files and manually caluclate all 30 days consumption to get monthly consumption.
hence now i want to go to microsoft access so that we can store, retrieve, run reports etc.
I am quoting as a simple project but payment would not be an issues to deserving candidate
31 freelancers are bidding on average ₹7685 for this job
Hi, I'll code that either directly in Ms Excel or via Ms Access GUI with Excel automation if need. Relevant Skills and Experience vba, Excel, sql, ado, Access Proposed Milestones ₹12500 INR - default
My main expertise is VBA programming using MS Access. I'm confident to finish this project on time and as required Relevant Skills and Experience MS Access and VBA Proposed Milestones ₹7777 INR - Default milestone