Hi everyone, new member here. I am not a COMPLETE Access 2010 noob, but I am at best an intermediate user. We have to create a database based on Voter information. I am having a bit of trouble figuring out how to create this DB. I have imported the data from the proper site and the table is good. Now I am having trouble with the relationships and queries. For example, the many-to-many between voters and promotions, how to go about designing the survey collection/organization method. I really appreciate the help, thanks! Below is the assignment:
County Voter promotion tracking database (
ERD Team Assignment)
Your team has been assigned the task of designing the voter promotional campaign tracking database for a newly formed county political action group (PAG).
At the next meeting (class) your team must present yourentity relationship diagram(ERD) created to identify/organize the data necessary to meet the PAG’s needs/purposes.
The PAG would like to use the database that you design for the following purposes (at a minimum):
To identify which registered voters should be sent promotions by selecting voters based on:
Voter's year of birth
When voter previously voted.
Voter's declared political affiliation when they previously voted.
Voter's Congressional District
Voter's Precinct
etc.(based on available info from the state source)
The PAG would like to use the database to:
track which registered voters were sent which promotions
track responses to survey type campaign promotions
Other examples of data they would like to capture in the database:
Campaign promotion number
Campaign promotion description
Campaign promotion type (post card, survey, Letter, brochure, etc)
Campaign promotion date
Campaign survey promotion responses
Discuss why the PAG should use a database and not a spreadsheet.
County Voter promotion tracking database (
ERD Team Assignment)
Your team has been assigned the task of designing the voter promotional campaign tracking database for a newly formed county political action group (PAG).
At the next meeting (class) your team must present yourentity relationship diagram(ERD) created to identify/organize the data necessary to meet the PAG’s needs/purposes.
The PAG would like to use the database that you design for the following purposes (at a minimum):
To identify which registered voters should be sent promotions by selecting voters based on:
Voter's year of birth
When voter previously voted.
Voter's declared political affiliation when they previously voted.
Voter's Congressional District
Voter's Precinct
etc.(based on available info from the state source)
The PAG would like to use the database to:
track which registered voters were sent which promotions
track responses to survey type campaign promotions
Other examples of data they would like to capture in the database:
Campaign promotion number
Campaign promotion description
Campaign promotion type (post card, survey, Letter, brochure, etc)
Campaign promotion date
Campaign survey promotion responses
Discuss why the PAG should use a database and not a spreadsheet.