Microsoft Access 2019/365: Beginner To Advanced

Learn how to create a select query in Microsoft Access 2019/365 using query design, choosing the table and fields to view. Explore simple, crosstab, find duplicates, and unmatched queries.

Learn to filter records in Access by numeric and date fields, using operators such as greater than and between, hash-delimited dates, and save and sort queries.

Create a new Access query on the address table to filter Seattle records using text fields and wildcards. Apply criteria with like, between, and greater than, and save the query.

Learn how to add calculated fields in Access queries to compute profit (list price minus standard cost), filter by criteria, and extract data with year and left functions, within queries.

Create and save action queries in Access to update or delete data from a safe select query, then convert to update or delete and run with safeguards.

Create dynamic parameter queries using square brackets to prompt for inputs like town or year, enabling one query to filter by town, year, or date range.

Explore why relational databases use multiple linked tables instead of one table, modeling customers, sales, products, and reference data to reduce repeating values.

Create and manage relationships among five tables (titles, regions, customers, sales, products) using the relationships window, enforcing referential integrity, enabling cascade update/delete, and saving the layout for future edits.

Learn to build queries across multiple tables in Access, using inner and outer joins, and join queries to tables to see customers, products, and sales data.

Create a form using the wizard to quickly build data entry forms from tables, then refine in design view, adding combo boxes with row source from the query builder.

Create and customize forms in Microsoft Access 2019/365 without the wizard by attaching data, arranging fields, adding combo boxes, and using concatenation and uppercase functions.

Add a clever combo box using the wizard to locate foreign customer records by selecting a value, display concatenated first name, surname, and post code, and hide the id.

Create and refine subforms within a main form in Access, linking Efrem customers and Efrem sales through table relationships and adjusting layout to display related records.

Create a total sales per customer query using group by and sum, then build a continuous, tabular form from that query and embed it as a subform in main form.

Learn to create and customize a split form in Microsoft Access (Create > More forms > Split form), displaying a top form and bottom table with synchronized record navigation.

Create quick reports with the Access wizard by selecting a customers table, choosing fields, applying grouping and sorting, and previewing the layout to finalize the design.

Create a report from scratch in access using a query of customers in region, selecting key fields, then set up layout, add labels, special fields, and preview, save as rpg.

Group and sort by region in Access reports to display customers in regional blocks, add region name headers, and use footers to count totals, then preview the layout.

Export Access data to Excel to analyze and share, using tables or queries, with format options, saved export steps, and optional email delivery, noting a 65,536-row limit.

Export a report from Access to PDF or Word to preserve layout for emailing or historical records, noting Excel is for data manipulation, not forms or reports.

Import from Excel into Access by creating a new table, linking to the Excel source for updates, or appending to an existing table, with primary key guidance.

Learn to use paste append in Access to import data from Excel by matching columns, inserting a blank column for the self-generated ID, and pasting rows accurately.

Import tables and other objects (queries, forms, reports, macros, and VBA modules) from another access database via external data source to create a copy, or link for live cross-database sharing.

Learn to perform a mail merge by using data from Access in Word, insert merge fields, preview results, and generate personalized letters for all customers.

Connect a Word mail merge document to an Excel data source to generate product labels, mapping fields, formatting prices, and previewing results before finishing the merge and printing.