To see if records will be deleted from any additional tables, check the Relationships window (on the Database Tools tab, ...

To see if records will be deleted from any additional tables, check the Relationships window (on the Database Tools tab, in the Show/Hide group, click Relationships) for tables that have a one-to-many relationship with the affected table. For each table that represents the "many" side of the relationship, check to see if cascading deletes are enabled for the relationship.  (Tip: Double-click a join line in the Relationships window to see the details of the relationship, and verify whether the Cascade Delete Related records check box is selected.) Records will be deleted from each table on the "many" side of the relationship where cascading deletes is enabled.