Microsoft Access

Microsoft Office Access is a database app that can help organize, collect and manage large amounts of data. Database items like tables, forms and reports, and queries are added and constructed to manage, join, filter and sort data.

Access Level 1

Introduction  (2-day training   $300)

In this course, you will learn how to use Microsoft Access to create and manage a new database.  Topics include creating tables, forms and reports,  and queries.

Access Level 2

Intermediate (2-day training   $300)

This course builds on basic Microsoft Access knowledge learned from Level 1.  This course will delve deeper into managing database design and table relationships and other advanced features in tables, queries, forms, and reports.

Access Level 3

Advanced Topics (1-day training   $300)

Learn advanced Access features such as macros, advanced form design, encrypting a database, preparing a database for multi-user access, and more. This course is the third level of a three-course series that covers the skills needed to meet the prerequisites for this course.

Access VBA

VBA (3-day training  $625)

When using Microsoft Access you reach a point where you have to add some programming to automate certain processes and tie your database objects together. This course helps orient you to the programming tools in Access.

Microsoft Excel

Excel can increase your job prospects as it is a transferrable skill that any hiring manager understands is critical. In addition to organizing data, Excel’s plethora of programs and functions are meant to save time at your job and/or in your personal life. Excel is more powerful than ever which some experts claimed the business world cannot live without.

Excel Level 1

Introduction  (1-day training   $150)

This course provides the foundation needed to acquire Excel knowledge and skills, which you can build upon to eventually become an expert in spreadsheet/data management.

Excel Level 2

Intermediate  (1-day training   $175)

In this course, you will build on your fundamental Excel skills to become proficient with advanced Excel features.  Topics include using multiple worksheets, combining worksheets, linking formulas, managing charts, and using styles to format worksheets.  These features will help in analyzing massive amounts of data, extract information from it, and present this information to decision makers.

Excel Level 3

Advanced  (1-day training   $225)

This course will build on the knowledge acquired from Levels 1 & 2 Excel courses. Topics include advanced formulas and functions, adding conditional constructs etc.  These elaborate formulas help maximize the full power of Excel.

Excel VBA

VBA  (3-day training   $625)

Learn to automate repetitive tasks using Excel VBA.  This course will teach students how to implement easy ways for users to manage and interact with spreadsheets.

 

Microsoft Outlook

Email is the primary mode of communication at work today.  Outlook offers numerous features to help users be more productive - setup meetings, find more information about a contact, dial into conference calls or jump onto online meetings. It provides several ways to track down what users are looking for.  Users can perform search based on different criteria, sort email by size, date or sender and just manage better the clutter in folders and inboxes.  Users can easily setup rules to flag important email based on the sender, schedule resources like meeting rooms, projectors, etc., auto-respond to meeting invites as well as the ability to see the free/busy schedule.

Outlook Level 1

Introduction  (1-day training   $150)

This course will cover basic skills to manage email communications, contact information, calendar events, tasks, and notes, schedule appointments and meetings, and customize the Outlook interface.

Outlook Level 2

Intermediate/Advanced  (1 day training   $175)

This course will cover a wide range of features and options such as configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate mail management tasks, preserve data with archives and data files, share and delegate access to Outlook items and many more.

 

Powerpoint

Businesses use presentations to inform, educate, motivate and persuade internal and external audiences. Through powerpoint presentations the power of words and images are amplified to engage the audience and help retain attention.  So learn Powerpoint - embrace the “a picture tells 1,000 words” mentality and find out how to explain and clarify your point with more visual aids.

Powerpoint Level 1

Introduction  (1-day training   $150)

This couse will cover several Powerpoint functionalities to create engaging and dynamic multimedia presentations, organize contents with high-impact tables, charts and graphics, and deliver presentations with a punch.

Powerpoint Level 2

Intermediate/Advanced  (1-day training   $175)

This course will cover several topics such as modify the PowerPoint environment, customize design templates, add SmartArt, work with media and animations, collaborate on a presentation, customize a slide show, and distribute a presentation.

 

Microsoft Word

Microsoft Word is a sophisticated word processing application designed for performing various word processing tasks to create and maintain different types of documents, create mailing labels, newsletters, with features for graphic design, statistical reporting, spelling and grammar checking, etc. These tools make Word stand out among other word processing programs.

Word Level 1

Introduction  (1-day training   $150)

Learn how to create, edit and format documents, add tables and lists, add design elements and layout options and do other basic functions such as print, setup page layout and spell check.

Word Level 2

Intermediate  (1-day training   $175)

This course will cover tables and charts, Quick Parts and templates so that managing more complex documents can be simplified.  It will also cover the mail merge feature to automate sending of individual letters to customers.

Word Level 3

Advanced  (1-day training   $225)

This course will cover interactive forms, macros, reviewing tools, and how to create document references like Table of Contents, Indices and Footnotes.

 

ASP.NET MVC Programming

The ASP.NET MVC is an open-source built on top of the Microsoft .NET Framework to develop web applications that are based on MVC (Model-View-Controller) architectural pattern - designed with separation of concerns and testability in mind.

5-day training   -   $1600

This course will teach students how to develop ASP.NET MVC application using .NET Framework tools and technologies. It focuses on coding activities that enhance the performance and scalability of a web application. Students will be introduced to the benefits of MVC (Model-View-Controller) design pattern and how MVC is in comparison with other programming models.

 

