Every registration supports local education. TrainUp Gives Back
Logo

Your Career Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

  • Instant Access ImageInstant Access
    From Anywhere
  • Unlimited Viewing ImageUnlimited
    Viewing
  • calendar Image 6-12 Months
    To Complete

Description

Advanced query methods in Access 2010 make it easy for an experienced end-user to retrieve the results they desire and to have those results displayed in such a way that the data is easy to interpret and analyze. This course describes the various types of join and parameter queries that can be used in Access 2010 and provides demonstrations on the use of action queries, including update, append, delete, and make table queries. It also explores the use of SQL-specific queries such as data-definition, pass-through, subquery, and union queries.

Learning Objectives
  • Create and edit joins in Access 2010 databases
  • Creates a parameter query
  • Modify data in existing tables
  • Create a new table from data in other tables
  • Delete data from an Access 2010 database
  • Identify how to create a union queries
  • Modify an object within a database using a data-definition query
  • Access a hosted database with a view to running a pass-through query
  • Remove duplicate records from a table using a subquery
  • Specify a join in a query
  • Use action queries to modify a database
  • Create and refine queries using SQL
  • Audience

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.