Information Technology Career Training

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.

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.

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

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.

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

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.