Automates Access cells for a noob

H

HoganD87

So it takes me days to perfect the Excel Spreadsheet that my boss wanted, but
now he wants too much and Excel can only go so far.

I know nothing about Access so I'm looking for some pretty intense help.

for example.

If I type under a location "Dallas, TX" I want the next cell to
automatically say "1" under its Region Column.

Same as customers.

Say if I enter "DynaTen" under a customer column, how do I make the names
and email addresses automatically pop up for the cooinciding company?
 
J

Jerry Whittle

First things first: Access does not have 'cells'. It has fields and records.

Second: You can't do any calculations or data manipulation in an Access table.

Third: You create a table called something like REGIONS where you have a
field for Location and another field for Region. You populate this table with
all the Region / Location combinations. Then you join this table with your
other table based on the matching Location fields in a query. That's how you
get to see the 1. Same goes for the other problem.

I highly recommend getting some relational database training or reading
"Database Design for Mere Mortals" by Hernandez before proceeding any further
on this database.
 
J

John W. Vinson

So it takes me days to perfect the Excel Spreadsheet that my boss wanted, but
now he wants too much and Excel can only go so far.

I know nothing about Access so I'm looking for some pretty intense help.
Click to expand...

Access is NOT "Excel on Steroids".

It's a *very* different program, with a different logical structure, a
different required mindset, and a steeper learning curve than Excel.

It's capable of doing some things which would be very difficult or impractical
in Excel (the reverse is true too! Access isn't a spreadsheet!), but you need
to understand the logic of relational databases to make this possible.

See some of the tutorials and overviews at:

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

John W. Vinson [MVP]
 
Top