false
OasisLMS
Login
Catalog
Access 2021 Intermediate
Access 2021 Intermediate - Quick Reference Guide
Access 2021 Intermediate - Quick Reference Guide
Back to course
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
×
Please select your language
1
English