Latest Posts
  • 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...

  • Back in January, Alan Ackmann (yes, my husband) and I gave a webinar for the TrainSignal blog on The Top 10 Resume Tips for IT Pros. Following that same theme, we were asked to deliver a similar webinar, this time focused on cover letters for IT Professionals.

    Conquering the IT Cover Letter

    Back in January, Alan Ackmann (yes, my husband) and I gave a webinar for the TrainSignal blog on The Top 10 Resume Tips for IT Pros. Following that same theme, we were asked to deliver a similar webinar, this time focused on cover letters for IT Professionals.

    Continue Reading...

  • It is official. There will be another MCT Summit this year, an event by MCTs for MCTs, designed to build our skills on the latest changes in technology, certification, and course ware, and to, of course, development our teaching skills.

    MCT Summit NA, 2012

    It is official. There will be another MCT Summit this year, an event by MCTs for MCTs, designed to build our skills on the latest changes in technology, certification, and course ware, and to, of course, development our teaching skills.

    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 5 of 8« First...34567...Last »