Training Videos Archive

  • 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

    Posted on August 8, 2012 | No Comments
    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

    Posted on August 6, 2012 | No Comments
    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

    Posted on April 9, 2012 | No Comments
    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

    Posted on April 9, 2012 | No Comments
    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

    Posted on February 6, 2012 | No Comments
    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

    Posted on January 16, 2012 | No Comments
    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...

  • 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

    Posted on December 13, 2011 | No Comments
    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...

  • Append queries are a quick and easy way to copy or "move" records to a table in Access. In this clip from TrainSignal, I show students how to add a sale price to select books in our sample database for Picaroon Publishing and copy only those sale books to an existing (yet blank) table. This is just one of many uses for an append query. Enjoy!

    Creating an Append Query in Microsoft Access

    Posted on November 21, 2011 | No Comments
    Append queries are a quick and easy way to copy or "move" records to a table in Access. In this clip from TrainSignal, I show students how to add a sale price to select books in our sample database for Picaroon Publishing and copy only those sale books to an existing (yet blank) table. This is just one of many uses for an append query. Enjoy!

    Continue Reading...

  • This clip is one I created specifically for TrainSignal‘s YouTube Office channel to begin a new video series, the “PowerPoint FAQ” series, designed to answer some of the commonly asked questions...

    PowerPoint FAQ: How do I animate SmartArt shapes individually?

    Posted on September 19, 2011 | No Comments
    This clip is one I created specifically for TrainSignal‘s YouTube Office channel to begin a new video series, the “PowerPoint FAQ” series, designed to answer some of the commonly asked questions...

    Continue Reading...

  • This clip is one I created specifically for TrainSignal‘s YouTube Office channel. This clip, along with several other clips in the “Access Database Basics” series, is designed to cover a very...

    Access Database Basics-Primary Keys

    Posted on August 23, 2011 | No Comments
    This clip is one I created specifically for TrainSignal‘s YouTube Office channel. This clip, along with several other clips in the “Access Database Basics” series, is designed to cover a very...

    Continue Reading...

Page 1 of 3123