Training Videos Archive

  • Since this is a course on Sway, I thought I would start this blog inside a Sway and embed the Sway into this blog. Doesn't that just blow your mind away?

    Sway First Look Course from Pluralsight

    Since this is a course on Sway, I thought I would start this blog inside a Sway and embed the Sway into this blog. Doesn't that just blow your mind away?

    Continue Reading...

  • Back in 2012, DePaul University’s Alan Ackmann and I gave a webinar for TrainSignal on writing resumes in Microsoft Word. Here is the webinar:

    Webinar: Top 10 Resume Tips for IT Pros

    Back in 2012, DePaul University’s Alan Ackmann and I gave a webinar for TrainSignal on writing resumes in Microsoft Word. Here is the webinar:

    Continue Reading...

  • A little while back a colleague of mine asked me, "How do I calculate the total seconds in Excel?" What he had was a column of timestamps in the h:mm:ss format and he wanted to convert that timestamps to simply display the total seconds, which is actually quite easy to do in Excel depending on (1) how the data was entered, and (2) how the data is formatted. Watch this video to learn how...

    Calculate Total Elapsed Seconds in Microsoft Excel 2010

    A little while back a colleague of mine asked me, "How do I calculate the total seconds in Excel?" What he had was a column of timestamps in the h:mm:ss format and he wanted to convert that timestamps to simply display the total seconds, which is actually quite easy to do in Excel depending on (1) how the data was entered, and (2) how the data is formatted. Watch this video to learn how...

    Continue Reading...

  • Microsoft launched the SkyDrive for Windows App, a Windows application that places a SkyDrive folder in the Windows Explorer allowing users to simply click and drag files and folders to this location to sync with SkyDrive automatically.

    SkyDrive for Windows App

    Microsoft launched the SkyDrive for Windows App, a Windows application that places a SkyDrive folder in the Windows Explorer allowing users to simply click and drag files and folders to this location to sync with SkyDrive automatically.

    Continue Reading...

  • If you have ever been frustrated when trying to delete a record in Access and seeing the warning message "The record cannot be deleted or changed because table 'tblYourTableName' includes related records,' do not be dismayed. That warning message is actually a good thing, for referential integrity is protected your data from being orphaned. To side-step the warning message and to allow you and your database users to delete unwanted data, you might want to try to turn on a feature called "cascade delete."

    Microsoft Access Relationship: Cascade Delete

    If you have ever been frustrated when trying to delete a record in Access and seeing the warning message "The record cannot be deleted or changed because table 'tblYourTableName' includes related records,' do not be dismayed. That warning message is actually a good thing, for referential integrity is protected your data from being orphaned. To side-step the warning message and to allow you and your database users to delete unwanted data, you might want to try to turn on a feature called "cascade delete."

    Continue Reading...

  • Newbies to Microsoft Access are often puzzled by a variety of warning messages, and the message "The record cannot be deleted or changed because table 'tblYourTableNameHere' includes related records," is among the more common messages that frustrate beginners. Do not be discouraged. This message is really a good thing because it means referential integrity is doing its job in protected your records from being orphaned.

    Microsoft Access Relationships: Cascade Update

    Newbies to Microsoft Access are often puzzled by a variety of warning messages, and the message "The record cannot be deleted or changed because table 'tblYourTableNameHere' includes related records," is among the more common messages that frustrate beginners. Do not be discouraged. This message is really a good thing because it means referential integrity is doing its job in protected your records from being orphaned.

    Continue Reading...

  • PowerPoint presentations do not have stay as PowerPoint presentations. You can save a PowerPoint file as almost anything nowadays, including a PDF.

    Saving a PowerPoint Presentation as a PDF

    PowerPoint presentations do not have stay as PowerPoint presentations. You can save a PowerPoint file as almost anything nowadays, including a PDF.

    Continue Reading...

  • In this training clip, I show students how to use wildcards inside an Access query to locate a customer by last name without knowing exactly how to spell the customer last name. Knowing how to use wildcards is very important when querying data in Access, as the use of a simple wildcard can save a lot of time hunting through records.

    Microsoft Access Wildcards

    In this training clip, I show students how to use wildcards inside an Access query to locate a customer by last name without knowing exactly how to spell the customer last name. Knowing how to use wildcards is very important when querying data in Access, as the use of a simple wildcard can save a lot of time hunting through records.

    Continue Reading...

  • Back in 2011, Microsoft followed the careers of 8 IT professionals and called the series of interviews, blogs, and real-world video diaries "Career Factor." I was honored to have been asked to review the resumes of these participants and give them tips on updating and formatting their resumes in Word for their job searches. Below is the webinar recording:

    IT Resume and CV Writing

    Back in 2011, Microsoft followed the careers of 8 IT professionals and called the series of interviews, blogs, and real-world video diaries "Career Factor." I was honored to have been asked to review the resumes of these participants and give them tips on updating and formatting their resumes in Word for their job searches. Below is the webinar recording:

    Continue Reading...

  • You can use the DateAdd function for a variety of purposes within Microsoft Access queries. This clip demonstrates how to use the DateAdd Function as query criteria to display only those records whose sales transactions are three months old.

    The DateAdd Function in Access

    You can use the DateAdd function for a variety of purposes within Microsoft Access queries. This clip demonstrates how to use the DateAdd Function as query criteria to display only those records whose sales transactions are three months old.

    Continue Reading...

Page 2 of 41234