Sunday, August 01, 2010

Our Sacrament Meeting Database

Years ago when I was called to serve as a member of the bishopric (lay clergy leadership) of my local LDS Church congregation (known as a ward), the need for a way to manage Sacrament meeting worship service programs quickly became clear.

In these weekly congregational meetings, the prayers, ordinances, sermons, and musical numbers are performed by lay members. Any member of the congregation may be invited to participate. In LDS terminology, these invitations are “callings” extended by the congregational leaders — usually members of the bishopric.

As a busy bishopric member, how do you go about arranging for members to fill these callings in an efficient manner? How do you spread the opportunities around so that you don’t rely on the same people over and over while constantly ignoring others? Technology provided part of the answer for our bishopric.

The main members of an LDS ward bishopric are the bishop and his two counselors. Other members include an executive secretary, a ward clerk, and assistant ward clerks. In our bishopric, Sacrament meeting arrangements fell to the bishop and the counselors. The other bishopric members had their own duties to attend to.

Within weeks of beginning my bishopric calling, I devised two tools that proved immensely helpful to us, especially as time went on. First, I built a spreadsheet that listed the dates of the next year of upcoming Sacrament meeting worship services. I had columns for date, main topic, possible participants, musical numbers, the bishopric member that would conduct, and the bishopric member in charge of making the arrangements.

Every three months, we would sit down as a bishopric and develop pretty solid plans for the upcoming three months, somewhat firm plans for the following quarter, and loose plans for the quarter after that. So our spreadsheet consistently covered nine months. While meeting conducting duties shifted among us from month to month, each of us would take a three-month stint to arrange meetings. This three-month window allowed for flexibility to shift program arrangements around to different weeks, as needed.

This worked well for us. Once we had our plans written down, the arrangements weren’t too difficult to make. Occasionally we’d have to revisit the plan when something didn’t work out as originally charted, but it was rarely a big deal. Each of us would take care of extending meeting participation callings for three months. This was followed by a half a year reprieve from that duty.

My ward’s current bishopric manages this on a month-by-month basis. Each bishopric member arranges and conducts all of the meetings for a given month, and then they’ve got two months off from those duties.

The second tool I developed was a MS Access database that tracks who does what in Sacrament meeting. I populated the people table with pertinent data about each ward member. An association table hooks individuals together in families and provides address and contact info. The Sacrament program table lets me plug in the program date, each participant, and the type of service rendered (i.e. prayer, speech, musical number).

I developed a number of database reports that were useful to the bishopric. The main report lists details about prayers, youth talks, adult talks, and musical numbers. Each of these categories lists participants for the past five years ordered both by least recent date and alphabetically. Each list shows how many times each individual has participated in that activity during the past five years. In addition, the prayer and speech categories list available members that have not participated in that activity for the past five years. (I didn’t do that for musical numbers, because only some are capable of public musical performances.)

After wrapping up my stint in the bishopric, I continued to provide monthly printouts to subsequent bishoprics. This has been considered to be very useful. Some that have found out about my database have expressed concern that bishoprics might rely too heavily on the data instead of inspiration in making assignments. While there is some possibility that this could happen, I have not observed such. Access to historical information tends to augment inspiration rather than replace it.

Of course, all databases are only as useful as the data they contain. Like all other databases, this one needs to be updated continually. That task falls to me as a volunteer effort. I enter Sacrament program data weekly. I keep track of move-ins and move-outs, births, deaths, etc. Managing phone numbers is a big enough issue that I will treat the matter in a separate post.

While this kind of database upkeep is relatively easy for me, it’s not everyone’s cup of tea. A few years ago, the current bishopric decided to call a guy to take over this duty, since I have other callings that require my time. He was an intelligent man that was devoted to the church.

I developed training materials and loaded the application on this man’s computer. I trained him at his house and over the phone. But after several months, it became clear that this wasn’t a happening thing for him. So I continued doing the job. I think I’d have to develop an entirely new user interface to really make the application work for a non-techie. So far, I haven’t been willing to put that kind of work into it.

My database has evolved over the years to include a variety of information designed to assist the bishopric in developing the quarterly and annual historical reports. But the core remains essentially as I originally designed it.

This Sacrament meeting database has been a boon to my ward’s leaders for a number of years. While I know that the LDS Church is continually updating its computer offerings for local leadership, I haven’t heard about anything on the horizon that would replace my database. So I suspect my application will continue to be used by my ward’s leaders for years to come.

UPDATE 1/14/2017
I have just finished revising the database to be much more streamlined. Since I had become the ward's unofficial historian for many years, I had added some features to the database to assist with ward history. That actually made it pretty messy. It also became clear over time that some database relationships were overly complex.

