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
Course:
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
Course:
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
Course:
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:
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
Course:
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
Course:
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:
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:
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:
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:
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
Course:
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:
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
Course:
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
Course:
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:
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
Course:
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
Course:
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
Course:
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
Course:
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
Course:
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
Course:
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
Course:
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
Course:
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:
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:
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:
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:
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
Course:
Exercise: Customise and format an Access form.

Go to exercise ...

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