Microsoft Access 2010: Creating Flexible Queries

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.

This video is perfect for Microsoft Access 2010 users who are familiar with basic operations looking to learn to manipulate data more efficiently. Understanding the query functions saves users time, increases productivity and maximizes the value of the program. A quiz follows the video to test the learner’s comprehension.

   This course is in the Video On Demand format, to read about Video On Demand features click here.

Microsoft Access users

• 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

• Windows 8.1: Customizing the Windows 8.1 Environment
• Windows 8.1: Working with Desktop Applications
• Windows 8.1: Getting to Know PCs and the Windows 8.1 User Interface