Police in Michigan say a suspect has been shot and killed by a security guard after a shooting at a church in a suburb of Detroit.