Question

how can we create a simple query in ms access ​

Answer 1

☆to create a simple one-table query:

Select the Create tab on the Ribbon, and locate the Queries group.

Click the Query Design command.

Access will switch to Query Design view. ...

Click Add, then click Close.

The selected table will appear as a small window in the Object Relationship pane.