• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Locating Specific Information > Creating a Query with a Wizard

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 field contents must represent the same information).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint