Microsoft computer training exercises (page 2 of 42)

Showing exercises 21-40 (out of 827)

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: 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 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: 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: 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: 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 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: 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: 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 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 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: 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 ...

Category: Access 2010
Topic: Joins
Level: Average difficulty
Courses: Access QueryingAccess Developers
Exercise: Create 3 queries showing the use of inner and outer joins for tables of currencies and countries.

Go to exercise ...

Category: Access 2010
Topic: Joins
Level: Average difficulty
Courses: Access QueryingAccess Developers
Exercise: Create a query showing the number of countries in one table not in the other, and vice versa.

Go to exercise ...

Category: Access 2010
Topic: Joins
Level: Average difficulty
Courses: Access QueryingAccess Developers
Exercise: Create ad-hoc joins in a query in a Microsoft Access 2007 database.

Go to exercise ...

Category: Access 2010
Topic: Joins
Level: Harder than average
Courses: Access QueryingAccess Developers
Exercise: An exercise to find the discrepancies between two tables.

Go to exercise ...

Category: Access 2010
Topic: Crosstab queries
Level: Average difficulty
Course: Access Developers
Exercise: Use crosstab queries in a Microsoft Access 2007 database to analyse groups within your data.

Go to exercise ...

This page has 0 threads Add post