VBA-SQL Tool for testing SQL

							                   Notes on the VBA-SQL Tool for testing SQL

   If you are using Access 2007 (not Access 2003) you may need these extra steps:
    The initial screen includes a security message – click ‘Options’ and select ‘Enable
    Content’.




       Then click on the ‘Add-Ins’ tab to get the correct screen layout:




   Whichever version you are using:

1. Click ‘Table list’ and choose table to display data – any SQL entered acts on these

2. Type SQL into top pane. When semi-colon is entered it is entered (or the Execute
   SQL button is clicked), the results are shown in bottom pane:
3. Click on ‘Previous SQL’ to list previous statements so you can run one again (or
   correct it and run it again!).
4. Click the Clear SQL button to clear the top pane.
5. Click the Clear Results button to clear the bottom pane.