Thursday, April 24, 2014

How to edit an existing append query in Microsoft Access 2013?‏

If you would like to view or edit the SQL codes of an existing append or delete query from Navigation pane in Microsoft Access 2013, you may not open that query or right-click to see the menu since it's not in design mode.

To open an existing append, update or delete query in design mode: 
  1. Open the Microsoft Access 2003 .mdb file while holding the shift key, Access 2013 will open with Navigation pane in design mode. 
  2. Select the append query. 
  3. Right click. 
  4. Select Design View. 
  5. Change to SQL View to see SQL statements.

No comments: