Student Government

[aharr28]

I'm new to Access but I'm sure it will be much more efficient than all
these binders and random files laying around the office. I don't even
know where to start!
Can anybody help me with the following:
- Creating a report for voting records based on what legislation it is,
who voted yes, no, and abstained, and what the final action was
(passed, failed, tabled, referred to committee)
- Creating a meeting attendance report that lists by meeting date the
senators present and absent (in alphabetical order preferrably)

I've played around with it and I've made some tables and things but I
just can't get it all to work!
thanks!

 

[Guest]

Here are some table suggestions. Create a one-to-many relationship from the
primary keys to the foreign keys of the same name.

COMMIT_MEMBER
CommitMemberID – autonumber – primary key
CommitteeID – number – integer – foreign key
SenateID – number – integer – foreign key

COMMITTEE
CommitteeID – autonumber – primary key
Name - text

COMMITVOTE
COMITVoteID – autonumber – primary key
BillID – number – integer – foreign key
SenateID – number – integer – foreign key
CommitteeID – number – integer – foreign key
Vote – text – validation – “Yesâ€, “Noâ€, “Abstainedâ€
Method – text – validation – “Voiceâ€, “Roll Callâ€, “Electronicâ€
VoteDate - DateTime

VOTING
VoteID – autonumber – primary key
BillID – number – integer – foreign key
SenateID – number – integer – foreign key
Vote – text – validation – “Yesâ€, “Noâ€, “Abstainedâ€
Method – text – validation – “Voiceâ€, “Roll Callâ€, “Electronicâ€
VoteDate - DateTime

BILL
BillID – autonumber – primary key
BillNUM – text
Title text
SubTitle – text
FinalAction – text – validation – “Passedâ€, “Failed,†“Tabledâ€, “Referred to
committeeâ€

SPONSORS
BillSentorSponsorID – autonumber – primary key
BillID – number – integer – foreign key
SenateID – number – integer – foreign key

SENATORS
SenateID – autonumber – primary key
Lname – text
Fname – text
MI – text
State – text
Party - text
Elected – DateTime
EndTerm – DateTime