This page lists the
16 exercises about Advanced queries in Access on our website:
| Software: |
Access |
| Version: |
Access 2010 and later |
| Topic: |
Advanced queries |
| Level: |
Relatively easy |
|
Course:
|
|
| Exercise: |
Create a query showing the number of songs each artist has recorded. |
Go to exercise ...
| Software: |
Access |
| Version: |
Access 2010 and later |
| Topic: |
Advanced queries |
| Level: |
Average difficulty |
|
Course:
|
|
| Exercise: |
Create a query to show the average worth per year lived for billionaires. |
Go to exercise ...
| Software: |
Access |
| Version: |
Access 2010 and later |
| Topic: |
Advanced queries |
| Level: |
Average difficulty |
|
Course:
|
|
| Exercise: |
Use the & concatenation symbol to join fields together in Access. |
Go to exercise ...
| Software: |
Access |
| Version: |
Access 2010 and later |
| Topic: |
Advanced queries |
| Level: |
Average difficulty |
|
Course:
|
|
| Exercise: |
Analyse data of billionaires to show the number there are per country and their average age. |
Go to exercise ...
| Software: |
Access |
| Version: |
Access 2010 and later |
| Topic: |
Advanced queries |
| Level: |
Average difficulty |
|
Course:
|
|
| Exercise: |
Use the MONTH and YEAR functions and criteria to pick out actors. |
Go to exercise ...
| Software: |
Access |
| Version: |
Access 2010 and later |
| Topic: |
Advanced queries |
| Level: |
Harder than average |
|
Course:
|
|
| Exercise: |
Use various string functions to extract the last word from a song title. |
Go to exercise ...
| Software: |
Access |
| Version: |
Access 2010 and later |
| Topic: |
Advanced queries |
| Level: |
Harder than average |
|
Course:
|
|
| 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. |
Go to exercise ...
| Software: |
Access |
| Version: |
Access 2010 and later |
| Topic: |
Advanced queries |
| Level: |
Harder than average |
|
Course:
|
|
| Exercise: |
Use theCLNG and RIGHT functions to extract the last value from a list of years. |
Go to exercise ...
| Software: |
Access |
| Version: |
Access 2010 and later |
| Topic: |
Advanced queries |
| Level: |
Harder than average |
|
Course:
|
|
| Exercise: |
Create a query showing the average sales and profits for a subset of companies. |
Go to exercise ...
| Software: |
Access |
| Version: |
Access 2010 and later |
| Topic: |
Advanced queries |
| Level: |
Harder than average |
|
Course:
|
|
| 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. |
Go to exercise ...
| Software: |
Access |
| Version: |
Access 2010 and later |
| Topic: |
Advanced queries |
| Level: |
Harder than average |
|
Course:
|
|
| Exercise: |
Create parameter queries in Access to list out, for example, all of the owners born between any two dates that you enter. |
Go to exercise ...
| Software: |
Access |
| Version: |
Access 2010 and later |
| Topic: |
Advanced queries |
| Level: |
Harder than average |
|
Course:
|
|
| Exercise: |
Use a grouping query with formulae to show the most profitable director. |
Go to exercise ...
You can search our full list of Access exercises here, or why not have a look at our
other Access training resources?
This page has 0 threads
Add post
