Access 365 Intermediate

Configure text field size to limit input, using two-character state abbreviations as an example. Use captions to create user-friendly labels and apply text and date formats with case symbols for display.

Export a table to a SharePoint list as a standalone copy in the cloud. Include related data like suppliers and categories, and specify the site URL, list name, and description.

Explore how select queries pull data from multiple tables without changing originals, and how action queries—update, append, delete, and make table—perform targeted changes in Access tables.

Learn to build an update query as an action query by first running a select query to verify 5% price increase for products starting with letter e, then apply changes.

Create an append query to copy records from a source table to a destination table, matching fields and using the primary key to remove duplicates.

Learn to switch a query from select to delete, apply a where criterion, and remove all October leads records to empty the table.

Learn how inner, left outer, and right outer joins determine query results, how left and right tables define joins, and how to use SQL view for inspection and modification.

Apply conditional formatting to a form to automatically highlight values that meet a rule, such as stock under 15, using color, bold, italic, or yellow fill.

Organize a form by using a tab control to split personal and business data from the employee all data table, with clear captions for the two tabs.

Create a combo box in a form, enter manual values for a non-lookup field, and link the chosen salutation to the corresponding table field.

Learn to configure a combo box in a form header to search and filter records by company name, displaying relevant company and contact details.

Insert a modern chart into a report from a sales data query, select a stacked bar chart, and configure the axis, legend, and formatting in the report footer.

Build a multi-column report from the employee list query, grouping by the first letter of the last name and displaying name and extension in columns.

Export your Access reports to share with others by saving as PDF or Word files, using the right-click export or the external data tab, then view easily.

Discover how to migrate access data to the cloud using Dataverse, establish relationships and data validation, and connect with Power Apps, Power BI, and Power Automate via gateways.

Review advanced Access 365 techniques, including table design, field properties, relationships, data sharing, action queries, cross-tab queries, macros, data validation, conditional formatting, form tabs, subforms, and charts with subreports.