Using the database. In this article, we cover the basic steps of using the Projects desktop database template. Prepare the database for use. To make sure all the database content is enabled, use the following procedure: To make sure all the database content is enabled, in the Message Bar, click Enable this content. Download database examples of Microsoft access templates. Free MS Access template samples for small business company, non profit organization and personal student. Access database is a database built using Microsoft office access software. Microsoft Access Database - Sample Download Page. We provide a custom designed databases examples for you to download and try. Each database is fully functional and most are free to keep and use for as long as you like whilst others can be trailed free for 30 days. Select an Access database sample from the list below for further details.
- Access Sample Databases Free Download
- Free Access Database Examples Download
Install the Northwind sample database to see what a real database might look like in a commercial setting. A great way to learn more about Access databases.
The Northwind database is a sample database, designed to assist in learning and demonstrations, etc. It demonstrates what an inventory/orders system might look like for a mail order dry goods company.
The Northwind sample database is based on a fictitious company called Northwind Traders, which imports and exports specialty foods from around the world.
We'll now install the Northwind sample database.
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: |
| Exercise: | Use the Autoform wizard to create a quick form for entering and viewing pets. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating tables |
| Level: | Relatively easy |
| Courses: |
| Exercise: | In an Access database design a countries table and import Excel data. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating queries |
| Level: | Relatively easy |
| Courses: |
| Exercise: | Creating various queries filtering out certain films. |
| 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. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Relatively easy |
| Courses: |
| Exercise: | Use an expression to show the Oscar shortfall for each film. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Relatively easy |
| Courses: |
| Exercise: | Create a query showing the number of songs each artist has recorded. |
| 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. |
| 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. |
| 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. |
| 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. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating reports |
| Level: | Relatively easy |
| Courses: |
| Exercise: | Use the report wizard in Microsoft Access 2007 to quickly create detailed summary reports based on your data. |
| 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. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating queries |
| Level: | Relatively easy |
| Courses: |
| Exercise: | Create various queries sorting billionaires into different orders. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating queries |
| Level: | Relatively easy |
| Courses: |
| Exercise: | Create a query sorting films into order by year and title. |
| 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. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Designing a database |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Create a database to hold your Christmas list ideas, items and categories that you need, as well as 2 relationships. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Create an expression using summing and the LEN function. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating tables |
| Level: | Average difficulty |
| Courses: |
| Exercise: | In an Access database, design a languages table and import from Excel. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating tables |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Create a table of film directors, using the lookup wizard for the gender. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating reports |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Design a report to list films by film studio. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Designing a database |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Create a recipes database containing 3 tables, including relationships. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating queries |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Creating queries with complex criteria to pick out some companies from the list of the biggest ones in the world. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating queries |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Creating queries to filter out certain songs from a table. |
| 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. |
| 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. |
| 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. |
| 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. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating forms |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Customise and format an Access form. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Designing a database |
| Level: | Average difficulty |
| Courses: |
| Exercise: | An exercise to design a video library database, given some basic information on what it should do. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Create a query to show the average worth per year lived for billionaires. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Use the & concatenation symbol to join fields together in Access. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating forms |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Create and format a form, to include buttons for moving between records and closing the form. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Analyse data of billionaires to show the number there are per country and their average age. |
| 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. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating tables |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Import table of who played which roles, and set lookup fields. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Joins |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Create a query showing the number of countries in one table not in the other, and vice versa. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Joins |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Create 3 queries showing the use of inner and outer joins for tables of currencies and countries. |
| 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. |
| 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. |
| 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. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Create Access queries that prompt the user for criteria. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Joins |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Create ad-hoc joins in a query in a Microsoft Access 2007 database. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating reports |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Create a grouped report based on a query of large financial companies, then apply lots of formatting touches to it. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Use the MONTH and YEAR functions and criteria to pick out actors. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating queries |
| Level: | Average difficulty |
| Courses: |
| Exercise: | Group a query to show number of roles per actor or film. |
| 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. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating forms |
| Level: | Harder than average |
| Courses: |
| Exercise: | Design a record-entry form, including navigational buttons. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating queries |
| Level: | Harder than average |
| Courses: |
| Exercise: | Practise more advanced sorting and filtering using actors table. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Joins |
| Level: | Harder than average |
| Courses: |
| Exercise: | An exercise to find the discrepancies between two tables. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Harder than average |
| Courses: |
| Exercise: | Use various string functions to extract the last word from a song title. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Harder than average |
| Courses: |
| 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. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Harder than average |
| Courses: |
| Exercise: | Create a query manipulating string expressions to get dates. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Harder than average |
| Courses: |
| Exercise: | Use theCLNG and RIGHT functions to extract the last value from a list of years. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating reports |
| Level: | Harder than average |
| Courses: |
| Exercise: | Create a report and change its entire formatting to make it look neater, including using conditional formatting. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Harder than average |
| Courses: |
| Exercise: | Create a query showing the average sales and profits for a subset of companies. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Harder than average |
| Courses: |
| 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. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Harder than average |
| Courses: |
| Exercise: | Create parameter queries in Access to list out, for example, all of the owners born between any two dates that you enter. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Creating queries |
| Level: | Harder than average |
| Courses: |
| Exercise: | Use Access to select records based on date ranges. |
| Software: | Access |
| Version: | Access 2010 and later |
| Topic: | Advanced queries |
| Level: | Harder than average |
| Courses: |
| Exercise: | Use a grouping query with formulae to show the most profitable director. |
| 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. |
Access Sample Databases Free Download
You can search our full list of Access exercises here.
Free Access Database Examples Download
This page has 0 threads Add post