EXERCISE TOPIC▼
- Access exercises (91)
- C# exercises (79)
- Excel exercises (278)
- Power Apps exercises (13)
- Power Automate exercises (18)
- Power BI exercises (139)
- Python exercises (28)
- Report Builder exercises (141)
- SQL exercises (198)
- SSAS exercises (51)
- SSIS exercises (46)
- SSRS exercises (99)
- VBA exercises (85)
- Visual Basic exercises (46)
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