Microsoft Access 2010 training exercises | Advanced queries

Showing exercises 1-16 (out of 16)

Category: Access 2010
Topic: Advanced queries
Level: Relatively easy
Courses: Access QueryingAccess Developers
Exercise: Use an expression to show the Oscar shortfall for each film.

Go to exercise ...

Category: Access 2010
Topic: Advanced queries
Level: Relatively easy
Courses: Access QueryingAccess Developers
Exercise: Create a query showing the number of songs each artist has recorded.

Go to exercise ...

Category: Access 2010
Topic: Advanced queries
Level: Average difficulty
Courses: Access QueryingAccess Developers
Exercise: Create an expression using summing and the LEN function.

Go to exercise ...

Category: Access 2010
Topic: Advanced queries
Level: Average difficulty
Courses: Access QueryingAccess Developers
Exercise: Create a query to show the average worth per year lived for billionaires.

Go to exercise ...

Category: Access 2010
Topic: Advanced queries
Level: Average difficulty
Courses: Access QueryingAccess Developers
Exercise: Use the & concatenation symbol to join fields together in Access.

Go to exercise ...

Category: Access 2010
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.

Go to exercise ...

Category: Access 2010
Topic: Advanced queries
Level: Average difficulty
Courses: Access QueryingAccess Developers
Exercise: Create Access queries that prompt the user for criteria.

Go to exercise ...

Category: Access 2010
Topic: Advanced queries
Level: Average difficulty
Courses: Access QueryingAccess Developers
Exercise: Use the MONTH and YEAR functions and criteria to pick out actors.

Go to exercise ...

Category: Access 2010
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.

Go to exercise ...

Category: Access 2010
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.

Go to exercise ...

Category: Access 2010
Topic: Advanced queries
Level: Harder than average
Courses: Access QueryingAccess Developers
Exercise: Create a query manipulating string expressions to get dates.

Go to exercise ...

Category: Access 2010
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.

Go to exercise ...

Category: Access 2010
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.

Go to exercise ...

Category: Access 2010
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.

Go to exercise ...

Category: Access 2010
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.

Go to exercise ...

Category: Access 2010
Topic: Advanced queries
Level: Harder than average
Courses: Access QueryingAccess Developers
Exercise: Use a grouping query with formulae to show the most profitable director.

Go to exercise ...

This page has 0 threads Add post