Description
Retrieving data? It’s simple with our ‘Access Queries’ training course!
There is no better program than Access for structured storage of data. But if you don’t know how to retrieve specific information, then it’s not going to be of much help. For this reason Xylos developed the ‘Access Queries’ training course to teach you how to quickly retrieve all the desired information.
Would you like to get the most out of your databases? And become a master at working with queries? Enrol now for our Access training course. And search through tables with a flick of your wrist and a click of your mouse. In our other Access training courses, you can learn how to design databases (module 1) and make reports and forms (module 3).
Objectives
What will you get from our ‘Access: Queries’ training course?
Do you want ready-to-use information from your Access databases? Then our ‘Access: Queries’ training course would be an excellent choice. After completing the course you are able to:
- Filter tables
- Use the different query types
- Combine queries with each other
Target Group
Anyone who wants to – or needs to – retrieve data from an existing database.
Prerequisites
You have already followed Module 1 ‘Access: Creating Databases’. Or you are familiar with the Windows environment and have a basic knowledge of databases (such as tables and primary keys, relationships and relationship types). Attention: this Access training course only discusses the default databases, not the web databases, as these have limited functionality.
Content
Performing simple searches in a table
- Use of Search
- Making use of the autofilter
Simple selection queries
- Adding tables to a query
- Adding/deleting/moving fields in a query
- Influence of relationships on queries
- Influence of multi-value look-up fields in a query
- Sorting in a query
- Adding simple criteria to a query (And, Or, In, Between, Null,)
- The use of Wildcards
More complex selection queries
- Parameter queries
- Grouping queries
- Cross tables
- Calculations in queries
- The use of in-built functions
- Join types (inner join, left join, right join)
- Union queries
Action queries
- Update queries
- Append queries
- Delete queries
- Make-table queries
