Information Technology Career Training

Learn how to design and create tables and databases, sort and filter data and create input masks, validation rules, queries, forms and reports in the newest version of Microsoft Access.

At the second level, consider how to maintain data consistency, customize database components and share Access data with other applications.

In the third level, you will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.

Data is everywhere. We encounter data at the grocery store, office, laboratory, classroom or ballpark. Whether for work or personal use, most people need to manage data. Access 2016 helps manage your data more efficiently.

Experience using Microsoft Access 2016 for basic database management skills such as creating tables, designing forms and reports, and building queries. Expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust and functional database for your users.

In this version of MS Excel, you will learn to create and navigate workbooks, move and copy data, format various workbook elements and use simple formulas and functions.

Learn to calculate data with advanced formulas, organize worksheet and table data, present data using charts, analyze data using pivot tables and customize/enhance workbooks.

Gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

The breadth of business, educational and organizational information today is absolutely staggering. Organizations, the world over, rely on this information to make sound decisions regarding all affairs. The ability to make sense of all that data is becoming more and more challenging. Who has the time? Excel 2016 can help you organize data more effectively for better analysis.

Build upon the foundational knowledge presented in the Excel 2016-I course to create advanced workbooks that will deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization.

Transform your presentations into powerful means of communication. Use the new and enhanced features to create dynamic and visually appealing presentations.

Topics covered in this version of MS Word include inserting symbols and characters, text alignment, headers, footers, borders, bullets and numbered lists.

Build proficiency in this application by learning how to manage lists, customize tables and charts, perform mail merges and create customized graphic elements.

Create professional-looking documents with Word 2016. Its rich features and powerful tools can make your work easy and even fun. Learn how to create, edit, format and proof documents. Also add tables, lists, design elements and layout options.

Word 2016-II can be used to create documents that are as complex as desktop publishing applications. You can control how the text flows between paragraphs and pages. Link a story from one page to the rest of the story, later in the document. Add graphics and specify how the text should appear with the graphics.