:focal())
Description
Retrieving data? It's easy with our 'Access: querying tables' course!
There's no better program for storing data in a structured way than Access. But if you don't know how to find specific information, that won't get you very far. That's why Xylos developed the 'Access: querying tables' training, so you can quickly extract all the information you need.
Want to get the most out of your databases and become a master of queries? Sign up for this Access course, and searching through tables will become a breeze. Our other Access modules teach you to design a database (module 1) and create reports and forms (module 3).
Objectives
What will you get out of our 'Access: querying tables' course?
Want to pull ready-to-use information from your Access databases? Then our 'Access: querying tables' course is an excellent choice. After the course, you'll be able to:
Filter tables
Use the various query types
Combine queries with each other
Target audience
Anyone who wants to search for data in an existing database.
Prerequisites
You've completed module 1: Access: designing and creating a database. Or you're familiar with the Windows environment and have a basic knowledge of databases (such as tables and primary keys, and relationships and relationship types). Note: this Access training covers standard databases only, not web databases, as these have limited functionality.
Contents
Running simple searches in a table
Using search
Using the autofilter
Simple select queries
Adding tables to a query
Adding/removing/moving fields in a query
The impact of relationships on queries
The impact of multi-value lookup fields in a query
Sorting in a query
Adding simple criteria to a query (And, Or, In, Between, Null, "")
Using wildcards
More complex select queries
Parameter queries
Group-by queries
Crosstab queries
Calculations in queries
Using built-in functions
Join types (inner join, left join, right join)
Union queries
Action queries
Update queries
Append queries
Delete queries
Make-table queries
