Free Access exercises

This page lists 66 Access exercises. You can use the menu 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.

This page has 0 threads Add post