Creating a Query with a Wizard
The process used to create a simple select query with the Query Wizard is almost identical to that for creating a form with the Form Wizard. With the Query Wizard, you can add one or more fields from existing tables or queries to the new query.
For Access to work effectively with multiple tables, it must understand the relationships between the fields in those tables. You have to create these relationships before using the Query Wizard, by clicking the Relationships button and then dragging a field in one table over the identical field in another table (the field names don’t have to be the same in each table, but the ...
Get Microsoft® Office Access 2003 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
