SQLConfiguration SQLConfiguration





Access Macros  «Prev  Next»

Running Queries with Macros - Exercise

Running a query from a macro


Objective:Obtain practice running queries from macros.

Exercise scoring

You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the Submit button to receive full credit.

Background/overview

Recall that you are the Access database administrator for the marketing and documentation departments of companies in the software and networking business. For one of your large clients, you need to run an update on a query from a macro.

Instructions

By using the project database, run the query qryProjectRates from a macro, by using SetWarnings to turn off and on the prompts.