Wednesday, June 03, 2009

New Access Query Tutorial Series on Office Online

This series is available for free on the Access 2007 training courses page on Office Online:
  • Queries I: Get started with queries
  • Queries II: Create basic select queries
  • Queries III: Use expressions and other criteria
  • Queries IV: Use functions and calculated fields in your queries
  • Queries V: Use "And", "Or", and "In" to set multiple conditions
  • Queries VI: Use wildcards in queries and parameters
  • Queries VII: Query multiple sources for data
  • Queries VIII: Dealing with ambiguous joins

Ezy SQL Editor and Builder New v1.4 The ultimate Access query assistant: font options, find and replace, keywords assistant, parameter wizard, SQL string parsing & formatting, table and field references, insert formatted SQL Strings into modules or copy to the Clipboard, preview action queries, and more...