SMALL MS ACCESS DESKTOP APPLICATIONS

SALES SOLUTION DESKTOP APPLICATIONS WITH MS ACCESS Software : MS ACCESS Target : CREATING OF OUR CUSTOMER PRICE QUOTATIONS WITH THIS APPLICATIONS AND MEASUREMENT OF THE QUOTATIONS LIST OF PRODUCTS COMPONENTS THERE ARE SOME FACTOR MATERIAL,QTY,LENGTHS,SIZE,HOSE TYP,TYP OF FITTINGS OUR PRODUCTS : FLEXIBLE METAL HOSES COMPONENTS OF OUR PRODUCTS : [login to view URL] -WE HAVE 5 DIFFERENT HOSES AND EACH HOSE HAS 2 VARIANT ( WITH BRAID AND WITHOUT BRAID) - AND THE HOSES HAS SİZES FROM DN06(1/4”) to DN100 (4”) total 13 sizes FOR HOSE WE HAVE TO USE MATERIAL,SIZE,LENGTHS,AND HOSE TYP [login to view URL] PARTS - WE WILL ADD FITTINGSPARTS . THERE ARE MORE THAN 10 FITTINGS PARTS (MATERIALS OF FITTINGSPARTS DIFFERENT) FOR FITTINGS WE HAVE TO USE TYP,SIZE,MATERIAL,QTY 3. LABOR – WELDING AND TESTING COST WE CAN USE STANDARD 1-2 COST 4. PROFIT AS % WE CAN PUT THE PROFIT SELF IN THE LIST (For example 50,60 IT MEANS( MATERIAL PRICE LIST) + 50%,60% P.S. We h ave to create the list also [login to view URL] it will be any additions in the component list. FUNCTIONS OF THE PROGRAM - WE HAVE TO CREATE TO OUR CLIENTS DIFFERENT HOSE QUOTATIONS - THE PROGRAM MUST WORK WITH LOGIN ( USERNAME,PASSWORD) - “SALES PERSON A” CAN BE CREATE THE CLIENT LIST IN THE PROGRAM DB. - “SALES PERSON A” CAN CREATE FOR CLIENT THE PRICE QUOTATIONS AS PDF. ( WE CAN ADD SOME AUTOMATIC TEXT’S BEFORE QUOTATIONS, FOR EXAMPLE DEAR MR. CLIENT NAME, THANKS FOR YOUR INQUIRY ON THE DATE [login to view URL] CAN FIND BELOW OUR PRICE QUOTATION. ETC.) - THE CLIENT MUST SEE IN PDF FORM NOT ALL CALCULATIONS. JUST PRODUCTS DESCRIPTIONS, PRICE, TOTAL PRICE ACC. QTY, DELIVERY TERM, PAYMENT TERM AND NOTICES. - WE HAVE TO LIST ALL PRICE QUOTATIONS OF SALES PERSONS(A,B,C) - FOR EXAMPLE “SALES PERSON A” SENDET PRICE QUOTATION TO “CLIENT A” , AND “CLIENT A” CONFIRMED THE PRICE AND GAVE ORDER. “SALES PERSON A” MUST TİCK IN THE QUOTATIONS LIST THE RELATED QUOTATION. HOWEVER WE WILL SEE THE QUOTATIONS AND ORDERS OF “SALES PERSON A” , AND ALSO WHOLE QUOTATIONS AND ORDERS. ( SALES GRAPHICS ETC.) - OTHER SITUATION , “SALES PERSON A” SENDET PRICE QUOTATION TO “CLIENT A” , AND “CLIENT A” DONT SEND ANY REACTIONS,FEEDBACKS , “SALES PERSON A” HAVE TO SEND THE “CLIENT A” REMINDER FROM PROGRAM ( FOR EXAMPLE TIME LIMIT 15 DAYS ) OUR NEEDS ARE THIS , WE CAN MAKE THIS YEARLY PLEASE SEND US YOUR EXACTLY COST ... OTHERWISE YOUR OFFER DONT BE VALIDATED