Welcome To Access Databases
Create Database
Table
Query
Form Button
Report
 
 
 
 

 

Create Query

Open The Fish database file and Aquarium table.

Click on the word South Asia in the Native To:  column

On Records menu, choose Filter, then Filter By Selection

On Records menu, choose Filter, then Advanced Filter/Sort. 

From File menu, choose Save as Query.

In Query Name text box, type Fish of South Asia

OK. File, Close

File, Close the Aquarium table but   NO  don’t save the changes.

Now go back and see if you made the query.

On Window menu, choose The Fish: Database.  Then choose Queries.