Microsoft Access 2021 for Beginners: Master the Essentials

Explore the Access 2021 interface and use templates to create new databases, pin recent items, and customize the start and welcome screens for efficient work.

Create, save, and open Access databases from a template, rename files, and set an application title; disable the welcome screen and manage objects in the left pane.

Explore the access interface, ribbons, the file backstage, and the quick access toolbar, and navigate the left pane to manage tables, forms, queries, and views.

Customize the Quick Access Toolbar in Access by adding frequently used commands, choosing its placement under or above the ribbons, and organizing items with separators for efficiency.

Explore the different menu types in Access, including ribbon commands, split buttons and contextual menus, and learn how contextual ribbons appear as you work with tables and forms.

Boost efficiency in access by using keyboard shortcuts, learn alt-key navigation, and master common commands like save, paste, and spell check, and explore screen tips that show shortcuts.

Explore how to access help in Access via the help menu, F1, and the tell me what you want to do bar, including the Alt Q shortcut.

Explore access options to tailor your Access 2021 environment, including default database folder, navigation pane, ribbon customization, and trust center security.

Create an inventory database from a template, save as inventory_database.db, and practice opening and closing it. Customize the quick access toolbar by adding relationships, form wizard, and table design commands.

Create a ticket table for an IT helpdesk, define fields like ticket number (integer) and ID as primary key, and use design view to set required and indexed properties.

Design a ticket table in Access 2021 by setting a primary key, adding records, and fields like title, description, and customer name, with indexing and a lookup for location.

Master creating a location lookup field in Access with the lookup wizard, choosing a value list or linked table, and configuring the combo box dropdown.

Add numeric and date fields using a lookup wizard, then implement data validation rules in Access 2021 to ensure the resolved date is after the opened date.

Add final three fields: priority as an integer, category via a lookup, and description as long text. Index the priority, review field properties, and prepare to import records from Excel.

Create a blank Access database named customer orders and build table orders with order id, order date, customer name, quantity, price per unit, total, and shipping charge; set primary key.

Import data from Excel into Access in bulk using the import wizard; ensure Excel column headings match Access fields and append to an existing table.

Learn to import data from a text file into Access 2021, using tab-delimited fields, configure the import wizard, and preview and arrange records in the Ticket table.

Practice importing order data from an Excel file into Access by appending to the orders table, previewing results in the wizard, and verifying records in the table.

Navigate datasheet view design changes in Access, using the table fields tab to add, delete, and rename fields, and adjust properties, lookups, and validation rules.

Master filtering and sorting in Access datasheet view using column filters and sort options. Filter by priority, text, numbers, and dates, toggle or clear filters, and sort ascending or descending.

Enter and modify data in datasheet view in microsoft access 2021 for beginners by resizing, hiding, and reordering columns, and editing records—without changing the underlying data structure.

Practice exercise five by switching between design and datasheet views in table orders, adjust fields with the fields ribbon, sort by customer name, filter for Nash, and clear the filter.

Learn how to build relationships in Microsoft Access by linking tables with a common field or a link table, enabling integrated customer and address data for queries and reports.

Set up relationships by creating a status table and a link table to connect the ticket (fact) table with the status (dimension) table for status-based queries.

Create a link table to connect ticket and status data in Microsoft Access 2021, establishing one-to-many relationships and enforcing referential integrity between ticket, status, and the link table.

Create a region table to hold continent data and a link table to connect tickets to regions, forming a one-to-many relationship; enforce referential integrity and indexing to improve search speed.

Learn to set up lookup fields in linked access tables, convert region and ticket ID to lookup wizard, and recreate relationships while using related data to populate and preview records.

Create a new table customers with customer name as primary key and a customer number field, import records from customer list.xlsx, and enforce a one-to-many relationship with orders.

Create a region form with the form wizard and tabular layout to manage the region table, then open in form view to add records and review regions.

Design view to customize a form in Access using the form design, arrange, and format ribbons; adjust header, details, and footer; bind to region table and set an order by.

Explore single form view versus continuous form view in Microsoft Access 2021, and switch via the form’s property sheet. Navigate records, search, filter, and toggle data sheet view.

Explore layout view to refine the form design, create a tabular layout from tbl typekit, and learn how to lock fields like id to prevent edits.

Design and customize Access forms using form design, bind to a table, add fields, set tab order, align controls, and add headers or footers for a robust ticket maintenance form.

Create a form using the form design tool, including all fields from orders and the customer number from customers. Title the form order maintenance and ensure single form view.

Create a subform to display related tickets, build a related tickets table with a composite primary key, then import data and enforce a one-to-many relationship with referential integrity.

Create and configure a sub form within the main form by binding to the related tickets table, selecting fields, and applying continuous forms for listing multiple records.

Adjust tab order, create a table status (order ID as primary key, description, status), import records from excel, link to orders, and build a subform on the order maintenance form.

Create and run queries in Microsoft Access 2021 using query design and SQL view, add tables, select fields, and apply criteria, then save and sort results.

Master inner, left, and right joins in Access by linking tables and selecting records based on joined fields, understanding how each join type affects results.

Build queries with the query wizard, selecting fields from multiple tables and choosing detail or summary type while applying aggregation like sum, average, min, max, and count to currency charges.

Create and run two access queries: one lists order numbers and totals; the other lists customer name, order date, product, and total with sorting by name ascending and total descending.

Add data validation rules for the priority field between 1 and 4 and enforce a minimum charge of $10 using the expression builder.

Create due date calculations in a form by using an expression that adds the priority days to the date logged, displayed in a related tickets subform.

Complete exercise ten by adding a total plus shipping text box in form order maintenance, and set its control source with an expression that sums total and shipping.