Working with Excel and Microsoft Groove to have a database of cust

[katiapro93]

Hi, I have just started with a company which uses Excel and Microsoft Groove
for all their database & forms. I am looking to create a database of
customers' name, address, & ID # in excel and then find a way to create a
form in excel that will pull all the customer's info stated above and put
them into their respective cells. So, when I pull a form, I start typing a
customer name and excel goes to this database finds a matching customer and
fills in the address, City, State, & ID on the form. Does anyone know if
this is an easy thing to do in Excel? Can anyone show me how? Thanks!

 

[Gina Whipp]

katiapro93,

Sounds like you meant to post to the Excel newsgroup. In the Microsoft
interface scroll a bit further down, you landed on the Microsoft Access
newsgroup a relational databse software.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[John W. Vinson]

Hi, I have just started with a company which uses Excel and Microsoft Groove
for all their database & forms. I am looking to create a database of
customers' name, address, & ID # in excel and then find a way to create a
form in excel that will pull all the customer's info stated above and put
them into their respective cells. So, when I pull a form, I start typing a
customer name and excel goes to this database finds a matching customer and
fills in the address, City, State, & ID on the form. Does anyone know if
this is an easy thing to do in Excel? Can anyone show me how? Thanks!

I would suggest that if you want to do this in Excel rather than in Microsoft
Access (the subject of this newsgroup) that you post in an Excel forum. The
webpage can be confusing and may have misled you - scroll down the subject
areas and find an appropriate Excel group.

That said... you really should consider using Access for this purpose. Excel
is a spreadsheet, a very good one; Access is a database development
environment. "You can drive nails with a crescent wrench but that doesn't make
it a hammer" - and you can create databases in Excel, in a sense, but that
doesn't mean that it's the best program for that purpose!

Here's some resources for Access if you decide to pursue this option:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials