Access 2021 Basic-Access 2021 Basic

Access 2021 Basic - Course Outline

Pdf Summary

This course teaches the fundamentals of Microsoft Access 2021, guiding learners through creating and working with databases, records, tables, queries, forms, and reports. It begins with an orientation to the Access interface, including understanding the Access screen, using the Navigation Pane, switching object tabs, and managing database objects (opening, closing, renaming, deleting, and editing in Design View). Learners also take guided tours of core object types—tables, queries, forms, and reports—and practice basic tasks such as navigating forms, adding records, and viewing reports in Layout View. The course also covers how to access help using the Tell Me field and the Help Pane, and how to properly close databases and exit Access.<br /><br />Next, the course focuses on planning and building databases. Participants learn to determine a database’s purpose, create databases from templates or as blank files, and perform essential record operations such as adding, editing, and deleting data. It includes foundational productivity skills: selecting data, cutting/copying/pasting, undoing and redoing actions, checking spelling, using the Zoom box, and previewing and printing database objects.<br /><br />Learners then work with data more effectively by finding and replacing values, sorting records, and applying filters (common filters, filter by selection, filter by form, and advanced filters). Additional formatting and viewing tools are included, such as adjusting and rearranging columns, changing gridlines and cell effects, freezing and hiding columns, and restoring views.<br /><br />Finally, the course provides in-depth instruction on table design. Students learn to create tables in multiple ways, understand field data types and properties, index fields, set primary keys and auto-increment fields, and manage fields (insert, reorder, delete). It also covers enhancing data quality through descriptions and captions, field sizing, formatting numeric/date/text fields, default values, required fields, validation rules, input masks, lookup fields, value lists, and adding total rows.

Keywords

Microsoft Access 2021

database fundamentals

tables and table design

queries

forms

reports

record management

sorting and filtering

field data types and properties

data validation and input masks