Update Access DB with some logic and reports

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) 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.


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.

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

Lihat lagi: software write mq4, software write chip epson, useful software write book, access vba find and replace text in table, how to open find and replace dialog box in excel, replace function in access, ms access replace multiple characters, access replace null with text, find and replace dialog box access, access find and replace null, find and replace in access query, visual basic for apps, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, software write protection

Tentang Majikan:
( 176 ulasan ) Mississauga, Canada

ID Projek: #14445284

34 pekerja bebas membida secara purata $161 untuk pekerjaan ini


Greetings Ansales , i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can work on the access as I have 5 years of experience. Here is the reason. Why you Lagi

$250 CAD dalam 3 hari
(88 Ulasan)

Hello The import should be straight forward - the only trying part will be displaying the data graphically. However since you are using version 2007 we can easily use Pivot charts to create the pie charts. I am an Lagi

$180 CAD dalam 10 hari
(161 Ulasan)

p.s. as for hours(you mentioned 4-5 ) needs here - without looking through DB - impossible to define, but I'll code that as soon as possible Hi I hope all's well with you. I see you'r looking for a developer pro Lagi

$250 CAD dalam 3 hari
(42 Ulasan)

I am interested in this project. If interested in hiring me then please let me know so that we can finalize the scope, timelines and budget accordingly. Relevant Skills and Experience I am an experienced MS Access app Lagi

$166 CAD dalam 3 hari
(74 Ulasan)

Hello. I've just read your job posting and I’m very interested. I'm a certificated freelancer with almost 750 good reviews from clients. Please check my profile and portfolio. Best Regards. Relevant Skills and Experi Lagi

$250 CAD dalam 3 hari
(16 Ulasan)

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 Lagi

$30 CAD dalam sehari
(37 Ulasan)

I read your description and I feel I am a great candidate. I have been building databases for 16 years. I have built over 250 in that time. I have screenshot samples at Donnasdatabasedesigns on Facebook I have taken al Lagi

$275 CAD dalam 5 hari
(22 Ulasan)

I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Relevant Skills and Experience Access VBA Excel Windows App development Proposed Milestone Lagi

$177 CAD dalam 3 hari
(38 Ulasan)

Hi, I have read the description and will gladly help you with what's needed within 10 hours. I will relay on VBA for most of the work. Relevant Skills and Experience I'm an expert VBA, SQL and Access developer. I have Lagi

$155 CAD dalam 0 hari
(41 Ulasan)

Hi I'm an expert in .Net technologies and SQL Server. I have been working in software development for the last 20 years I'm a specialist in web solutions and desktop applications Relevant Skills and Experience Hi I Lagi

$155 CAD dalam 10 hari
(21 Ulasan)

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

$165 CAD dalam 4 hari
(33 Ulasan)

we have expertise in this domain(Access , Excel VBA ,SQL, DBA, data processing ). Client satisfaction is our main motto for long term relationship. Relevant Skills and Experience Access , Excel VBA ,SQL, DBA, data p Lagi

$100 CAD dalam 3 hari
(11 Ulasan)

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Lagi

$156 CAD dalam 2 hari
(5 Ulasan)

[login to view URL] be kind and consider my bid as I would like to assist you on this project.i have been working on different versions (2000-2013). My experience designing and coding in vba should be usefull. Relevant Skills Lagi

$100 CAD dalam 3 hari
(8 Ulasan)

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, fo Lagi

$277 CAD dalam 5 hari
(10 Ulasan)

A proposal has not yet been provided

$220 CAD dalam 3 hari
(8 Ulasan)

Have previous experience and enough time to complete this task Relevant Skills and Experience Programming skills Proposed Milestones $35 CAD - When delivering the DB

$35 CAD dalam sehari
(7 Ulasan)
$250 CAD dalam 5 hari
(3 Ulasan)

Hi Once you have a chance to meet me, you will never be trying to find other freelancers. Because I am the best match for you. I want you to look at my reviews before contacting me. Relevant Skills and Experience - C, Lagi

$155 CAD dalam 3 hari
(1 Ulasan)

i am an expert in this area. Stay tuned, I'm is still working on this proposal.

$155 CAD dalam 3 hari
(0 Ulasan)