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