Microsoft Access : Chapter 3 : Exercise 5


Exercise 5: Creating and Running a Delete Query

1.)  Click queries in database
 

      Next click on the “Archive Juniors and Seniors” query

     Copy the query to a clipboard using Edit Menu

 

2.)  Select Edit Menu again, click paste in order to display the Paste As box

     Type in the box “Maryland Juniors and Seniors”

     Click OK

3.)  Select the query you just made in design view

      Just as in the previous exercise, select the query drop down menu, but this time select delete query

4.)  Set a new control in the Criteria row and under the Credit column to be “<=120”

    Click the run button, which is an exclamation point on the toolbar (!), in order to execute the query

    Save the changes if the program offers to

 

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

Back to Exercise 4

Continue to Exercise 5 Solution

 Back to Menu 


Microsoft Access : Chapter 3 : Exercise 5