Microsoft Access : Chapter 3 : Exercise 3


Exercise 3:  Creating a Query

Step 1
 

Open Microsoft Access

 

Open the existing file, “people,” which you used in the previous exercises

 

Click OK

Step 2
 

Click on Queries, which is under Objects

 

Click on Create a query in Design View

 

Click on New

 

Click on Design View

 

Click OK

Step 3
 

Click on the Tables tab

 

Click on Students

 

Click Add

 

Click on Close

Step 4
•

Make Last name the heading for the 1st field, put in ascending order

•

Make First name the heading for the 2nd field

•

Make Age be the heading for the 3rd field, for students less than 20

•

Click on Query

•

Double Click on Run

 

Continue to Exercise 3 solution to compare your final Query with the correct answer....... 

Back to Exercise 2

Continue to Exercise 3 Solution

 Back to Menu 


Microsoft Access : Chapter 3 : Exercise 3