Microsoft Access: Queries

Description

Master the art of queries! Students will create Queries of their data using the Query Wizard and by hand. Students will create queries to update data, delete data and view data. Students will create queries that will combine data from multiple tables. Students will need a copy of Access. A 30-day trial is available.

Objectives

• Students will design a query using the Query by Example form.
• Students will create queries that combine data from multiple tables.
• Students will create queries that update the data in a table, create a new table, append data to a table and delete data from a table.
• Students will create cross-tab queries and parameter queries.

Book

Lesson 1: Creating a Simple Query

Lesson 2: Creating Queries from Multiple Tables

Lesson 3: Queries that Change Data

Lesson 4: Advanced Queries

All content of this document is copyrighted by IDEA Solutions and the author. All rights reserved. Content may not be used without permission.