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.

Explore the Access interface and backstage, master ribbons, the file tab, and the left navigation pane, and learn to manage tables, queries, forms, reports, and datasheet, design, and layout views.

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.

Improve efficiency in access by using keyboard shortcuts, including access-specific keys and alt key tips, with screen tips showing shortcuts for quick, mouse-free commands.

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.

Learn to configure access options across general, data sheet, object designers, proofing, language, client settings, display, and trust center to optimize security and usability.

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.

Create and design a tickets table by defining a primary key, adding fields such as title, description, customer name, and location, and applying indexing and a lookup wizard for dropdowns.

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.

Create a blank database named customer orders and a table orders with a primary key; populate from orders.xlsx for three customers; add a payment method lookup and currency shipping charge.

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.

Import a text file into Access using a tab delimiter, with the first row as field names, then preview data and append records to the table.

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.

Practice exercise five by opening table orders, switching between views, using the fields ribbon to adjust properties, and sorting or filtering by customer name Nash.

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

Create a status table for call statuses and designate status as the primary key. Link the ticket table to this status table via a link table to enable status-based queries.

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.

Compare continuous form view with single form view in Access forms, and switch views via the form's property sheet to navigate records, apply filters, and manage data sheet view.

Explore layout view in microsoft access to design a tumble ticket form, rearrange fields on a row, set captions, and lock the id field to prevent edits for new records.

Bind the form to the ticket table, add and arrange fields in design view, and refine tab order, alignment, and headers and footers for a complete form.

Create a form in Access 2021 using the form design button, add all order fields and the customer number, add a title order maintenance, and save in single form view.

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.

practice creating access queries to list order numbers and totals. build another query with customer name, order date, product, and total, sorted by customer name ascending and total descending.

Enforce priority between 1 and 4 with a data validation rule and text. Set a minimum charge of $10 using the expression builder in design view.

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.