Getting to Know Microsoft Access, Part 6: Advanced Queries and SQL - AutoLookup Queries
(Page 2 of 5 )
AutoLookup queries are meant to save time. It works like this: you enter one value into a query and, based on a related table, the query fills in the remaining values for you in the table datasheet. AutoLookup uses two tables with a “one-to-many” relationship between them.
You create an AutoLookup query by adding two tables to the query design and then dragging the join field from the “many” side to the query grid. Add any other fields to the table you want, except the primary key field from the parent table. Once you’ve created this query it can be used as the basis for other database objects such as forms or reports. An AutoLookup query design looks similar to the following:
Action Queries
Action queries are used to perform data management operations on multiple tables simultaneously. The various types of action queries include: update, append, delete, and make-table queries.
Update queries make changes to fields in a group of records. Append queries add one or more records from one table to the end of another table. Delete queries delete a group of records from a table. Make-table queries create new tables from data in other tables.
Before creating any action queries, make copies of the tables you’ll be working with, just in case you accidentally erase something (or everything)!
Next: Update Queries >>
More Microsoft Access Articles
More By Sage Adams
/ 18 
