Creating and Modifying Queries in Access 2013 (Update Avail.)
Overview/Description Target Audience Expected Duration Lesson Objectives Course Number Overview/Description
Microsoft Access 2013 includes a collection of query options to help make creating and modifying queries, easy. Access provides a number of query types with the ability to review data before running the queries. You can update or delete data that meets a certain criteria, request user input, and add calculated fields to queries. You can also group and summarize your data in queries. This course explores creating queries through the Query Wizard and Query Design. It also covers different types of queries like the Update and Delete queries, as well as the Parameter query. This course will cover adding new fields to queries, saving queries, and renaming them. It will also cover hiding or removing fields from queries as well as deleting queries. Finally, this course shows how to add calculated fields to queries, and group and summarize data in a query.
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013