Resource Dynamics, Inc.

Tele-Support HelpDesk Hot Tips

How to Execute a SQL Statement in Microsoft Access

• Open the .mdb file you would like to work with (e.g. HelpDesk.mdb)

• Under the list of objects for the database, select the "Queries" list
• Select "Create Query in Design View"
• If a "Show Table" dialog appears, close it
• From the main menu, select "View" and "SQL View"
• Enter/paste the SQL statement into the window and select "Query" - "Run" from the main menu