Microsoft Access 2003 Database for Invoicing and stock control

Closed Posted 6 years ago Paid on delivery
Closed

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

Microsoft Access Software Architecture SQL Visual Basic Visual Basic for Apps

Project ID: #15399449

About the project

21 proposals Remote project Active 6 years ago

21 freelancers are bidding on average £6/hour for this job

illuminesoft

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 simpl More

£10 GBP / hour
(332 Reviews)
7.6
lavizsolutions

A proposal has not yet been provided

£11 GBP / hour
(11 Reviews)
5.9
jawadaman

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 More

£22 GBP / hour
(93 Reviews)
5.8
carlosperezit

A proposal has not yet been provided

£8 GBP / hour
(44 Reviews)
5.4
KellogITSolution

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 Acce More

£3 GBP / hour
(35 Reviews)
4.9
nawazwasif

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 More

£3 GBP / hour
(2 Reviews)
3.0
boyet0911

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

£5 GBP / hour
(2 Reviews)
2.6
Rajesh088

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! More

£2 GBP / hour
(3 Reviews)
2.3
narsim3128

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-ac More

£3 GBP / hour
(1 Review)
2.0
shantechindia

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 cha More

£2 GBP / hour
(1 Review)
0.7
snikita762

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 existi More

£5 GBP / hour
(0 Reviews)
0.0
viswanath28

already developed similar kind application using vb and access

£5 GBP / hour
(0 Reviews)
0.0
praganmat

Expert in MS Access VBA, Excel VBA. Have worked on similar projects. High productivity. Easily grasp requirements.

£3 GBP / hour
(0 Reviews)
0.0
prithwirajdtj

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, p More

£11 GBP / hour
(0 Reviews)
0.0
asem1122

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 / hour
(0 Reviews)
0.0
cfhserra

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 / hour
(0 Reviews)
0.0