MS Access Based Volunteer / Greeter Scheduler

The project is to manage an MS Access scheduler table [2 screens] (containing volunteer details), by multiple users simultaneously along with 3 reports which may be generated any any user simultaneously.

The first attachment is the structure of the main table. As shown in the sheet, there are 3 additional columns required: cphone char 15, nocontact Y/N, last_name char 30. You will need (if required) to create a shift required table.

Any person (volunteer/greeter) in the table, can opt to volunteer / greet, for taking part in various shifts for various days.

Possible days (of a month) are :

Every Monday

Every Tuesday

Every Wednesday

Every Thursday

Every Friday

Every Saturday

Every Sunday

Every Alternate Monday

Every Alternate Tuesday

Every Alternate Wednesday

Every Alternate Thursday

Every Alternate Friday

Every Alternate Saturday

Every Alternate Sunday

First Monday of the month

First Tuesday

First Wednesday

First Thursday

First Friday

First Saturday

First Sunday

Second Monday

Second Tuesday

Second Wednesday

Second Thursday

Second Friday

Second Saturday

Second Sunday

Third Monday

Third Tuesday

Third Wednesday

Third Thursday

Third Friday

Third Saturday

Third Sunday

Fourth Monday

Fourth Tuesday

Fourth Wednesday

Fourth Thursday

Fourth Friday

Fourth Saturday

Fourth Sunday

Fourth Monday

Fifth Tuesday

Fifth Wednesday

Fifth Thursday

Fifth Friday

Fifth Saturday

Fifth Sunday

Possible shift timings are (there should be the ability to add a new shift):

9am – 1pm

1pm – 5pm

5pm – 7:00pm

7:00pm – 10:30pm

These days and shifts can be multi-selected for any given volunteer.

For eg.

A Person (Volunteer/greeter) with id 210, can opt to volunteer every Monday and Thursday for the 9am – 1pm and then for the 7:00pm – 10:30pm shifts

A Person (Volunteer) with id 352, can opt to volunteer every on the first and third Friday for the 9am – 1:00 pm and then for the 1:00pm – 5:00pm shifts.

A Person (Volunteer) with id 381, can opt to volunteer every on the first Monday for the 9am – 1:00 pm and then every Wednesday for the 1:00pm – 5:00pm shifts.

A Person (Volunteer) with id 452, can opt to volunteer every Sunday for the 9am – 1:00 pm and then for the 1:00pm – 5:00pm shifts and then the 5:00pm – 7:00pm and the 7:00pm – 10:30pm shifts. (ie. This volunteer can attend the whole day every sunday)

There will be a special processing for Volunteers who opt for alternate days (eg. Many volunteer for every alternate Fridays – Hence, for the first occurrence, the system will allocate the person to a particular Friday, and then his name will NOT appear the next Friday, but will again appear the Friday after that etc.

Data Entry Screen Required:

1. A screen to add/edit/delete a new shift (timings) [No requirement to create new days]

2. A screen to add/edit/delete volunteer information [Incl shift and day required] – it should automatically store the created date, and the last modified date.

Reports Required:

1. Shift Report – As shown in [url removed, login to view] - Page 1 – selected for a particular period (generally a month), along with what shifts should show in the report.

2. A Volunteer call report: As shown in [url removed, login to view] - Page 2 – This is a report generated for a particular day (eg. Today they will generate this report for the day after tomorrow) – This will list the people (shift wize) that are scheduled to volunteer that day.

3. List of All volunteers [Area, Group, Name, Cphone, hphone, wphone, postal code, language, available, comments]with a given sort – (postal code, group, language)

Skills: Microsoft Access

See more: access scheduler, volunteer access, access volunteer, greeter scheduler, what is second shift, what is data structure, what is data in data structure, volunteer data entry, first volunteer, fifth third, data structure sort, data entry screens, data entry ms access, data entry in ms access , c scheduler, access group, what is ms access, volunteer, ms access, hphone, delete attachment, access microsoft, access reports data entry, access comments pdf, access delete

About the Employer:
( 6 reviews ) Mumbai, Canada

Project ID: #1095324

Awarded to:


Ready to start

$130 USD in 4 days
(5 Reviews)

12 freelancers are bidding on average $201 for this job


15 years experiance in access. I would like to bid. DOnna

$150 USD in 5 days
(32 Reviews)

I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks [login to view URL]

$270 USD in 15 days
(3 Reviews)

please see the PM

$240 USD in 5 days
(14 Reviews)

Please check PM

$300 USD in 20 days
(2 Reviews)

………..#####... “KINDLY FOLLOW MY MASSAGE & FEEL REAL DIFFERENT HERE” ...##### ……….. ...

$250 USD in 10 days
(1 Review)

Hi, check PMB for my previous project. Thank you!

$222 USD in 14 days
(0 Reviews)

hello, how are you ,iam ready to do the job for you .

$225 USD in 15 days
(0 Reviews)

i have ability to do work

$150 USD in 10 days
(0 Reviews)

I am having good Access skills and ready to do it in 5 days

$149 USD in 5 days
(0 Reviews)

hi I did schedule control in Access. I have ten years experience on MS Access. I have done ten Access DB for client in 2010 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it we More

$200 USD in 4 days
(0 Reviews)

I am expert in MS Access and relational database design, you will get a normalized database and optimized for performance and storage.

$125 USD in 3 days
(0 Reviews)