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:
In this Article, we will learn how to manage objects in Microsoft Access. There are a number of ways you can manage your objects using the Navigation Pane in Access 2013. All of these ways may be accessed by right-clicking on the object you would like to work with. Read more.
Changing the Task Calendar
Tasks can have different calendar types applied to them. This is useful if you would like to prioritize tasks or assign them to a specific shift. To adjust a task’s calendar type, first open the Task Information dialog for the task in question. 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