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 17 exercises about Advanced queries in Access 2003 on our website:

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

Show this exercise

Software:	Access 2003
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 2003
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 2003
Topic:	Advanced queries
Level:	Average difficulty
Exercise:	Create Access queries that prompt the user for criteria.

Show this exercise

Software:	Access 2003
Topic:	Advanced queries
Level:	Average difficulty
Exercise:	Get statistical information using separate Access grouping and totalling queries.

Show this exercise

Software:	Access 2003
Topic:	Advanced queries
Level:	Average difficulty
Exercise:	Use Access calculated expressions to show the VAT due on the bills of each pet.

Show this exercise

Software:	Access 2003
Topic:	Advanced queries
Level:	Average difficulty
Exercise:	Use Access grouping and totalling queries to list the number of pets of each colour, the number of pets with four limbs, and the highest vet bill.

Show this exercise

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

Show this exercise

Software:	Access 2003
Topic:	Advanced queries
Level:	Average difficulty
Exercise:	Use the Access LEN function to find out the length of different owner names in a query.

Show this exercise

Software:	Access 2003
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 2003
Topic:	Advanced queries
Level:	Harder than average
Exercise:	Create a query manipulating string expressions to get dates.

Show this exercise

Software:	Access 2003
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 2003
Topic:	Advanced queries
Level:	Harder than average
Exercise:	Create a query to calculate the age of each owner, and the difference between this and the age of each pet.

Show this exercise

Software:	Access 2003
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 2003
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 2003
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 2003
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 2003 EXERCISES

ADVANCED QUERIES exercises

Head office

London

Manchester