Please help me with this task for Microsoft access. I$\text{'}$m attempting to create VoteID $($Primary Key for the Nomie Table, which is the record source$),$ GameID, $($a Foreign Key that pulls information from the GameInformation Table$),$ GameNameID $($a Foreign Key that pulls information from the GameName table$),$ GenreID $($a Foreign Key that pulls information from the Genre Table$),$ and Publisher ID $($a Foreign Key that pulls information from the Publisher table$),$ and Awards Nominated, $($which is supposed to check how many times a yes$/$no data type box has been checked$).$ What I want to do is create a form that analyzes the number of times the GameNameID has been mentioned in a separate table called NomineeTable. After that, if the analyzed game has a check mark $($which signifies that the game is the winner$)$ add it to an equation that adds $+1$ for every check mark. The picture attached is from the Nominee form.