Access 2021 Intermediate-Access 2021 Intermediate

Access 2021 Intermediate - Course Outline

Pdf Summary

This Microsoft Access 2021 Intermediate course builds skills for designing, managing, and maintaining relational databases. It begins with creating relational databases by explaining database types, relationship types, and the rules for linking tables. Students learn how to create table relationships, enforce referential integrity (including required conditions and outcomes), and manage relationships by printing or deleting them.<br /><br />The course then focuses on queries, covering how to create, save, and run queries; hide or remove fields; and sort results. It teaches using AND/OR criteria, building multi-table queries, creating calculated fields, and working with expressions (including the Expression Builder). Learners also format query fields, use IIF functions, summarize groups of records, and filter for top or bottom values. Additional query topics include parameter queries, finding duplicates and unmatched records, crosstab queries, and action queries such as delete, append, make-table, and update queries (with preview and execution steps).<br /><br />Next, students work with forms: creating forms using the Form Wizard and AutoForms, using forms for data entry, and modifying forms in Layout and Design views. Topics include adding/moving/deleting controls, changing tab order, editing control and form properties (including default views), changing control data sources, creating calculated controls and default values, and building subforms. The section also covers navigation forms and setting startup forms.<br /><br />Reporting skills include creating reports with wizards (including labels), editing in Layout view, adjusting layouts and columns, applying font and alignment formatting, inserting logos/backgrounds, setting margins and orientation, adding page numbers and dates, grouping/sorting, adding totals, and understanding report sections.<br /><br />Advanced topics include conditional formatting, number formatting, themes, importing/exporting/linking data, mail merge to Word, hyperlink fields, object dependencies, compact/repair, database conversion, backup/restore, password protection, and splitting databases.

Keywords

Microsoft Access 2021

relational database design

table relationships

referential integrity

query design

calculated fields and expressions

action queries

forms and subforms

report creation and formatting

database maintenance and security