1. Welcome to Baptist Board, a friendly forum to discuss the Baptist Faith in a friendly surrounding.

    Your voice is missing! You will need to register to get access to all the features that our community has to offer.

    We hope to see you as a part of our community soon and God Bless!

MS Access for Church Management??

Discussion in 'Computers & Technology Forum' started by Hardsheller, Feb 27, 2005.

Top Posters
  1. Hardsheller

    Hardsheller Active Member
    Site Supporter

    Joined:
    Jun 21, 2002
    Messages:
    3,817
    Likes Received:
    2
    Anyone using MS Access for Church Management?

    Would love some help with this.

    Thanks
     
    #1 Hardsheller, Feb 27, 2005
  2. Hardsheller

    Hardsheller Active Member
    Site Supporter

    Joined:
    Jun 21, 2002
    Messages:
    3,817
    Likes Received:
    2
    Nobody using MS Access? For Anything?
     
    #2 Hardsheller, Mar 3, 2005
  3. exscentric

    exscentric Well-Known Member
    Site Supporter

    Joined:
    May 24, 2004
    Messages:
    4,366
    Likes Received:
    47
    Faith:
    Baptist
    If you have questions/problems post them - others might have some ideas.
     
    #3 exscentric, Mar 3, 2005
  4. Hardsheller

    Hardsheller Active Member
    Site Supporter

    Joined:
    Jun 21, 2002
    Messages:
    3,817
    Likes Received:
    2
    I have basic understanding of relational databases. For example if I have a sales force spread out all over the USA and I want to break my sales reports down to see how each regional manager is doing and what his district is selling, I can do that because all my products have product ID's and all my salesmen have District ID's and Employee numbers.

    What I'm having difficulty with is putting together the different pieces of a Church management database without assigning Member ID's to people. You know how people are about numbers...."I'm just another number to that church!"

    At this point I'm stumped.......Any suggestion?
     
    #4 Hardsheller, Mar 4, 2005
  5. seminfer2004

    seminfer2004 New Member

    Joined:
    Sep 11, 2004
    Messages:
    2
    Likes Received:
    0
    Are people really that paranoid? The only reason you would need a number is to uniquely identify the person/family. All related information of people and their addresses should be in a single table.


    MemberID:
    FamilyID:
    LastName:
    FirstName:
    MI:
    Address1:
    Address2:
    City:
    State:
    ZipCode:
    HomePhone:
    CellPhone:
    WorkPhone:
    StatusCode:

    Where StatusCode could be the following:
    CM = Member
    RA = Non-Member/Regular Attender
    LV = Local Visitor
    OV = Out of town visitor
    etc

    If people do not want to be known by just another number. Just personalize it some!

    Use the following set of rules:

    Take the first 5 characters of the LastName, followed by the first initial of the FirstName, followed by the first initial of the MiddleName, followed by a two or three digit number.

    If the LastName is shorter than 5 characters, use all characters of the LastName, followed by the first ( 5 – number of character in the LastName), followed by the first initial of the MiddleName, followed by a two or three digit number.


    FamilyID would be the MemberID of the most senior member of the Family living at the same address.


    Examples:

    Johnson Family:

    Johnson, Michael D = JOHNSMD001 (Dad )
    Johnson, Shelly = JOHNSOS001 ( mom with no middle initial )
    Johnson, Rachel J = JOHNSRJ001 (Daughter)
    Lee, David C = LEEDAVC001 ( foster child )
    Each member would then have a Family ID of JOHNSMD01.

    If there was another Johnson, Rachel J, she would have a MemberID of JOHNSRJ003, but her Family ID could be JOHNSRJ003.

    This is only an idea. There are my problems with it. But it does get away from just another number mentality.
     
    #5 seminfer2004, Mar 4, 2005
  6. seminfer2004

    seminfer2004 New Member

    Joined:
    Sep 11, 2004
    Messages:
    2
    Likes Received:
    0
    Are people really that paranoid? The only reason you would need a number is to uniquely identify the person/family. All related information of people and their addresses should be in a single table.


    MemberID:
    FamilyID:
    LastName:
    FirstName:
    MI:
    Address1:
    Address2:
    City:
    State:
    ZipCode:
    HomePhone:
    CellPhone:
    WorkPhone:
    StatusCode:

    Where StatusCode could be the following:
    CM = Member
    RA = Non-Member/Regular Attender
    LV = Local Visitor
    OV = Out of town visitor
    etc

    If people do not want to be known by just another number. Just personalize it some!

    Use the following set of rules:

    Take the first 5 characters of the LastName, followed by the first initial of the FirstName, followed by the first initial of the MiddleName, followed by a two or three digit number.

    If the LastName is shorter than 5 characters, use all characters of the LastName, followed by the first ( 5 – number of character in the LastName), followed by the first initial of the MiddleName, followed by a two or three digit number.


    FamilyID would be the MemberID of the most senior member of the Family living at the same address.


    Examples:

    Johnson Family:

    Johnson, Michael D = JOHNSMD001 (Dad )
    Johnson, Shelly = JOHNSOS001 ( mom with no middle initial )
    Johnson, Rachel J = JOHNSRJ001 (Daughter)
    Lee, David C = LEEDAVC001 ( foster child )
    Each member would then have a Family ID of JOHNSMD01.

    If there was another Johnson, Rachel J, she would have a MemberID of JOHNSRJ003, but her Family ID could be JOHNSRJ003.

    This is only an idea. There are my problems with it. But it does get away from just another number mentality.
     
    #6 seminfer2004, Mar 4, 2005
(You must log in or sign up to post here.)
Loading...