Create a query with the Query Wizard or go straight to the Query Design option.
One of the main functions of a database is to provide the ability to query the data. The ability to create complex queries across multiple tables with various data types is one of the features that distinguishes a database management system from a simple spreadsheet application.
As you might expect, Access makes it easy for beginners to create queries.
Access has a Query Wizard that allows you to choose the type of query you want to run, then walks you through the creation of the query.
Access also allows you to go straight to Query Design view which gives you more control over creating the query.
And for more advanced users, Access provides a SQL View that allows you to construct your queries using SQL code.
But today, we're going to use Query Design to create a query.
First, Ensure Data is in your Tables
How to use Query Design
We will now create a query that queries and returns data from both the Artists and Albums tables.
Now it's unlikely that the user will want to spend all their time searching for Iron Maiden albums.
So what we'll do next, is take a copy of the above query, then modify it so that the user can specify which artist they want to see albums from.