Access: Create simple queries - how it works

Simple queries can be created quickly in Access. We'll show you how it works. You can find illustrated instructions in the gallery.

Access: create queries

1. Open your database.
2. Via the menu bar you can reach the point "Create". Open a new query design.
3. A new tab and a window appear. In this window you can select the tablets from which you want to display data.
4. Select them with a double click and then close the window. You can add new tables to the query at any time by clicking on "Show tables" in the "Query Tools".
5. All tables with their row names can now be seen in your query. Double-click on the line names to add them to the output.
6. In the lower area you will find the structure of your query with all output lines and tables.
7. Finally, run the query using the "Execute" button.

In another practical tip, we will show you how to export Access queries as a CSV file.

Latest videos

Our test database

Create the new query.

Select your desired tables.

Compile your query and click "Execute".