Lengkap

Fix Access dB

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.

We have put enough work into this db to guess it would actually be maximum 3 hours of work.

Kemahiran: Microsoft Access, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: access fix, restricted access fix joomla error, oscommerce admin access fix, repair access database 2016, sysinfotools ms access database repair tool, access database corruption causes, repair access database 2010, repair access database 2007, access database repair tool, repair access database online free, "stellar phoenix access database" repair, visual basic, microsoft access, visual basic for apps, login interface db access, kml da db access, ja template restricted access fix, fckeditor asp db access, ext js db access log, display months column grid

Tentang Majikan:
( 174 ulasan ) Mississauga, Canada

ID Projek: #14461799

Dianugerahkan kepada:

aveermani1989

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

$35 CAD dalam sehari
(1 Ulasan)
1.6

15 pekerja bebas membida secara purata $49 untuk pekerjaan ini

Prashantskin

[login to view URL] I will do all the things you mentioned from user name to import of transactions to reports. within one day only I will do the following 1) Logic: a) user will put a username on the first form that locks i Lagi

$88 CAD dalam sehari
(516 Ulasan)
7.2
schoudhary1553

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 Lagi

$100 CAD dalam sehari
(87 Ulasan)
6.7
danielgpratidya

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 wor Lagi

$20 CAD dalam sehari
(88 Ulasan)
5.9
zu02

p.s. maybe here needs more hours than 3 hours but I'll do that for that price I called here. Hi I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VB. Really all my proj Lagi

$111 CAD dalam sehari
(41 Ulasan)
6.0
royalcalif

Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Access. Email sending with MS Ac Lagi

$30 CAD dalam sehari
(34 Ulasan)
5.2
alaeddindhahri

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

$70 CAD dalam 2 hari
(36 Ulasan)
5.0
crypthne

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 Lagi

$30 CAD dalam 5 hari
(33 Ulasan)
4.7
ENRICOJ

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

$35 CAD dalam sehari
(8 Ulasan)
3.2
sachavukic

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 kno Lagi

$55 CAD dalam sehari
(5 Ulasan)
2.6
ketas

Could help you to make it done within few hours ! Relevant Skills and Experience MS Access / SQL Query / VBA Proposed Milestones $50 CAD - Finish

$50 CAD dalam sehari
(8 Ulasan)
2.6
$25 CAD dalam sehari
(1 Ulasan)
2.0
techcrunch2

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 resu Lagi

$31 CAD dalam 6 hari
(0 Ulasan)
0.0
sahaitpro

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 - Ac Lagi

$40 CAD dalam 2 hari
(0 Ulasan)
0.0
ShyamalTandel

A proposal has not yet been provided

$20 CAD dalam 3 hari
(1 Ulasan)
0.0