About Author: Heather Ackmann

Description
Heather Ackmann is a PowerPoint MVP and globally-recognized instructional designer with 15+ years experience developing educational materials in virtual and face-to-face contexts, ranging from step-by-step processes for end-users to world-class professional support for fellow Microsoft Certified Trainers (MCTs). She has produced, designed, and narrated 300+ hours of video-based training, and is the author of Conversational Office 2016, designed to introduce new Office features. The book is free to download compliments of www.conversationalgeek.com.

Posts by Heather Ackmann

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

  • 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

    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?

    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

    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...

  • This year I am helping to organize this year’s MCT Summit Oct 19-21 in San Francisco. The MCT Summit (MCT standing for Microsoft Certified Trainer) is an opportunity for MCTs […]

    MCT Summit North America 2011

    This year I am helping to organize this year’s MCT Summit Oct 19-21 in San Francisco. The MCT Summit (MCT standing for Microsoft Certified Trainer) is an opportunity for MCTs […]

    Continue Reading...

Page 5 of 8« First...34567...Last »