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

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

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