This new version is much cleaner and simpler. It focuses chiefly on two things: track sacrament meeting program participation and produce useful reports to help ward leaders make decisions about calling people to participate in sacrament meeting programs. I kept a couple of things in the database that aren't essential to this vision. But they are optional and don't have to be used.

Since I haven't upgraded my MS Office subscription, the database was built using MS Access 2010. It should work with any version of MS Access from 2007 onward. It won't work with older MS Access versions without special tools.

Despite simplification, you still need a good working understanding of MS Access to use the database. People with little database savvy will likely find themselves lost. It would be sweet to make the database more user friendly. But I'm just not willing to put that kind of time into it at present.

My current bishopric has me generate the five-year rolling report monthly. I save it as PDF and provide it electronically to each bishopric member. One member of the bishopric asked me about the possibility of making it available as a web page. That would make it much more useful. But I'm simply not willing to deal with the security and confidentiality implications. I don't want to do the work to build a system that would meet Church handbook requirements.

Many have used my database in the past. Some have improved on it. Others have ended up using it as an idea for something that works better for them. I think something along these lines could be helpful to any bishopric that is willing to use it to augment guidance from the Spirit rather than as a way to replace the Spirit.


BDH said...

Scott, Great comments, and I'd have to agree that you're making a valuable contribution. What would be the chances of getting a copy of the database for use in our ward?


Scott Hinrichs said...

I could ship you a copy with the tables emptied out. But I think I would really need to clean it up first.

The application is probably pretty simple for a database geek. But it's currently not intuitive at all for the average computer savvy individual.

I'd have to do for this application something like I did for a database I built for my kids' school to make it useful for the ordinary user. That would take more time than I have at my disposal at the moment. I'll have more time once fall camporee is wrapped up next month.

BDH said...

I'd be ok with the database as is with the tables emptied. I use Access regularily and am comfortable in using it. Don't take too much time with it. We're currently using Excel just for tracking and searching, and my counselors are comfortable with that; but I'm alway interested in looking at different options. We certainly don't have a corner on innovation and technology.

Scott Hinrichs said...

I shipped it to the email address I have for you. Give it a try.

Unknown said...

Could I please get a copy of your database too?
It sounds like it could really help with the assignment planning I need to do.

ajie.nolasco said...

I had just been called to be the bishop of our ward and I also thought of building an Access database to use with planning and printing Sacrament Meeting Programs for our ward. I found your blog while trying to google for ideas on how to do the database (in terms of structure and visual design). If you can share with me a copy of what you did, I would like to see how you did things and what I can incorporate into my own design. Thanks a lot and good luck.

Heart Lake Ward Clerk said...

Hi, I'm a ward clerk and would love to get a hold of your empty application. I've been considering building one because my spreadsheet is getting to big making look ups slow. I'm figuring the application would be a start. Thanks.

Scott Hinrichs said...

Re: Heart Lake Ward Clerk,
I'd be happy to send out a copy of the database and basic instructions. But I need an email address. Your Blogger profile doesn't have one (at least that is visible to me). My email address should be visible to you on my Blogger profile. If you will send me your address, I will ship you the database. Regards.

arhixson said...

Could you please send me the emptied database?

Scott Hinrichs said...

As with my 8/13/2011 response above, I would gladly send you a copy of the database with instructions, but I am unable to locate an email address for you. If you will send your email address I will respond with the database. Regards.

TuErasBasura said...

I would like to look at this, but I was also interested in doing something along the lines of HT visits and trying to call out the people that are not receiving visits, and those not doing visits. MLS doesnt lend to this very well.

Scott Hinrichs said...

I sent a copy of the database to the email address on your Blogger profile. The database has not been designed to handle home teaching, but that could be added by anyone that is adept at Microsoft Access development. It seems like it would require a lot of monthly data input.

Unknown said...

I would also like a copy of the database if possible. I also am familiar with Access and believe I could make any changes needed to tailor to my needs.

spencer.jones43 at

Thank you much!

Matt said...

Do you still use this database? Could I get a copy?

Scott Hinrichs said...

Matt, I have recently been revising the database to be much more streamlined. I'm not quite finished with it. My current callings and family responsibilities are keeping me so busy that I can't really promise to have it done before the end of January. But I'd be happy to send you a copy of the database at that time. I just need a good email address.

Scott Hinrichs said...

Re Doc261: I didn't post your comment because I thought you probably didn't want your email address published to the whole world. I have tried to send a copy of the database to the email address you supplied, but I got a permanent failure back, saying that the email address does not exist. You can get my email by clicking on my name on the About Me section on the right side of my page and then clicking on the Email link. Why don't you email me directly and I will respond to your email. Cheers.