Closed

Microsoft Access 2003 Database for Invoicing and stock control

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

Skills: Microsoft Access, Software Architecture, SQL, Visual Basic, Visual Basic for Apps

See more: microsoft access invoice database template free, ms access inventory and sales database, inventory database example, microsoft access inventory management software, ms access inventory templates free download, ms access inventory management database free download, ms access invoice template 2007, ms access sample database for inventory, microsoft access 2003 treeview control, microsoft access restart database vba, microsoft access inventory database, modifying microsoft access 2003 templates, access 2003 database exe file, microsoft access optometry database, microsoft access contact database, microsoft access email database bulk mail, net project access 2003 database, inventory microsoft access 2003, microsoft access event database, microsoft access custom database minneapolis

About the Employer:
( 2 reviews ) glasgow, United Kingdom

Project ID: #15399449

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
zu02

Hi I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll enhance your current Ms Access More

£4 GBP / hour
(52 Reviews)
6.2
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 my portfolio on Access. Graphical Reports [login to view URL] More

£15 GBP / hour
(69 Reviews)
5.7
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
£3 GBP / hour
(4 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
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
£2 GBP / hour
(0 Reviews)
0.0
£3 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
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
viswanath28

already developed similar kind application using vb and access

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