Lesson 33: Creating Complex Queries. Lesson Objectives. After studying this lesson, you will be able to: Create a select query involving multiple tables Create a report based on multiple tables in a query Create and run parameter queries Create a calculated field in a query
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Criteria expression prompts user for a value when the query is run
Criteria expression appears in the query grid Criteria row
Tip! Brackets always surround the criteria expression.
Action query types
Source table is the active table; destination table identified in the dialog box