Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-15-2019, 07:39 AM   #1
Toffee
Newly Registered User
 
Join Date: Jun 2019
Location: Kenya
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Toffee is on a distinguished road
Unhappy School Electoral System

Hy guys,
Please help.
Q.1 Is it possible to develop a voting system using database?
Q.2 How does one create a table field that automatically generates values from another table when a field in the current table is similar to one in the other table?
Lemme explain. Example: Table 1 has two fields; Position, and, Contestant name. Then Table 2 has the same fields. So i want to be able to generate a lookup for Contestant names(those that have the same position) automatically in table 2 whenever i insert the position name in table 2. So the two tables relate but i don't know how to automate the search in table 2. Table 1 is filled manually.
Hope you understand my problem and can help ASAP.

Toffee is offline   Reply With Quote
Old 06-15-2019, 07:44 AM   #2
Toffee
Newly Registered User
 
Join Date: Jun 2019
Location: Kenya
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Toffee is on a distinguished road
School Electoral System

Hy guys,
Please help.

Instructions to Candidates

1. Use a Database Management System when developing the project.

2. A softcopy of the work must be stored in a removable storage medium.

3. Name and index must appear on the cover page of your documentation.







REHEMA SCHOOL PREFECTS ELECTORAL SYSTEM

Rehema school is a day secondary school with 5 streams each in form one, form 2, form 3 and 4. The studentsí administrative structure is in 3 levels; school level, form level and class level. The school level studentsí leadership positions comprise of the head boy, head girl, D.H captain, games captain and library captain. The form level positions comprise of form captains who are in charge of all the streams in their respective forms. The class level positions comprise of the class prefects who are in charge of their respective classes and are answerable to their respective form captains. All the positions are elective and the holders serve for a one-year term.

The school elections are held at the beginning of each year. Only form 3 students are eligible for school level positions. The school level prefects are elected by all the students in the school. A form level captain is elected by all the students in the streams in his/her own form. A class prefect is elected by members of his/her own class.

Those students who intend to vie for the positions are required to be vetted by the school administration. The successful candidates are required to provide their personal details which would be used in the ballot papers. The school level and form level contestants are vetted by the school administration, while the class level contestants are vetted by their respective class teachers. One of the requirements in the vetting is that each contestant must have been proposed and seconded by their electorate. Those seeking school level positions are required to be seconded by a student from each class in their respective forms. Those seeking class level positions are required to be seconded by two students from their respective classes.

Elections are carried out in every classroom concurrently, where the respective class teacher presides over the exercise. On the day of the election, the class teachers collect ballot papers for each of the elective positions for their respective classes. During the polling, students are required to indicate their preference in the ballot papers by placing a tick ( ) alongside the candidate of their choice and inserting the ballot papers in their respective ballot boxes.

Counting of votes is carried out in their respective classes and the results are recorded, announced and taken to the tallying centre. At the tallying centre, the form level and school level vote results from the classes are combined and the total votes for each candidate recorded. The candidate with the highest number of votes for each post is registered as the winner. The results of the election are forwarded to the schoolís principal who then approves and announces the final results.



Develop a well-documented computerized prefects election system that will

a) Maintain:

i. Records of classes and their respective class teachers;

ii. List of contestants for each post;

iii. List of electoral positions;

iv. List of students per class;

v. List of proposers and seconders;

vi. Results for each level.

b) Compute:

i. Total votes for each contestant at:

∑ School level

∑ Form level

ii. The winner for each post;

iii. Determine the contestants with adequate proposers and seconders.

c) Generate the following reports:

i. Voters list;

ii. List of contestants for each post;

iii. List of class teachers;

iv. List of winners for each post;

v. List of spoilt votes from each class;

vi. List of contestants and the votes garnered.
Toffee is offline   Reply With Quote
Old 06-15-2019, 07:51 AM   #3
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,793
Thanks: 50
Thanked 1,093 Times in 1,074 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: School Electoral System

Hi. Welcome to the forum. Typically, we recommend not storing the same/duplication information in more than one table.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 06-15-2019, 07:52 AM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,793
Thanks: 50
Thanked 1,093 Times in 1,074 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: School Electoral System

Hi. Welcome to the forum. I responded to this other thread before I saw this one.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
Toffee (06-15-2019)
Old 06-15-2019, 07:59 AM   #5
Toffee
Newly Registered User
 
Join Date: Jun 2019
Location: Kenya
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Toffee is on a distinguished road
Re: School Electoral System

Could you please help me with this one then
Toffee is offline   Reply With Quote
Old 06-15-2019, 08:10 AM   #6
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,144
Thanks: 82
Thanked 2,010 Times in 1,958 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: School Electoral System

Threads merged --same topic, same poster, with responses.

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
School Electoral System Toffee Forms 1 06-15-2019 07:51 AM
School management System (Database) paperchazer Tables 5 02-14-2017 12:46 AM
School Database system wabamdo Tables 3 08-28-2014 11:42 PM
Ol' School bypass trick for system time MattK23 Theory and practice of database design 4 08-27-2009 08:16 AM
[SOLVED] School Report System - please help Andy248 Modules & VBA 7 12-07-2005 09:50 AM




All times are GMT -8. The time now is 09:49 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World