Creating Flexible Queries|Setting the Select Query Properties|Retrieving Records Based on Input|Using Queries to Create Tables|Using Queries to Update Data|Using Queries to Append Data|Using Queries to Delete Data
This Video On Demand teaches users how to create flexible queries to obtain information quickly and reliably in Microsoft Access 2010. Viewers learn how to select query properties, retrieve records based on dynamic input criteria, create tables with queries, update data via queries, as well as use queries to append and delete data. The course reveals common pitfalls of building queries and then provides tips for constructing queries to retrieve the exact information desired. Common errors, warning messages, and solutions are also presented. Understanding the query functions saves users time, increases productivity and maximizes the value of the program.