Marriage Prep Class Database



I am working on a database the tracks couples getting ready for marriage. I was given this project by my diocese which runs about 200 churches in my area. There have been 2 or 3 hands that have touched this project with never getting it working correctly. I am a novice Access person and a beginner at VBA. I have cleaned up a lot of the trash in the database and have it to a point where I could use some help. Are you interested in this project? Could you help me out at all with your hourly rate (I hate asking this but I’m own my one for getting this done for the church).

If you are interested I would like to complete this in 2 or 3 phases

Background on the database:

Couples personal information will collected and stored, also couples must complete 5 classes which have first have to be built in the database and then there attendance must be tracked.

Phase 1

Complete all utility forms with their sub forms

Of all the forms I have created the following forms:




do not need any work at this time I believe that they will work as is.

I would like sub or split forms showing all the records for the following forms:





I tried to complete this myself on the clergy form but was unable to complete correctly

When clicking on one the arrows on the right of the names in the sub form it show load the record into the main form I would like the search button changed also that it could open a small box or somewhere on the sub form have a box that you filter or search on any part of a certain field (in the case of clergy “lastname”) so if you entered an s it would show in the sub form all the clergy with the last name starting with an s

On frm_class_create I would like to create 5 records that go into the class schedule table at one time. Can this be done? Can you tell what I am trying to do but what is started or you need more information? I may also want to change the primary key from auto number to a unique number that comes from the sum of a few fields. ( I will experiment with this myself and let you know if I need help)

Phase 2

Complete Registration form

Phase 3

Quires and reports

Could you give me a price or an rate and the estimated hours on what it will take? How is your work load right now?

Please let me know


Skills: Microsoft Access, Visual Basic

See more: want to create my own database, vba load, prep for prep, i hate working, what is vba, vba right, right vba, prep, marriage, churches, time class, vba open access, filter vba, access vba open, vba filter, vba arrows, create access database reports, hours access database, vba table filter, arrows vba, access database work hours, access vba open table, vba create schedule, create search access database, attendance time table access

Project ID: #4688741

1 freelancer is bidding on average $90 for this job


Hired by the Employer

$90 USD in 5 days
(42 Reviews)