For practice using SQL commands in MS Access:

Unless otherwise indicated:

– Under Objects, select Queries.

– Select "Create query in Design view" (double-click to open).

– Close the Show Table dialogue box.

– Click the SQL view button (leftmost button under the menu bar) or choose View / SQL View from the menu bar.

– In the window called "Query1: Select Query", type the SQL statement, replacing SELECT with the appropriate SQL

command. Be sure to keep the semi-colon statement terminator.

– To execute the command, click the Run button (!) or by choosing Query / Run from the menu bar. (Note: For queries that modify data, you can usually see which records or how many records will be modified without actually executing the query by changing the "view" to Datasheet View: Use the View button or choose View / Datasheet.)

– Save the query and close the SQL design window.

==============================================================================

MS Access denotes DML statements as "action queries" and warns the user any time data will be modified.

Abbreviated list of steps for DML exercises:

1. Type the statement in the SQL window.

2. Check results without executing by switching to Datasheet view.

3. Execute the statement (click Yes when prompted about continuing).

4. Check the results in the appropriate table.

5. Save the statement and close it.

Access may change the SQL in non-standard ways when you leave the SQL window.

This does not change how the statement works.

==============================================================================