Access 2021 Basic-Access 2021 Basic - Quick Reference Guide

Access 2021 Basic - Quick Reference Guide

Pdf Summary

This document is a Microsoft Access 2021 Basic Quick Reference Guide covering the program screen layout, core database concepts, and common tasks with step-by-step actions and keyboard shortcuts.<br /><br />It explains Access basics such as creating a new database (Ctrl+N), opening (Ctrl+O), saving (Ctrl+S), printing (Ctrl+P), closing objects and databases, switching between open object tabs, and getting Help (F1). It also describes using the Navigation Pane to view, open, rename, delete, and manage database objects, and how to switch objects into Design View.<br /><br />The guide summarizes the main database object types: tables (store data in fields and records), queries (ask questions of data), forms (data entry/view screens), reports (print-ready output), and automation tools such as macros and VBA modules. It includes an overview of the Access interface elements (Ribbon, Quick Access Toolbar, Navigation Pane, status bar, view buttons, and record navigation bar).<br /><br />Planning guidance is provided for determining a database’s purpose by identifying required fields, tables, primary keys, and relationships. Instructions are included for creating databases from templates or as a blank database.<br /><br />For working with data in tables/datasheets, it covers adding, selecting, editing, and deleting records; selecting fields or multiple records; copy/paste; and spell check (F7). It explains finding and replacing data, sorting and removing sorts, and filtering (standard filter, selection-based filtering, filter by form, and clearing filters). Formatting and layout tasks include adjusting column widths and row heights, freezing/unfreezing columns, and hiding/unhiding fields.<br /><br />Finally, it outlines table creation and design tasks: creating tables in Datasheet or Design View, inserting/reordering/deleting fields, changing data types, setting a primary key, editing field properties (size, indexing, captions, descriptions), and adding a totals row for calculations.

Keywords

Microsoft Access 2021

Access quick reference guide

database objects tables queries forms reports

Navigation Pane

Ribbon interface

keyboard shortcuts Ctrl+N Ctrl+O Ctrl+S Ctrl+P F1

table design view

primary key and relationships

sorting and filtering data

datasheet editing and formatting