Below you will find useful informational articles , including tips and tricks, how-to articles etc. Content is updated on a weekly basis.
Microsoft Office Learning Resources:
Access Database Relationships
Relationships define a database. The power of a database lies in the way the tables are related to each other. Nearly every database that contains multiple tables also includes relationships between these different sets of information. There are three types of table relationships: one-to-many, many-to-many, and one-to-one. Let's learn about each type. Read more.
Assigning Resources to Tasks
In this article we will show you step-by-step how to add resources to tasks in MS Project's Auto Schedule Mode. Read more.
Sorting in Microsoft Word
In a document, you might need to arrange a list of single line items, a group of multiple line paragraphs, or the rows of items in a table into alphabetical or numerical order. Word lets you sort lines and paragraphs of document text and rows of table information into logically defined sequences. Read more.
Relative and Absolute Cell Reference
A cell reference refers to a single cell or range of cells on a Excel worksheet. These cells can be referred to by Excel Formulas when calcuations are made. In this tutorial you will learn the differences between relative and absolute cell references. Each behaves differently when copied and filled to other cells. Relative references change when a formula is copied to another cell whereas Absolute references, remain constant, no matter where they are copied. Read more.
More Microsoft Office Learning Resources
Adobe Learning Resources:
Virtual Reality and Premiere Pro
The world loves watching powerhouse films like Star Trek, Star Wars, Guardians of the Galaxy, Avengers and so many more because, aside from the action - the hi-tech gadgetry and holographic effects are just so mind-blowingly cool. Read more.
Creating a Clipping Mask in Photoshop
There are a few go-to tips that can give your design project immediate punch and pizzazz. They add a lot of polish and a stamp of professionalism with minimal difficulty. One my favorite is Creating a Clipping Mask. I'm sure you have seen those movie posters and advertisements where there is a photo coming through the shape of some text. It makes us go 'wow.' You probably think it is an advanced feature of Photoshop but it is really pretty simple. It can be done with a shape or text. Read more.
Superhero Motion Effects In Adobe After Effects
The other day I was watching the series The Flash on Netflix and remembered how, when I was younger, I wanted to run "superhero" fast! Who wouldn't want to do that? For a short while, my 7-year-old self was a believer that this was actually possible. Unfortunately, the inevitable reality set in. Combine this with my body type and the fact that I hated physical education. I think you get the idea! Anyways, motion blur and motion trail effects have been a staple of the superhero and fantasy film genres for a very long time. Read more.
More Adobe Learning Resources
Business and Softskill Resources:
How to Handle Critism
This has to be the best advice of all time I first read in my teens from the book “How to Win Friends and Influence People” written by Dale Carnegie. Certainly, there is an art to being diplomatic to win cooperation when giving criticism. When it comes to taking criticism, how do we know we are handling it well? Read more.
When is it okay not to tip?
What constitutes bad service? A bad attitude? A delay? A spill? A stupid question? Unless a rat runs over your food and they refuse to get you another plate, to express your dissatisfaction by by not tipping at all says more about your lack of class and education than those you decided to punish by not tipping. In this article we will cover why, how and when not to tip. Read more.
Time management is about more than just managing our time; it is about managing ourselves, in relation to time. It is about setting priorities and taking charge. It means changing habits or activities that cause us to waste time. It means being willing to experiment with different methods and ideas to enable you to find the best way to make maximum use of time. Read more.
Holiday Party Etiquette
The movie Office Christmas Party is sure to give us plenty of laughs over what not to do at your holiday parties at the end of the year. Let’s take a moment to consider valuable tips to ensure you plan, show up and continue a positive impression on colleagues and clients you work with after all the feasting, drinking and Uber rides get you home after a great night out. Read more.
Web Development Learning Resources:
Applying CSS Tags to HTML
In my HTML/CSS class at Training Connection we learn different ways of adding CSS styles to our HTML documents. There are benefits and drawbacks of each method available but first let's make sure we understand what a CSS Style is and why we use them. Read more.
You know what a function is and you know how to create variables. But, did you know that a variable behaves differently when it is used inside a function? Specifically, we are talking about variable scope. No, not the mouthwash for variables, although sometimes I feel like my variables could use a good cleaning. We are talking about the scope, as in the range of the effect of a variable. Read more.
Creating a Full-Height Web Page Layout
A common issue that comes up when creating web pages is what happens when the content on a page is smaller than the screen height. For example, take a look at the following simple layout: Read more.
More Web Development Learning Resources