ASP.NET Core MVC Programming

Cross-platform is one of the distinguishing features of ASP.NET Core MVC making it more and more popular. Web applications can now run in Mac, Windows and Unix environment. Its modular architecture also improves solution performance and reduces the time it takes to upgrade separate parts.

5-day training   -   $1600

ASP.NET Core MVC is the open-source version of ASP.NET that can run on macOS, Linux, and Windows.  It is a complete reform of ASP.NET that combines MVC structure and Web API into a single framework.  This course is intended for web developers who use Microsoft Visual Studio.  It will focus on coding activities to improve the performance and scalability of the Web site application.

 

C# Programming

Learn a programming language that is popular across many industries and applications. Favored by millions for its versatility and easy-to-read syntax, C# has become a go-to for web and mobile apps, game development, business applications and more.  C# developers have a very cohesive Microsoft-supported set of tools for developing any type of application.  It ranks as the top 10 most loved languages and will continue to rise in its ranking as Microsoft continues its open sourcing initiatives which allow this language to now run natively on Mac and Linux as well as Windows. We highly recommend giving C# a look as your programming language of choice.

5-day training   -   $1600

In this course, the students will gain programming skills required for developers to create applications using the Visual C# language.  Topics include the basics of Visual C# program structure, language syntax, and several other implementations such as delegates, inheritance, IO operations, accessing a database. encryption and decryption and many more.

 

Crystal Reports

Crystal reports is a report creation engine. It is capable of reading. sorting, filtering, calculating and querying data from different databases using SQL as the command language.  It provides customizable reporting features that can be used to deliver decision-making reports.

Crystal Reports Level 1

Introduction  (2-day training   -   $450)

This course will cover advanced functionalities of Crystal Reports to generate reports in the desired format, and create complex reports such as subreports and cross-tabs.

Crystal Reports Level 2

Intermediate  (2-day training   -   $450)

This course will cover advanced functionalities of Crystal Reports to generate reports in the desired format, manage subreports and cross-tabs and work with advanced formulas.

 

HTML5 & CSS3

Hypertext Markup Language revision 5 (HTML5) is a markup language that provides structure and presentation of World Wide Web contents. It instructs web browsers how to render contents and explains the underlying structure of a web page. HTML has been considered a cornerstone technology of the World Wide Web along with Cascading Style Sheets or CSS.

3-day training   -   $625

Learn the basic building blocks of Web design and style using HTML5 and CSS3.  This will provide the foundational knowledge of web page coding that will help student move forward to becoming a front-end developer or a web page designer.

 

Intro to Web Development Using ASP.NET

ASP.NET is developed by Microsoft. It is used to create web pages and web technologies and is an integral part of Microsoft’s .NET framework vision. ASP.NET is a very valuable tool for programmers and developers as it allows them to build powerful, dynamic, rich web-based applications using compiled languages like VB.NET and C#.

5-day training   -   $1600

This course provides knowledge and skills on developing Web applications by using Microsoft Visual Studio.  Topics include creating ASP.NET Web Forms, master pages and user controls, validating user input, debugging,   managing data access tasks by using LINQ and many more.

 

Transact SQL

Several custom-built .NET apps use SQL Server on the backend.  T-SQL knowledge will serve you well as it reigns supreme in a variety of areas from data science to healthcare and insurance to genetic research and with business tools such as PowerBI and Dynamics  The future of SQL Server is very bright, and learning T-SQL reaps dividends.  Start here...

2-day training  -  $475

This course will teach the fundamentals of writing SQL SELECT statements using WHERE expressions, sorting, functions, joins and subqueries.  Writing INSERT, UPDATE and DELETE statements will also be covered.

 

VB.NET Programming

Visual Basic .NET is a programming language that is part of the .NET framework development platform and maintained by Microsoft. It is a productive tool designed for rapid creation of a wide range of Web, Windows, Office, and Mobile applications.  It is an approachable language with a simple syntax for building object-oriented apps.

5-day training  -  $1600

The students will gain programming skills required for developers to create applications using the Visual Basic .NET language.  Topics include the basics of Visual Basic .NET program structure, language syntax, and several other implementations such as delegates, inheritance, IO operations, accessing a database. and many more.

 

Intro to Entity Framework

Entity Framework can provide the database commands for reading or writing data in the database and execute them.  It eliminates the need for most of the data-access code that developers usually need to write.  Learn how to use Entity Framework to build modern applications targeting the web, desktop and mobile. See how Entity Framework makes it very simple to keep both your code and database in sync.  Learn several features including implementing Code First conventions.

3-day training  -  $1200

This class will provide fundamental knowledge on how to perform data access operations using the ADO.NET Entity Framework, LINQ and ADO.NET.    Students will learn how to implement data binding within their Web and/or Windows client applications .  The goal is to increase the developer's productivity by reducing the redundant task of persisting the data. 

 

Windows 10

While the Windows 10 user interface is extremely intuitive, you still need to dig a little deeper to customize experience, get maximum performance and make the most of features.  Learn the basics, tips and tricks and overall be more productive.

1-day training  -  $175

This class will provide fundamental knowledge on how to become more comfortable with using a personal computer (PC).  It will focus on the Windows 10 interface. covering several new features as well as improvements to existing ones.