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