Hi Guru's ,
I would like to make pre-sales forecast sheet in access. As I am new in this, I am excited to do work from scratch .
Objective : To create a database, entering the data for contents such as oppurtunities (eg: customer name , customer type , region , vendor details etc , date of receive of RFP , date of submission , status - won , lost , inprogress etc) .
I have couple of questions related with this .
1. What is the best practice to add the contents for each section , in other words , is it recommended to add separate tables for each section and link them together . Eg: Vendor will be a different table , Status - Won , Lost etc will be different table or so on .
2. If I need to design as a form , how will I add a content that says " click for new opportunity " and when I click it a new form opens .
3. Lets says , I have added four vendor names in the database as raw (eg: Cisco , Aruba , HP , Juniper etc ) . Now I go to form and select as pull down menu of these vendors and see these four. If I need to add the fifth vendor, is there a possibility that I can add " Add New" and a new form appears to add vendor name
Appreciate your kind help and support.