Microsoft Access exercises - ADVANCED QUERIES

To help you decide if this ACCESS INTRODUCTION FOR DEVELOPERS 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 ACCESS INTRODUCTION FOR DEVELOPERS course:

Exercise	Level
Create a query showing the number of songs each artist has recorded	Easy
Analyse data of billionaires to show the number there are per country and their average age	Standard
Create a query to show the average worth per year lived for billionaires	Standard
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	Standard
Get statistical information using separate Access grouping and totalling queries	Standard
Use the Access LEN function to find out the length of different owner names in a query	Standard
Use Access calculated expressions to show the VAT due on the bills of each pet	Standard
Create Access queries that prompt the user for criteria	Standard
Use the & concatenation symbol to join fields together in Access	Standard
Create a query manipulating string expressions to get dates	Hard
Create a query showing the average sales and profits for a subset of companies	Hard
Create a query calculating the error in reported population density for a list of countries - this involves creating a query based on a query	Hard
Use theCLNG and RIGHT functions to extract the last value from a list of years	Hard
Create a query which joins a table to a grouping/totalling query to show the names of the highest grossing films for each year	Hard
Use various string functions to extract the last word from a song title	Hard
Create parameter queries in Access to list out, for example, all of the owners born between any two dates that you enter	Hard
Create a query to calculate the age of each owner, and the difference between this and the age of each pet	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 - ADVANCED QUERIES

MICROSOFT TRAINING

FIND YOUR COURSE

OTHER SERVICES

YOUR TRAINING