Find Jobs
Hire Freelancers

Microsoft Access 2003 Database for Invoicing and stock control

£2-5 GBP / hour

Closed
Posted over 6 years ago

£2-5 GBP / hour

I have been using a MS Access 2003 DB for many years, I now need to modify and enhance some basic reporting features and create a few modifications in VB I have no knowledge in VB, and limited knowledge in Access Macros. Task: 1. Create a monthly customer account statement This is a standard report displaying amounts due in the respective monthly periods Current Period 30 Days 60 Days 90+ Days 2. Create Form for payment to customer accounts singular or bulk payment options, part payment option on any invoice, payment methods with split option for cash/card/bank transfer etc. 3. Create Reports based on Product ID 3.1 Product sales history : calculated fields to include profit, quantity sold and supplier price history 4. Create report for Customer Invoice and Quotation history, Calculated fields for total spend and quotes not turning to sale. 4. create financial reports 4.1 VAT report based on date periods 4.2 Profit Report based on date periods I will add other features to DB as we commence work
Project ID: 15399449

About the project

21 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
21 freelancers are bidding on average £6 GBP/hour for this job
User Avatar
ID : 15399449 Greetings, We are interested to work on this project, please find my comments inline with yours, 1. Microsoft Access 2003 Database for Invoicing and stock control => I worked over 18 years for simple to very complex Microsoft Access databases. is the front-end , back-end separate files or single file ?Does it use DAO or ADO ? or bound forms ? 2.I have been using a MS Access 2003 DB for many years, I now need to modify and enhance some basic reporting features and create a few modifications in VB => OK, can you share the database for review ? 3. I have no knowledge in VB, and limited knowledge in Access Macros. => I like VBA, advanced VBA instead of macros. 4. 1. Create a monthly customer account statement This is a standard report displaying amounts due in the respective monthly periods , Current Period 30 Days , 60 Days , 90+ Days => OK 4.2. Create Form for payment to customer accounts singular or bulk payment options, part payment option on any invoice, payment methods with split option for cash/card/bank transfer etc. => OK, so we need to add fields for this ? or they are already added ? 4.3. Create Reports based on Product ID :3.1 Product sales history : calculated fields to include profit, quantity sold and supplier price history => OK, what paper size and margins ? A4 with 1 inch margin each side. Do we need a date range screen to get From, TO date field ? the data will come from single table or multiple tables or query ? 4. 4. Create report for
£10 GBP in 20 days
4.9 (332 reviews)
7.6
7.6
User Avatar
A proposal has not yet been provided
£11 GBP in 40 days
4.9 (11 reviews)
5.9
5.9
User Avatar
Hi I am interested in this project. I am an experienced MS Access applications developer. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines and budget accordingly. Thanks Regards Jawad
£22 GBP in 40 days
5.0 (93 reviews)
5.8
5.8
User Avatar
A proposal has not yet been provided
£8 GBP in 40 days
4.9 (44 reviews)
5.4
5.4
User Avatar
Hello I am working with MS-Access database and VBA for the past 15 years. I have also developed many important application using MS-Access as both front-end and back-end tool and have completed a good number of Access Projects through Freelancer.com. I would do your work and is ready to start right now. I have gone through your detail project specification. Give me the job, get it done, satisfy yourself and then make payment. I wont seek any payment from u until ur job is fully done as per your satisfaction. Customer satisfaction is much more important and my top most priority. No satisfaction no payment. Hope to hear positively from u. Regards John
£3 GBP in 40 days
4.8 (35 reviews)
4.9
4.9
User Avatar
A good project that I will be wanting to work on. I assure you a quality work. Provisioning of old db will be very helpful. If you would like, your application can also be created in php too in just 250 pounds. But its all up to you.
£3 GBP in 40 days
5.0 (2 reviews)
3.0
3.0
User Avatar
Good day! I have developed and currently maintain Point Of Sale, Inventory and Accounting systems. Your project requirements is almost the same as what i have done so I am ready to work with you on this project. I use vb6, vb.net for programming and ms access or ms sql as backend databases. Should you need further information about my work, you can contact me at your convenience. Thanks and best regards
£5 GBP in 40 days
5.0 (2 reviews)
2.6
2.6
User Avatar
dear client , hope you doing well . i 've gone through your requirement . i'm designer , developer and coder having experience of more than 5 year .want to take interest in your project i can easily help you! will wait for your reply!
£2 GBP in 40 days
5.0 (3 reviews)
2.3
2.3
User Avatar
With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects which involved Programming, Ms-access, VBA, Excel and macros. Key features of my work are as follows: 1) Always within schedule 2) Always within scope Looking forward to hear from you. Regards
£3 GBP in 40 days
5.0 (1 review)
2.0
2.0
User Avatar
Hi there! You’re looking for a VBA Developer and this is exactly what I specialise in. Talk about a perfect match! I’ll keep this short and we can go into more details when we chat. I look forward to our chat. Have a great day!
£2 GBP in 40 days
5.0 (1 review)
0.7
0.7
User Avatar
I am expert into VBA development, and we have already developed a small ERP system for a company using MS Access 2003. So, Please share us more details, I will ensure that all the functionality working fine with existing features and i am ready with demo project.
£5 GBP in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
already developed similar kind application using vb and access
£5 GBP in 25 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Expert in MS Access VBA, Excel VBA. Have worked on similar projects. High productivity. Easily grasp requirements.
£3 GBP in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Sir/Ma'am, I understand that you want to Change and Enhance your VB - MS Access system to suit your current Requirements. You want to be able to view reports that give you a good idea about account status, sales, payments, taxes, profit etc. I am interested in your project since I have handled requests of similar nature in the past. I have worked on VB6, VB.Net and MS Access, MS Excel, SQL for almost a decade now. Further, I am a seasoned professional and and experienced developer having worked for many customers from the States and Europe for many years. I am sure I will be able to enhance your app per your requirements and provide complete Value for Money for the budget that you will allocate. Eagerly waiting to talk to you further! Regards, Prithwiraj D Jadhav
£11 GBP in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hii iam a programmer and ihave been working in msaccess database for 12 years and i have more then 30 project in access
£5 GBP in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi. I’ve been developing excel, acesa vba for years. Also transforming access apps into web apps. The time user will depende of complexity of BD.
£5 GBP in 50 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
glasgow, United Kingdom
5.0
2
Payment method verified
Member since Sep 23, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.