Microsoft Access 2021 Beginner to Advanced Course Bundle

Learn how to start Access 2021, explore the start screen, pin and access recent templates, and use templates to build pre-built databases with tables, queries, forms, and reports.

Create and save databases from templates or blank files, and open them from recent lists or browse. Manage the welcome screen, rename files, and customize the application title for clarity.

Customize the quick access toolbar by adding frequently used commands, choosing its placement under or above the ribbons, and organizing tools with separators and reordering for greater efficiency.

Explore the different access menus, ribbons, and contextual menus, including split buttons and contextual ribbons, and learn how to access views, paste options, and hidden dialog boxes in a database.

Access help in access via the help ribbon or F1, explore get started and tables, and use the tell me what you want to do bar with alt q.

Practice creating an inventory database from a template in Access 2021, save it as inventory_database.db, and open, close, then customize quick access toolbar with relationships, form wizard, and table design.

Create a ticket table in a helpdesk database, define fields like ticket number and description, set an id primary key, and use design and datasheet views to structure data.

Learn how to create a drop-down lookup field in Access using the lookup wizard, choosing a value list or a linked table, and configuring display, entry limits, and field behavior.

Add numeric and date fields using a lookup wizard, then apply data validation rules to ensure resolved dates are after opened dates.

Add priority as an integer with indexing, category as a lookup with four values, and a long text description to Access table, and prepare for importing records from Excel.

Learn how to bulk import records from an Excel spreadsheet into Access, ensuring column headings match fields, using the import wizard to append to an existing table, and preview data.

Practice importing records from an Excel file into Access, appending them to the orders table, using the external data wizard, previewing, and verifying by opening the table for imported records.

Explore how to make design changes in datasheet view, including adding fields to the end or in the middle, deleting fields, and adjusting field properties, lookups, and validation rules.

Apply sorting and filtering in Access datasheet view with Excel-like ease, using column filters and text, number, and date options to refine records by priority and open date.

Learn to enter and modify data in datasheet view, resize and arrange columns with drag-and-drop, hide or unhide fields, and add new records using the record selector.

Learn how to link tables in Access using a common field or a dedicated link table, enabling cross-table queries and reports.

Create a link table, table ticket status, to join the ticket and status tables in Access 2021, using fields id, ticket id, and status, with one-to-many relationship and referential integrity.

Create a region dimension and a link table to connect tickets to regions, enforcing referential integrity and one-to-many relationships for faster, indexed queries.

Master lookup wizard fields in Microsoft Access 2021 to populate region and ticket data from related tables, while preserving data integrity and streamlining data entry.

Create table named table customers, add text fields customer name and customer number, set customer name as primary key, import records, and enforce referential integrity with one-to-many relationship to orders.

Use the form wizard to create a user-friendly region maintenance form in Access, select fields, apply a tabular layout, and switch between form view and design view for edits.

Open design view to explore form properties, header, details, and footer; use the property sheet to rename labels and set record source and order by region.

Create a related tickets table and a subform showing tickets linked to a main ticket, using a composite primary key and a one-to-many relationship and enforce referential integrity.

Create and bind a sub form to the main form using the related tickets table, design fields, switch to continuous view, and remove navigation for a cleaner related tickets display.

Adjust tab order in the order form, create table status with order ID as primary key and fields description and status, import from Excel, and build a horizontal continuous subform.

Discover how to create and design queries in access using the query design grid and sql view to select fields, apply criteria, and sort results.

Explore how inner, left, and right joins link tables by matching fields, selecting or excluding records, and controlling which data from left or right tables appears.

Learn to build queries with the Access query wizard, including detail and summary options, and to aggregate numeric data using sum, average, min, max, and count.

Learn to use basic expressions in Microsoft Access 2021 to calculate a due date from date logged and priority within a related tickets subform.

Add a text box and label on the form order maintenance, name them total plus shipping, and create control source that sums total and shipping; verify and format as currency.