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!

ADVANCED QUERIES exercises

This page lists the 16 exercises about Advanced queries in Access on our website:

Software:	Access
Topic:	Advanced queries
Level:	Relatively easy
Exercise:	Create a query showing the number of songs each artist has recorded.

Show this exercise

Software:	Access
Topic:	Advanced queries
Level:	Relatively easy
Exercise:	Use an expression to show the Oscar shortfall for each film.

Show this exercise

Software:	Access
Topic:	Advanced queries
Level:	Average difficulty
Exercise:	Analyse data of billionaires to show the number there are per country and their average age.

Show this exercise

Software:	Access
Topic:	Advanced queries
Level:	Average difficulty
Exercise:	Create a query to show the average worth per year lived for billionaires.

Show this exercise

Software:	Access
Topic:	Advanced queries
Level:	Average difficulty
Exercise:	Create Access queries that prompt the user for criteria.

Show this exercise

Software:	Access
Topic:	Advanced queries
Level:	Average difficulty
Exercise:	Create an expression using summing and the LEN function.

Show this exercise

Software:	Access
Topic:	Advanced queries
Level:	Average difficulty
Exercise:	Use the & concatenation symbol to join fields together in Access.

Show this exercise

Software:	Access
Topic:	Advanced queries
Level:	Average difficulty
Exercise:	Use the MONTH and YEAR functions and criteria to pick out actors.

Show this exercise

Software:	Access
Topic:	Advanced queries
Level:	Harder than average
Exercise:	Create a query calculating the error in reported population density for a list of countries - this involves creating a query based on a query.

Show this exercise

Software:	Access
Topic:	Advanced queries
Level:	Harder than average
Exercise:	Create a query manipulating string expressions to get dates.

Show this exercise

Software:	Access
Topic:	Advanced queries
Level:	Harder than average
Exercise:	Create a query showing the average sales and profits for a subset of companies.

Show this exercise

Software:	Access
Topic:	Advanced queries
Level:	Harder than average
Exercise:	Create a query which joins a table to a grouping/totalling query to show the names of the highest grossing films for each year.

Show this exercise

Software:	Access
Topic:	Advanced queries
Level:	Harder than average
Exercise:	Create parameter queries in Access to list out, for example, all of the owners born between any two dates that you enter.

Show this exercise

Software:	Access
Topic:	Advanced queries
Level:	Harder than average
Exercise:	Use a grouping query with formulae to show the most profitable director.

Show this exercise

Software:	Access
Topic:	Advanced queries
Level:	Harder than average
Exercise:	Use theCLNG and RIGHT functions to extract the last value from a list of years.

Show this exercise

Software:	Access
Topic:	Advanced queries
Level:	Harder than average
Exercise:	Use various string functions to extract the last word from a song title.

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 EXERCISES

ADVANCED QUERIES exercises

Head office

London

Manchester