Microsoft Access exercises - JOINS

To help you decide if this BASIC QUERYING IN ACCESS course is the right one for you why not try some of the exercises listed below? Here's how this works:

If you can't do any of the exercises, you're probably right for this course!
If you can do all of the easy exercises you may still benefit from this course
If you can do some of the standard and hard exercises you may want to look at one of our more advanced Microsoft Access training courses or consider tailored Microsoft Access training.

Here are the exercises available online for this BASIC QUERYING IN ACCESS course:

Exercise	Level
Create a query showing the number of countries in one table not in the other, and vice versa	Standard
Create 3 queries showing the use of inner and outer joins for tables of currencies and countries	Standard
Use grouping and totalling queries to find the the most expensive, oldest and young pets, and then create ad hoc joins to show their names	Hard
Create pairs of queries using grouping, joins and expressions to show the pet and owner with the longest name, plus the pet with the most limbs	Hard
An exercise to import two Excel spreadsheets, link them using ad hoc joins and then use a grouping and totalling query to show total debt by group name	Hard
An exercise to find the discrepancies between two tables	Hard
Create a query to delete all of those records from one table which have no match in another, using a credit control database	Hard
An exercise to show the party leaders who never made PM, using ad hoc joins and grouping and totalling queries	Hard

By providing these online Microsoft Access exercises we hope it helps you decide your own ability, so you can choose the right Microsoft Access training course for yourself or for your staff.

Microsoft Excel, Access, Project, VBA, Visual Basic, C# training

Microsoft Access exercises - JOINS

MICROSOFT TRAINING

FIND YOUR COURSE

OTHER SERVICES

YOUR TRAINING