A simple table to track officers. Enter or select the member's name then enter or select the office. Enter the start date for that office and the end date automatically fills for one year later, but can be changed as desired.
There are two ways to store information.
Note: When the form is closed, each member's record will be updated to include or exclude them from the "board." You can certainly include non officers on the board by modifying that individuals record.