Summer 2026

Do you have trouble organizing digital photos, documents, and downloads on your computer? Learn to use file management in the Windows environment. The topics include creating and working with folders, finding files, cut, copy, paste, and more.

Design a working database, queries, forms, and reports. This hands-on session provides the review and practical application needed to pull the courses in the Database Analyst Certificate Program together and fine-tune your new database management skills. You must successfully complete in order to receive the Database Analyst Certificate. Prerequisites: Access (Introduction, Intermediate and Advanced), Database Design, SQL (Introduction), Crystal Reports (Introduction), and SQL Server Database Services.

In this course, you will work with multiple worksheets, use LOOKUP functions and formula auditing, share and protect workbooks, automate workbook functionality with data validation and macros, create spark lines, and map data, and work with data tables, scenarios, goal seek, and forecasting data trends. Microsoft Excel is required for online classes.

In this course, you will work with multiple worksheets, use LOOKUP functions and formula auditing, share and protect workbooks, automate workbook functionality with data validation and macros, create spark lines, and map data, and work with data tables, scenarios, goal seek, and forecasting data trends. Microsoft Excel is required for online classes.

In this course, you will work with multiple worksheets, use LOOKUP functions and formula auditing, share and protect workbooks, automate workbook functionality with data validation and macros, create spark lines, and map data, and work with data tables, scenarios, goal seek, and forecasting data trends. Microsoft Excel is required for online classes.

In this course, you will work with multiple worksheets, use LOOKUP functions and formula auditing, share and protect workbooks, automate workbook functionality with data validation and macros, create spark lines, and map data, and work with data tables, scenarios, goal seek, and forecasting data trends. Microsoft Excel is required for online classes.

Learn more advanced form design with sub-forms, tab pages, and navigation forms. Import, export, and link external data and perform a Word mail merge with Access data. Learn how to have a more turnkey database with macros, VBA programming, and switchboards. Learn about database management topics like dependencies, documenting, compacting, repairing, splitting, security, and converting into ACCDE.

Enhance your proficiency with Word using tables, styles, templates, section breaks, and columns. Long document features such as table of contents, indexes, and mail merge are also covered in this course.

Enhance your proficiency with Word using tables, styles, templates, section breaks, and columns. Long document features such as table of contents, indexes, and mail merge are also covered in this course.

Learn about database normalization, relationships, referential integrity, and analyzing tables. Explore complex queries with joins, parameters, calculated fields, and summarizing and grouping values. Work with action queries and finding unmatched or duplicate records. Learn to create advanced reports with calculated fields and enhanced control formatting and data bars.