3-day Virtual Seminar

Microsoft Access - Creating Select Queries

Overview

Microsoft Access lets you extract information from the database using select queries. This webinar will show you how to create, view, save, edit, sort, and filter your queries.

Areas Covered in the Session

• What is a query?
  
• How can I create a query with the Query Wizard?
  
• What is the QBE (Query By Example) grid?
  
• How do I add a table to the QBE grid?
  
• How do I add fields to the QBE grid?
  
• How do I view the results of my query?
  
• How do you change the sort in my query?
  
• How do you filter the query?
  
• How do you save the query?
  
• How do you create a unique values query?
  
• How do you create a top 10 query?
  
• How can you create a query based on multiple tables?
  
• How do you combine multiple text fields into one column?
  
• How do you perform mathematical calculations in a column?
  
• How do you add a grand total at the bottom?
  
• How do you create a totals only query?
  
• When do you edit the data in a query?
  
• What is the SQL view?
  
• How do you export the query results to a spreadsheet or word processor?

Who Will Benefit

• Administrative Professionals 
  
• Office Workers
  
• Database Designers
  
• Data Analysts 
  
• Managers of All Levels 
  
• Small Business Owners