1 / 9

MS Access: Creating Advanced Queries

Master advanced query techniques in MS Access with this course. Learn how to summarize, group data, use concatenation, run unmatched queries, design crosstab queries, set parameter queries, utilize indexes, and more. Instructor: Vicki Weidler, Assistant: Joaquin Obieta.

huseman
Download Presentation

MS Access: Creating Advanced Queries

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MS Access: Creating Advanced Queries Instructor: Vicki Weidler Assistant: Joaquin Obieta

  2. Overview • Use a select query to summarize and group data from different tables • Write a concatenation statement to combine values from different fields • Use the Find Unmatched Query Wizard to locate records that do not match between tables • Design a crosstab query to summarze grouped data • Create single- and multiple-criteria parameter queries • Learn how to use a wildcard in a parameter query • Create single- and multiple-field indexes to quickly sort and filter data in a table

  3. Concatenation Concatenation is the process of combining values from different fields into one field

  4. Find Unmatched Queries Use a Find Unmatched Query to view records that don’t have a matching record in another table Example: Locate customers who don’t have matching entries in the Orders table.

  5. Crosstab Queries Display a summary of values based on two different types of information. Generally used to display large amounts of data in a compact format for easy review. Used to calculate averages, sums, or other totals on records, then group the results into two types of data. One group runs down the left side of the datasheet while the other runs across the top.

  6. Parameter Queries A parameter query displays results based on criteria you specify each time you run the query. One or multiple parameters can be used.

  7. Indexes Indexes are used to quickly sort and find data in tables. An index performs a search based on key values. Primary keys are automatically indexed.

  8. Summary • Use a select query to summarize and group data from different tables • Write a concatenation statement to combine values from different fields • Use the Find Unmatched Query Wizard to locate records that do not match between tables • Design a crosstab query to summarze grouped data • Create single- and multiple-criteria parameter queries • Learn how to use a wildcard in a parameter query • Create single- and multiple-field indexes to quickly sort and filter data in a table

  9. Conclusion • Resources • Questions & Answers • Evaluations • Thank You!!!

More Related