Saturday, March 5, 2022

Microsoft Access : Create a select query by using the Simple Query wizard and Design View


How to Create tab in Microsoft Access includes two commands in its Queries group:

  1. Query Wizard
  2. Query Design

To run a query :

  1. In the Navigation pane, double-click the query.
  2. In Design view, click Runon the Query Tools Design tool tab.

To save a query :

  1. On the Quick Access Toolbar, click Save.
  2. In the Save As dialog box, enter a name for the query, and then click OK.

To delete a query :

    In the Navigation pane, right-click the query, and then click Delete.

To create a select query by using the Simple Query wizard :