Any one use Access Database?

jerem0621 wrote:
tables store your data
queries let you view the data you want to see
forms let you enter your data


don't confuse one with the other... they each have their own function... people get confused when trying to make one do something it's not designed to do.

Once I have my tables and forms set up, I then set up my queries how I want them. Then If I have to I can extract the query results into excel.

Thanks!

Jeremiah

Excellent thumb-nail summary!
Databases are great at keeping your data organized. Spreadsheets are great at doing math! Excel has, of course, been given many database-like functions, but at it's heart, it wants to add numbers, not keep track of lists! Access, however, is pretty hard to do math with. So there is a place for each. It does get hard though, when you try to convince one application to mimic the abilities of the other! The row-and-column formats each starts with seem like they should be similar, but beyond the representation on screen, they are pretty different beasts. And let's not discuss all the people who type documents, memos, etc. using Excel rather than using Word!