Help with basic theory. Queries vs. Tables (noob)

[HeadGasket]

Trying to get reaquainted with Access and could use some help with basic good practice / theory. Using V2007.



I'm creating a database that will be able to log events that take place. I've set up individual tables for things like Employees, Customers, Event Types, etc.

My idea was to then create a form that would use drop down windows to aid in data entry (names, companies, etc.). This data would then be stored in an 'Event' table.

Here is the question. Should I be creating Queries to help me with this or is it okay just to set up the Lookup and Row Source properties within my 'Event' table? Not sure if that question makes sense.

Maybe someone might be able to give me some basic info on when Queries should be used or what their benefits are. Are queries used more for creating reports?

Thanks.

[Stingaway]

Using queries with forms and reports vs. Tables gives you more flexibility in the long run should you decide you need more information that may not necessarily be required in the table. (Example - concatenated fields, date functions, string manipulations, etc.)

[HeadGasket]

Thanks, Stingaway. Your answer jogged my memory a bit. I will keep that in mind

[pbaldy]

And FYI, most of us don't like the Lookup field (the table-level property):

http://access.mvps.org/access/lookupfields.htm