Microsoft Access : Chapter 3 : Exercise 6


Exercise 6:  Creating and Running an Append Query

 

1.)  Click queries button in database and double-click create query in design view

2.)  The table box should have 3 tables including the “New Student” Table
      

     Click on the “New Student” Table and click Add

      Close the Box

3.)  Double-click the asterisk from the New Students box in order to put it into design view

4.)  Click query type button drop down arrow on toolbar and select “Append Table Query”

5.)  Select to append the “StudentStat” table using drop down arrow box

     Click OK

6.)  Click the Run button, the exclamation point on the toolbar (!), in order for the append query to operate

     Click yes when told you are adding four rows

     Close and then Save query as “Append New Students”

 

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

Back to Exercise 5

Continue to Exercise 6 Solution

 Back to Menu 


Microsoft Access : Chapter 3 : Exercise 6