Access Mastering Queries
Course length: 1/2-day
Microsoft’s Office Access is Microsoft’s popular database program. Microsoft Access is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access will be helpful to you. Access makes it easy to keep track, organize, and sort your data.
This course helps access users understand and make the most out of Access queries.
In this advanced Microsoft Access course, students will review the basics of querying in Access and learn to use advanced querying techniques to get the results they need from their data.
This course is delivered using Access 2016. With the exception of the new modern look and touch screen support, there are few differences between the Office suites; therefore, users currently operating on Office 2010 and later will benefit from the material in this course.
Before attending this course, students must have completed Access Foundation (Level 1) or have equivalent knowledge.
- Access Foundation (Level 1) or equivalent Knowledge
Students will review the basics and practice making Select queries and using criteria to display specific data.
- Create a query using the wizard
- Create a query using Query Design
- Understand relationships between tables
- Create and modify table relationships in a query
- Use Criteria effectively with Comparison and Logical operators
- Create calculated Columns
Students will learn to use the Totals command to create summary queries, use aggregate functions on grouped data and a WHERE clause as criteria against the grouped data. Also covered in this module is information on how to change the join type between tables to achieve different results in your query.
- Create Summary or Total queries
- Crosstab queries
- Understand Joins
Data Management queries (Action Queries)
In this module students will learn how to use queries to manipulate data. Participants will be shown how to use tools to move and update data that is currently in the database and how to import only new information into a table from Excel or another database file.
SQL is a computer language that closely resembles English that database programs understand. Knowing SQL is important because every query in Microsoft Access uses SQL. Understanding how SQL works can help create better queries, and can make it easier for you to fix a query when it is not returning the results that you want.
- Create queries using SQL
- Create subqueries using SQL