This page has 0 threads | Add post

Exercises

Many people around the world enjoy and benefit from our exercises. If you're one of them - and can afford to - please make a small donation to help keep this and future blogs, exercises, skills assessment tests, tips, tutorials and videos freely available to everyone!

JOINS exercises

This page lists the 8 exercises about Joins in Access 2003 on our website:

Software:	Access 2003
Topic:	Joins
Level:	Average difficulty
Exercise:	Create 3 queries showing the use of inner and outer joins for tables of currencies and countries.

Show this exercise

Software:	Access 2003
Topic:	Joins
Level:	Average difficulty
Exercise:	Create a query showing the number of countries in one table not in the other, and vice versa.

Show this exercise

Software:	Access 2003
Topic:	Joins
Level:	Harder than average
Exercise:	An exercise to find the discrepancies between two tables.

Show this exercise

Software:	Access 2003
Topic:	Joins
Level:	Harder than average
Exercise:	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.

Show this exercise

Software:	Access 2003
Topic:	Joins
Level:	Harder than average
Exercise:	An exercise to show the party leaders who never made PM, using ad hoc joins and grouping and totalling queries.

Show this exercise

Software:	Access 2003
Topic:	Joins
Level:	Harder than average
Exercise:	Create a query to delete all of those records from one table which have no match in another, using a credit control database.

Show this exercise

Software:	Access 2003
Topic:	Joins
Level:	Harder than average
Exercise:	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.

Show this exercise

Software:	Access 2003
Topic:	Joins
Level:	Harder than average
Exercise:	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.

Show this exercise

You can search our full list of Access exercises here. Or why not learn to do them the right way on one of our Access training courses? You can attend our online training classes wherever you are in the world!

None of the exercises or supporting files may be copied in any form or used commercially without the prior written permission of Wise Owl (although you're welcome to use them for testing your own knowledge).

This page has 0 threads

Add a new post

EXERCISE TOPIC

ACCESS EXERCISES

ACCESS 2003 EXERCISES

JOINS exercises

Head office

London

Manchester