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.
2)Import logic:
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.
3) Reports:
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.
Greetings Ansales, I am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve.
I have good knowledge related to reporting and access.
Here is the reason. Why you should pick me?
a) I am a very expert and have the same kind of experience of 5 years.
b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers
c) And most important part is my policy:
"I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me”
Please sir, leave a reply ASAP, as I am waiting for your kind reply
Hi,
I am really interested to help you with your project.
I think the pie chart report will need more tricks on it, but not that I can't manage.
Relevant Skills and Experience
I have more than 15 years experience working on Acess database and automation.
Proposed Milestones
$20 CAD - Initial milestones
Could you please send your existing file, so I can study further?
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
I have a bachelor degree in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
Hello,
you need me to complete some Access File, where some parts are already programmed / present (as the database).
3 steps are defined: login, import data from csv and report.
Relevant Skills and Experience
I know Microsoft technologies for more than 20 years. Nowadays, I'm making program for Windows and leading a team of developers.
Proposed Milestones
$55 CAD - Final product
To be sure I'm able to ask me, I would ask you to send to me the all the needed files
Hello Sir, We have gone through the details you have provided and we have already worked on a similar project before and can deliver as u have mentioned and would be pleased to work on this with you to deliver the results that you have expected and we have already worked on a similar project before and can deliver as u have mentioned
We are sure you will not be disappointed if you give us this opportunity. Our team is experienced, creative & efficient enough to get your job done well. We have an impeccable record and all our clients enjoy working with us, we are sure that you will too, our prices are cheapest in market.
I am ready to discuss with you
with best Regards
Being an expert in Access Programing I can do your job in 2 working days. 1) Login 2) Import 3) reports. Contact me for my work demos
Relevant Skills and Experience
Access Programming
Proposed Milestones
$40 CAD - Access Programming