CREATE TABLE table_name_1 (term_of_office VARCHAR(255), member VARCHAR(255))
What was the term of office for noel beaton?
    
SQL: SELECT term_of_office FROM table_name_1 WHERE member = "noel beaton"