WISE OWL EXERCISES
ACCESS EXERCISES
ACCESS EXERCISES
Access exercises on ADVANCED QUERIES
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 |
| Courses: | Access QueryingAccess Developers |
| Exercise: | Use an expression to show the Oscar shortfall for each film. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Relatively easy |
| Courses: | Access QueryingAccess Developers |
| Exercise: | Create a query showing the number of songs each artist has recorded. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Average difficulty |
| Courses: | Access QueryingAccess Developers |
| Exercise: | Create an expression using summing and the LEN function. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Average difficulty |
| Courses: | Access QueryingAccess Developers |
| Exercise: | Create a query to show the average worth per year lived for billionaires. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Average difficulty |
| Courses: | Access QueryingAccess Developers |
| Exercise: | Use the & concatenation symbol to join fields together in Access. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Average difficulty |
| Courses: | Access QueryingAccess Developers |
| Exercise: | Analyse data of billionaires to show the number there are per country and their average age. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Average difficulty |
| Courses: | Access QueryingAccess Developers |
| Exercise: | Create Access queries that prompt the user for criteria. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Average difficulty |
| Courses: | Access QueryingAccess Developers |
| Exercise: | Use the MONTH and YEAR functions and criteria to pick out actors. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Harder than average |
| Courses: | Access QueryingAccess Developers |
| Exercise: | Use various string functions to extract the last word from a song title. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Harder than average |
| Courses: | Access QueryingAccess Developers |
| 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. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Harder than average |
| Courses: | Access QueryingAccess Developers |
| Exercise: | Create a query manipulating string expressions to get dates. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Harder than average |
| Courses: | Access QueryingAccess Developers |
| Exercise: | Use theCLNG and RIGHT functions to extract the last value from a list of years. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Harder than average |
| Courses: | Access QueryingAccess Developers |
| Exercise: | Create a query showing the average sales and profits for a subset of companies. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Harder than average |
| Courses: | Access QueryingAccess Developers |
| 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. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Harder than average |
| Courses: | Access QueryingAccess Developers |
| Exercise: | Create parameter queries in Access to list out, for example, all of the owners born between any two dates that you enter. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Harder than average |
| Courses: | Access QueryingAccess Developers |
| Exercise: | Use a grouping query with formulae to show the most profitable director. |
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