Access - Get Answers with Queries
Learn in one live hour how Access table relationships work: the main relationship types, how to create them and why primary and foreign keys let your queries answer real questions.
About this course
Learn in one live hour how Access table relationships work: the main relationship types, how to create them and why primary and foreign keys let your queries answer real questions.
Curriculum
- Learn the various types of table relationships
- Explore how to create table relationships
- Understand the purpose of primary and foreign keys
- Create basic select queries
- Explore all the query types
- Learn to create append, update and delete queries
- Add filter criteria to a query
- Uncover query calculations
- Create query totals
- Modify query joins
- Create crosstab queries
Who it's for
Access users who need answers from their data.
Before you start
No formal prerequisites. Bring curiosity and a willingness to practise.
Related courses
More in Microsoft Office & 365 Apps →55205 Mastering Microsoft Project 2016
Microsoft Office & 365 Apps
View course →55234 SharePoint 2016 Site Collections and Site Owner Administration
Microsoft Office & 365 Apps
View course →55238 SharePoint Online for Administrators
Microsoft Office & 365 Apps
View course →55301 Mastering Microsoft Project 2019
Microsoft Office & 365 Apps
View course →55342 Supporting and Troubleshooting Windows 11
Microsoft Office & 365 Apps
View course →Access - Customize Tables
Microsoft Office & 365 Apps
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.