Access 2021 Intermediate-Access 2021 Intermediate

Access 2021 Intermediate - Quick Reference Guide

Pdf Summary

This document is a Microsoft Access 2021 Intermediate quick reference guide covering queries, relational database concepts, and basic object creation and management.<br /><br />It explains common query criteria and expression examples, such as filtering for exact text matches (e.g., “London”), using OR conditions, date ranges with Between…And, checking for null or not null values, excluding values (Not “USA” Or “”), and pattern matching with Like/Not Like (e.g., “S*”). It also includes examples of aggregate calculations in queries, including Sum, Avg, and Count.<br /><br />The guide outlines core query tasks: creating and saving a query in Query Design, running queries from the Navigation Pane, hiding fields via the Show checkbox, sorting fields in the design grid, building multi-table queries, and using the Expression Builder for calculated fields. It also describes how to create specialized queries with wizards, including Find Unmatched queries and Crosstab queries. Action queries are covered as well, with step-by-step instructions for creating Delete queries (adding tables, selecting Delete, choosing fields and criteria) and Append queries (setting append options and selecting fields to append).<br /><br />In addition, it summarizes relational database fundamentals: differences between flat-file and relational databases, three relationship types (one-to-one, one-to-many, many-to-many), and how to create and print table relationships, optionally enforcing referential integrity.<br /><br />Finally, it provides quick steps for creating and editing forms and reports (AutoForm/Form Wizard, adding fields and controls, using the Property Sheet, creating subforms, Report/Report Wizard/Label Wizard, layout changes, logos, margins, and orientation) plus advanced tasks such as importing/exporting data, saving to other formats, conditional formatting, compact/repair, password encryption, and backup/restore.

Keywords

Microsoft Access 2021

query design

query criteria expressions

aggregate functions (Sum Avg Count)

crosstab queries

find unmatched query wizard

action queries (append delete)

relational database relationships

referential integrity

forms and reports creation