Access 2016 Intermediate

Retrieve and analyze specific data from your tables by building queries in Access

Customize your table layout by hiding, deleting, or sorting fields in Microsoft Access

Filter query results accurately by combining multiple conditions with AND and OR in Access

Combine data from several tables to analyze related information in Microsoft Access

Add formulas to queries or tables by creating calculated fields in Microsoft Access

Simplify formulas and automate calculations using the Expression Builder in Access

Improve data presentation by customizing field formats directly within Access queries

Use the IIF function to apply conditional logic in queries and forms in Access

Group and summarize records to calculate totals and averages in Microsoft Access

Filter query results to show the highest or lowest values in Microsoft Access

Create interactive parameter queries to search and filter data dynamically in Access

Identify and remove duplicate entries to clean and organize your Access database

Locate missing or unmatched records between related tables in Microsoft Access

Summarize and compare data across rows and columns using crosstab queries in Access

Safely remove unwanted records from your database using delete queries in Access

Add records from one table to another efficiently using append queries in Access

Create new tables automatically from query results in Microsoft Access

Edit or modify multiple records at once using update queries in Microsoft Access

Quickly build professional forms with the step-by-step Form Wizard in Access

Simplify data entry and viewing by designing custom forms in Microsoft Access

Easily adjust form design and layout using Access layout view tools

Customize and arrange form elements using design view tools in Microsoft Access

Improve form navigation by changing the tab order of fields in Microsoft Access

Adjust control properties to modify appearance and behavior in Microsoft Access forms

Refine form settings to control layout, formatting, and functionality in Access

Link controls to data fields or queries by changing the control source in Access

Display automatic results by adding calculated controls to Access forms

Simplify data entry by setting default control values in Microsoft Access

Display related data by adding subforms within main forms in Microsoft Access

Edit, manage, and update subforms to display linked data efficiently in Access

Create user-friendly navigation forms to organize and access database objects

Generate detailed reports to organize and present your data in Microsoft Access

Build professional reports automatically with the easy-to-use Report Wizard in Access

Design and print custom mailing labels quickly using the Label Wizard in Access”

Edit and adjust form or report designs instantly using layout view in Access

Enhance readability and design by formatting fonts in your Access forms and reports

Quickly duplicate styles and layouts between forms and reports in Microsoft Access

Adjust text alignment to enhance readability and layout in Microsoft Access

Customize your Access forms and reports by adding professional logos and background images

Change margins and page orientation settings to improve Access report printing

Include page numbers and date stamps in reports for a professional Access layout

Organize and analyze your data efficiently by grouping and sorting records in Access

Calculate sums, averages, and counts to analyze data with totals in Access

Understand and manage report sections to control data layout in Microsoft Access

Highlight important data with conditional formatting rules in Microsoft Access

Customize numeric displays with number formatting options in Microsoft Access

Apply consistent colors and styles across forms and reports with Access themes

Transfer tables and queries from Microsoft Access to Excel for easier data analysis

Export tables, queries, and reports from Access to Excel for easy data analysis

Connect external data sources to your Access database for real-time updates and analysis

Create personalized letters and reports by merging Access data with Word documents

Add clickable hyperlinks to connect your Access database with web pages or files

Track how tables, queries, and reports are connected within your Access database

Improve performance and fix database errors using Compact and Repair in Access

Upgrade or change database formats to ensure compatibility in Microsoft Access

Protect your data by learning how to back up and restore Access databases safely

Secure your data by setting up password protection in Microsoft Access databases

Improve performance and collaboration by splitting your Access database into front and back ends