Access Presentation 3. By: Rasagnya Waghray Ali Murtuza. Overview. Create Queries Using Query Wizard Using Design view Example Criteria Wild cards Using relational operators in criteria Using compound criteria. Overview (cont). Omit duplication from query result
Select the table you want to have query from and add the fields that you want to show in your query, click on next and “finish”.
Select the table and the fields you want to add for the query
Step1: Choose simple query wizard
Add the tables you want to use for your query
You should switch to the design view of the query if you want to make changes to the query.
But not “a123abc”
And not “abc123”.
Or query result
Specify the criteria