Open a query in Design view

1. In the Database window, click Queries under Objects.
   
   
2. Click the query you want to open, and then click Design on the Database window toolbar.

Notes

• If a form, report, or data access page is based on a query, you can open the query to modify its design directly from the form, report, or data access page. For more information, click .
  
  
• If you previously saved a query while it was displayed in SQL view, that's the view Microsoft Access displays the next time you click Design on the Database window toolbar for that query.