Access Queries Conclusion

Module 3 Summary: Creating and Refining Queries in Microsoft Access 365

Lesson-by-Lesson Overview

Lesson 1 – Introduction to Creating Access Queries

The module opened with an overview of how queries fit into an Access application. You saw how queries act as the “question engine” of your database—pulling selected rows and columns instead of browsing entire tables. You also learned that queries can serve as record sources for forms and reports, making them central to both data analysis and user interface design.

Lesson 2 – What Queries Are and How They Work

You explored key query concepts, including:

• Dynasets – result sets returned by a query, based on the current data in underlying tables.
• Query definition – the design (fields, criteria, sort order, expressions) that tells Access what to retrieve.
• Different query types such as select queries, action queries, and crosstab queries at a conceptual level.

Lesson 3 – Working with Queries in the Database Window / Navigation Pane

You learned how to find, open, rename, and manage queries in the Access Navigation Pane. This included:

• Opening queries in Datasheet View to see results.
• Switching to Design View to change fields, criteria, or sort order.
• Understanding how queries, tables, forms, and reports relate as objects in an Access 365 database.

Lesson 4 – Creating Queries with the Simple Query Wizard

The Simple Query Wizard gave you a guided way to build select queries:

• Choosing fields from one or more related tables or queries.
• Selecting a detail query (every record) or a summary query that groups data and performs aggregate calculations.
• Using summary options such as Sum, Avg, Min, Max, and Count for numeric fields.

For many summarization tasks, the Simple Query Wizard remains a fast way to group data and calculate totals without writing SQL or building expressions manually.

Lesson 5 – Using Query Design View

You were introduced to Query Design View, where you can:

• Add one or more tables (or queries) to the upper pane.
• Drag fields into the design grid to control which columns appear in the result.
• Use the Criteria, Sort, and Show rows to control filtering and presentation.

Design View is the primary workspace for building and refining queries in Access 365.

Lesson 6 – Creating a Query in Design View

You then walked through the process of building a query entirely in Design View:

1. Add the required tables to the design window.
2. Verify relationships (join lines) so that records combine correctly across tables.
3. Add the fields you want to see to the design grid.
4. Run the query in Datasheet View to confirm the results.

This lesson reinforced that you can always return to Design View to adjust the query as your needs change.

Lesson 7 – Saving a Query Design

You learned how Access encourages you to save changes to queries:

• When closing a new or modified query, Access prompts you to save the design.
• Using Save or Save As lets you preserve different versions—for example, using one query as a template for another.

Good naming conventions and deliberate use of Save As make it easier to maintain a clear library of queries in larger databases.

Lesson 8 – Editing a Query Design

You reviewed how to make iterative improvements to a query:

• Add or remove tables using the Show Table dialog.
• Move, add, or delete fields in the design grid.
• Adjust column widths and the layout of the design grid for readability.

You also revisited the query datasheet, understanding that edits made in the datasheet affect the underlying tables, not just the query output.

Lesson 9 – Adding Criteria to Queries

This lesson introduced using the Criteria row to limit which records appear. You learned how to:

• Type simple values (such as a company name) directly into the Criteria row.
• Use comparison operators (such as >, <, and BETWEEN) to build numeric and date filters.
• Combine multiple criteria across fields to focus on a specific subset of your data.

Lesson 10 – Using Values in Criteria Expressions

You learned how Access interprets values in criteria expressions using special characters:

• Text values in double quotes, e.g., "Network Consultants, Inc."
• Date/time values inside #, e.g., #1/1/2025#
• Field names in square brackets, e.g., [Company] or [DateOfSale]

This lesson emphasized writing criteria so that Access can correctly distinguish between text, numbers, dates, and field references.

Lesson 11 – Using Multiple Criteria

You expanded your criteria skills by using logical operators:

• AND – all conditions in the same row must be true.
• OR – criteria on separate rows represent alternatives; any row that matches is returned.
• NOT – invert a condition to exclude certain values.

By placing criteria in the correct rows (Criteria vs. Or rows), you can model complex real-world filters such as “this client OR that client, but only for dates before a certain deadline.”

Lesson 12 – Refining Queries with Sort Order

Next, you refined query output with the Sort row:

• Apply Ascending or Descending sort orders directly in the query design.
• Define multi-level sorting by setting sort order on multiple fields, understanding that Access evaluates sort keys from left to right in the design grid.
• Use sort definitions in queries that act as record sources for forms and reports, ensuring consistent ordering across your application.

Lesson 13 – Creating Calculated Fields

Finally, you learned how to add calculated fields to a query:

• Define a new field using the pattern FieldName: expression, for example:

  Commission: [Price] * 0.10

• Use built-in functions, arithmetic, and text concatenation to create derived values.
• Leverage tools like the Zoom Box (Shift+F2) and Expression Builder to work with longer expressions.

You also saw when query-level calculations are preferred versus table-level calculated fields, and how each approach affects performance and normalization.

Key Terms and Concepts from Module 3