Microsoft computer training exercises (page 1 of 32)

Showing exercises 1-20 (out of 625)

Category: Access 2010
Topic: Designing a database
Level: Average difficulty
Courses: Access 2010 QueryingAccess 2010 Developers
Exercise: An exercise to design a video library database, given some basic information on what it should do.

Go to exercise ...

Category: Access 2010
Topic: Designing a database
Level: Average difficulty
Courses: Access 2010 QueryingAccess 2010 Developers
Exercise: Create a recipes database containing 3 tables, including relationships.

Go to exercise ...

Category: Access 2010
Topic: Designing a database
Level: Average difficulty
Courses: Access 2010 QueryingAccess 2010 Developers
Exercise: Create a database to hold your Christmas list ideas, items and categories that you need, as well as 2 relationships.

Go to exercise ...

Category: Access 2010
Topic: Creating tables
Level: Relatively easy
Courses: Access 2010 QueryingAccess 2010 Developers
Exercise: In an Access database design a countries table and import Excel data.

Go to exercise ...

Category: Access 2010
Topic: Creating tables
Level: Average difficulty
Courses: Access 2010 QueryingAccess 2010 Developers
Exercise: In an Access database, design a languages table and import from Excel.

Go to exercise ...

Category: Access 2010
Topic: Creating tables
Level: Average difficulty
Courses: Access 2010 QueryingAccess 2010 Developers
Exercise: Create a table of film directors, using the lookup wizard for the gender.

Go to exercise ...

Category: Access 2010
Topic: Creating tables
Level: Average difficulty
Courses: Access 2010 QueryingAccess 2010 Developers
Exercise: Import table of who played which roles, and set lookup fields.

Go to exercise ...

Category: Access 2010
Topic: Importing data
Level: Relatively easy
Course: Access 2010 Developers
Exercise: Import a list of films into an Access database from Excel, solving any problems during the import.

Go to exercise ...

Category: Access 2010
Topic: Importing data
Level: Average difficulty
Course: Access 2010 Developers
Exercise: Import one Excel worksheet and link to another to bring in currency and country data, solving typical import problems in the process.

Go to exercise ...

Category: Access 2010
Topic: Importing data
Level: Average difficulty
Course: Access 2010 Developers
Exercise: Import and link to Excel worksheets containing songs and Christmas number ones, solving typical import problems along the way.

Go to exercise ...

Category: Access 2010
Topic: Importing data
Level: Harder than average
Course: Access 2010 Developers
Exercise: Import and link to Excel worksheets containing rich people/successful companies, ensuring that your data makes sense before doing so.

Go to exercise ...

Category: Access 2010
Topic: Creating queries
Level: Relatively easy
Courses: Access 2010 QueryingAccess 2010 Developers
Exercise: Create a query sorting films into order by year and title.

Go to exercise ...

Category: Access 2010
Topic: Creating queries
Level: Relatively easy
Courses: Access 2010 QueryingAccess 2010 Developers
Exercise: Create various queries sorting billionaires into different orders.

Go to exercise ...

Category: Access 2010
Topic: Creating queries
Level: Relatively easy
Courses: Access 2010 QueryingAccess 2010 Developers
Exercise: Creating various queries filtering out certain films.

Go to exercise ...

Category: Access 2010
Topic: Creating queries
Level: Average difficulty
Courses: Access 2010 QueryingAccess 2010 Developers
Exercise: Creating queries to filter out certain songs from a table.

Go to exercise ...

Category: Access 2010
Topic: Creating queries
Level: Average difficulty
Courses: Access 2010 QueryingAccess 2010 Developers
Exercise: Creating queries with complex criteria to pick out some companies from the list of the biggest ones in the world.

Go to exercise ...

Category: Access 2010
Topic: Creating queries
Level: Average difficulty
Courses: Access 2010 QueryingAccess 2010 Developers
Exercise: Group a query to show number of roles per actor or film.

Go to exercise ...

Category: Access 2010
Topic: Creating queries
Level: Harder than average
Courses: Access 2010 QueryingAccess 2010 Developers
Exercise: Practise more advanced sorting and filtering using actors table.

Go to exercise ...

Category: Access 2010
Topic: Creating queries
Level: Harder than average
Courses: Access 2010 QueryingAccess 2010 Developers
Exercise: Use Access to select records based on date ranges.

Go to exercise ...

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

Go to exercise ...