If you are an expert with MS Access (Version 2007) and visual basic for applications, then this one will be easy for you.
It's a basic db that stores / reports on transactions
Here's what we have: We have the basic database structure created already - the tables are made, the forms have been made (MOSTLY - there is still some tweaking to be done)
Here's what we need: 1) Logic: a) user picks a username on the first form that locks in the username for now b) User then sees a "main" form that allows them to pick reports or import transactions.
a) Import Transactions: User then sees a new form, clicks button on it to pick their csv and that loads the data into a transactions table.
b) Now, the program goes through the transaction table line by line and compares description with description in memorizedtransaction table. If it's there, then the memorizedtransaction entry gets put into a processedtransaction table along with the other transaction info. if it's not there, then the program prompts a user to "categorize" the transaction with another form - here the user picks from drop down boxes and that just setups a new entry in "memorized transaction" and also puts it in processedtransaction.
a) in the reports screen, the user should be able to select a data range or some pre existing date ranges: 1 month, 3 month, 12 month and display the reports.
b) Report types: pie chart showing all the date ranges transactions , column chart showing the last 12 months of that category (user can pick the category) and also have previous year's data in there.
That's it - the only real logic to put in was in the import screen, rest is easy. Shouldn't take more than 4 or 5 hours total. Thanks!
Please no bid spam - if you haven't read any of the above or your bid contains no information relating to this project, your bid will be rejected.
We have put enough work into this db to guess it would actually be maximum 3 hours of work.
now I am working on Amazon ecommerce to help seller.. I already did import report from amazon and compare to database.. so I can easily do it.. thanks
15 freelancere byder i gennemsnit $49 på dette job
Hi, I have read your project description and I will be glad to help you with all the processes and reports. Relevant Skills and Experience VBA, SQL, Access Proposed Milestones $35 CAD - default
HI. I AM AN EXPEREINCED MS ACCESS AND MS EXCEL [login to view URL] FEEL FREE TO CONTACT ME FOR FURTHER [login to view URL] REGARDS Relevant Skills and Experience MS ACCESS,MS EXCEL Proposed Milestones $35 CAD - FULL JOB