How to Create a Simple Query in Access

TL;DR

To create a simple query in Access, navigate to the Create tab and click on Query Design. Add your desired table, select fields to include, and set filters in the Criteria and 'or' rows to retrieve specific data, such as nearby customers. Finally, run the query to view the results in Datasheet View.

Transcript

One of the most powerful ways of analyzing your data in Access is by creating a Query. Running a query is like asking your database a question. A query can retrieve data from a single table, or from multiple tables, and it all depends on how complex your question is. In this video, we're just going to focus on making a simple query that uses a sing... Read More

Key Insights

• 👻 Creating a query in Access allows you to retrieve specific data from one or more tables in your database.
• 🫵 Design view is used to design the query, and Datasheet view displays the results.
• 🏑 Double-clicking on fields in the table window adds them to the query's Design Grid.
• 🏑 Sorting the results can be done by selecting the desired field and choosing a sort order.
• 🤨 Filtering the records can be achieved by specifying criteria in the Criteria row.
• 🤨 Multiple criteria can be added using the 'or' row for an either/or condition.
• 🫵 Switching between Design view and Datasheet view is done through the View drop-down menu.

Questions & Answers

Q: How do you create a query in Access?

To create a query, go to the Create tab and click on the Query Design command. Select the table(s) you want to retrieve data from, add them, and close the window.

Q: What are the different views when working with queries?

There are two primary views: Design view, where you design the query, and Datasheet view, where you view the results. The View drop-down menu allows you to switch between these views.

Q: How do you include specific fields in a query?

Double-click on each field you want to include in the query in the Customers table window. The fields will appear in the Design Grid area below.

Q: How do you sort the results of a query?

In the sort row, click the cell under the desired field (e.g., Last Name), and choose how you want it to be sorted from the drop-down arrow menu.

Q: How do you filter the records in a query?

Use the Criteria row to specify filtering conditions. For example, to show customers who live in Raleigh, type "Raleigh" in the City column (in quotation marks for an exact match).

Q: Can you apply multiple criteria in a query?

Yes, you can use the 'or' row below the Criteria row to add additional criteria. For example, to also include customers in zip code 27513, type "27513" in the 'or' row under the Zip Code column.

Summary & Key Takeaways

• A query in Access allows you to ask your database a question and retrieve relevant data.

• This video focuses on creating a simple query using a single table, also known as an advanced filter.

• The example used is retrieving a list of nearby customers for an upcoming event using the Customers table.