Free Access exercises

This page lists 66 Access exercises. You can use the menu on the left to show just exercises for a specific topic.

This page lists 66 Access exercises. You can use the menu above to show just exercises for a specific topic.

Software: Access
Version: Access 2010 and later
Topic: Creating forms
Level: Relatively easy
Courses: Access QueryingAccess Developers
Exercise: Use the Autoform wizard to create a quick form for entering and viewing pets.

Go to exercise ...

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

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Creating queries
Level: Relatively easy
Courses: Access QueryingAccess Developers
Exercise: Creating various queries filtering out certain films.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Action queries
Level: Relatively easy
Course: Access Developers
Exercise: Use Make Table queries in a Microsoft Access 2007 database to separate a large table of data into several smaller ones.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Creating subforms
Level: Relatively easy
Course: Access Developers
Exercise: Use forms and subforms to represent the one-to-many relationships in a Microsoft Access 2007 database.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Action queries
Level: Relatively easy
Course: Access Developers
Exercise: Delete records from a Microsoft Access 2007 database using Delete queries.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Action queries
Level: Relatively easy
Course: Access Developers
Exercise: Use MakeTable queries in Microsoft Access 2007 to create a backup of important data, and to quickly make copies of specific records.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Creating reports
Level: Relatively easy
Courses: Access QueryingAccess Developers
Exercise: Use the report wizard in Microsoft Access 2007 to quickly create detailed summary reports based on your data.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Action queries
Level: Relatively easy
Course: Access Developers
Exercise: Use Update queries in a Microsoft Access 2007 database to change many records at the same time.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Importing data
Level: Average difficulty
Course: Access 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 ...

Software: Access
Version: Access 2010 and later
Topic: Designing a database
Level: Average difficulty
Courses: Access QueryingAccess 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 ...

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.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Creating reports
Level: Average difficulty
Courses: Access QueryingAccess Developers
Exercise: Design a report to list films by film studio.

Go to exercise ...

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

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Creating queries
Level: Average difficulty
Courses: Access QueryingAccess 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 ...

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

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Crosstab queries
Level: Average difficulty
Course: Access Developers
Exercise: Analyse groups of data using crosstab queries in a Microsoft Access 2007 database.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Crosstab queries
Level: Average difficulty
Course: Access Developers
Exercise: Use crosstab queries in a Microsoft Access 2007 database to create simple statistics based on groups within your data.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Crosstab queries
Level: Average difficulty
Course: Access Developers
Exercise: Use crosstab queries in a Microsoft Access 2007 database to analyse groups of data.

Go to exercise ...

Software: Access
Version: Access 2010 and later
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 ...

Software: Access
Version: Access 2010 and later
Topic: Creating forms
Level: Average difficulty
Courses: Access QueryingAccess Developers
Exercise: Customise and format an Access form.

Go to exercise ...

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

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Creating forms
Level: Average difficulty
Courses: Access QueryingAccess Developers
Exercise: Create and format a form, to include buttons for moving between records and closing the form.

Go to exercise ...

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.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Software: Access
Version: Access 2010 and later
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 ...

Software: Access
Version: Access 2010 and later
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 ...

Software: Access
Version: Access 2010 and later
Topic: Creating subforms
Level: Average difficulty
Course: Access Developers
Exercise: Create forms based on the one-to-many relationships in your Microsoft Access 2007 database.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Uses of VBA
Level: Average difficulty
Course: Access Developers
Exercise: Use simple VBA macros to control user input in a Microsoft Access 2007 database.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Uses of VBA
Level: Average difficulty
Course: Access Developers
Exercise: Use VBA in a Microsoft Access 2007 database to create a criteria form system.

Go to exercise ...

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.

Go to exercise ...

Software: Access
Version: Access 2010 and later
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 ...

Software: Access
Version: Access 2010 and later
Topic: Uses of VBA
Level: Average difficulty
Course: Access Developers
Exercise: Use VBA to create a menu system for a Microsoft Access 2007 database.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Action queries
Level: Average difficulty
Course: Access Developers
Exercise: Use Append queries in a Microsoft Access 2007 database to add large numbers of pet records to an existing table.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Creating subforms
Level: Average difficulty
Course: Access Developers
Exercise: Create subforms based on the one-to-many relationships in a Microsoft Access 2007 database.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Action queries
Level: Average difficulty
Course: Access Developers
Exercise: Use Update queries in a Microsoft Access 2007 database to alter a large number of records in one go.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Uses of VBA
Level: Average difficulty
Course: Access Developers
Exercise: Create criteria forms in a Microsoft Access 2007 database using VBA to control the system.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Uses of VBA
Level: Average difficulty
Course: Access Developers
Exercise: Use simple VBA programs to add functionality to the forms in a Microsoft Access 2007 database.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Creating reports
Level: Average difficulty
Courses: Access QueryingAccess Developers
Exercise: Create a grouped report based on a query of large financial companies, then apply lots of formatting touches to it.

Go to exercise ...

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.

Go to exercise ...

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

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Importing data
Level: Harder than average
Course: Access 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 ...

Software: Access
Version: Access 2010 and later
Topic: Creating forms
Level: Harder than average
Courses: Access QueryingAccess Developers
Exercise: Design a record-entry form, including navigational buttons.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Creating reports
Level: Harder than average
Courses: Access QueryingAccess Developers
Exercise: Create a report and change its entire formatting to make it look neater, including using conditional formatting.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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

Go to exercise ...

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.

Go to exercise ...

Software: Access
Version: Access 2010 and later
Topic: Action queries
Level: Harder than average
Course: Access Developers
Exercise: Use append queries on wealth database to add records to an existing table.

Go to exercise ...

You can search our full list of Access exercises here. Or why not learn to do them the right way on one of our classroom Access training courses in the UK, or on one of our live online Access courses wherever you are in the world?

This page has 0 threads Add post