access Archive

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

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

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

  • Whether you are new to Microsoft Access or relational databases in general, this tutorial will help clarify what it means to have a relationship between database tables and explain some […]

    Database Relationship Basics

    Whether you are new to Microsoft Access or relational databases in general, this tutorial will help clarify what it means to have a relationship between database tables and explain some […]

    Continue Reading...

  • Designed for the beginning database end-user, this course takes a more focused approach (as opposed to other CBTs that try to cram every Microsoft Access topic into a 5 hour […]

    Heather Ackmann’s Access 2010 Training Course from TrainSignal

    Designed for the beginning database end-user, this course takes a more focused approach (as opposed to other CBTs that try to cram every Microsoft Access topic into a 5 hour […]

    Continue Reading...

  • Recently, I co-authored a review of Microsoft Office 2010 for Redmond Magazine.

    My Review of Office 2010

    Recently, I co-authored a review of Microsoft Office 2010 for Redmond Magazine.

    Continue Reading...

  • This clip, from Train Signal's Access 2007 Training course, teaches students the basics of creating a calculated detail field in Access 2007.

    Creating a Calculated Detail Field

    This clip, from Train Signal's Access 2007 Training course, teaches students the basics of creating a calculated detail field in Access 2007.

    Continue Reading...

Page 1 of 212