We help IT Professionals succeed at work.
Get Started

Microsoft Access Doubts for creating a new database

infiniti7181 asked
Last Modified: 2015-04-02
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.


Watch Question
MIS Liason
Most Valuable Expert 2012
This problem has been solved!
Unlock 3 Answers and 3 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE