ChurchBook/DataBase 
Movie Groups

You can display the movies listed below on your internet browser.  The movies use the "Adobe Flash Player".  If you do not have it, you can obtain a free copy from http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash.   

 

We recommend the Mozilla Firefox browser for this, but Windows Explorer will (usually) display the movies, but may fuss at you about security and ActiveX issues.  If you don't have Firefox, there is a no- charge version available at http://www.mozilla.com/en-US/firefox/.  It is HIGHLY recommended!

You can go to the sections directly by using the links in the left column.  After viewing a particular topic's movie, you may be able to use the "Go Back One Page" arrow button on your browser to get back here after viewing the movie.  If not, simply re-address it on your browser.

Install Working Level of Adobe Flash Player  Some recent releases of the Adobe Flash Player cause distorted sound on CBDB Movies.  Downloading and installing this level should allow the Movies to play properly.  The flash player is actually used by MS Internet Explorer or Mazilla Firefox (preferred) browser.  Click this caption to download to disk and then double click the file name to execute it.
Using Windows Explorer  Windows Explorer (WE) is used constantly in upgrading/updating CBW5, and zipping files for support.  This movie explains how to open WE and how to set the proper parameters in WE for these uses.
Installing Runtime and CBW5 from CD  Shows how to find the contents of the CD, and to use Setup.exe to install the Microsoft Runtime Access 2002, and SetupCBDB.exe to install CBW5.mde.
The Calendar Form   CBW5 uses dates called "Current Date", "Current Month" and "Current Year".  All are set via the Calendar form, and are needed for dated transactions or "reports".  This shows how it works.
Report Selector shows how to identify, locate, preview, and print reports by first selecting the type of report and then the specific report of that type. 
 

License Status Form   shows how the LSF is used to advise demonstration users of the remaining time on their 60 day trial and how to enter the License Key when it is received.
The Main Switchboard shows how to navigate between switchboards and the forms that are used to enter data or execute transactions.
Navigating Within Forms  explains the conventions used in CBW5 to move around in forms, the various objects on forms and how they are used.  These conventions, when understood, simplify usage of CBW5 and prevent inadvertent error conditions.
Family Data  shows how the family record form is laid out, and linkages it creates to sub forms relative to each family and family record.  
Members Data explains how members are linked to families, but can be looked at separate from their families.  Rules for entering types of data.  
Activities shows how to create a table of the activities (programs) supported by the church, and how to link members with those activities, and the activities with members.
Pledges - General    explains the details of entering pledges for General Operations support, including required date settings and copying if current year pledge.
Pledges - Building Fund  explains how Building Fund pledges are set up and recorded to track multi-year pledge drives.  How to close one building fund and start another.
Envelope Number Assignment shows how to assign envelope numbers to family units, and how to bring forward, if desired, last year's envelope number assignment to this year.
 

Accounting – Chart of Accounts demonstrates the hierarchy of Assets, Funds (Liabilities) and Income (Expense) accounts, and how each of the lower levels links itself both with its parent account and its purpose, i.e. what type Income/expense it is. 
Asset Accounts  defines Assets as used in CBW5, explains what information is needed, and how to establish original opening balance as sum of the Funds and Liabilities included in the Asset.
Fund Accounts  defines Funds as logical subdivisions of Assets, and demonstrates how to establish the linkages to Assets and MegaFunds, and provide for the Income and Expense Accounts that will increase and decrease the funds' opening balances.
Liability Accounts explains the two types of liabilities handled by CBW5, and how to link liabilities to the proper Asset, and to Expense and Income Accounts related to the liability.
Income Accounts  demonstrates how to set up a new Income Account, and link it to the correct grouping category and fund.  Also how to specify a user grouping category and establish a budget for that account.
Expense Accounts  demonstrates how to set up a new Expense Account, and link it to the correct grouping category and fund.  Demonstrates how to link capital purchases to affected Fund account.  Also how to specify a user grouping category and establish a budget for that account.
Budgets  shows how to enter budget figures for all income and expense accounts, and spread them over 12 months using a set of spread codes that handles any desired spreading technique from "equal monthly" to "like last year".

Processing Income  demonstrates the use of the Offering Input form and explains how the sequence of fields is managed to make the input most efficient.
Accounts Payable  shows how to use the A/P form to establish or update payables records for bills due. First step in writing checks.
Accounts Payable Monthly Review  shows how to review all payables that are or should be due for payment in the Current Month; how to select or deselect them for check writing, and how to update the due amount if needed.
Check Writing  demonstrates the 3rd step in creating checks on the system.  Shows how to select A/Ps for processing, and how to control check numbering and dating.  Explains error messages you might encounter.
Manual Check Entry demonstrates how to use the Manual Entry of Checks function to enter checks written apart from the CBW5 system; it is based on using the Accounts Payable table records to generate check records in the tChecks table. 
Register of Services  demonstrates use of the DataSheet view of a table to allow you to enter a description and counts for all services, any number per day.  Is not to take place of the manual register, but allows automation of counts for analysis and year-end reporting.
Scheduling – Lectors and LEMs  explains the tables that are used in creation of scheduling Lay Readers and Lay Eucharistic Ministers for all the Sundays in a given year.  Explains the sequence of assignments and how to set up members for the assignments.
Reconciliation of Bank Statement demonstrates the use of the Reconciliation process, and points out how it is to be used, and the structure of the system itself in order to explain why things need to be done as recommended.
 

Backup and Restore  explains the front-end/back-end architecture of CBW5, and shows how to do various levels of backup of the back-end file cbw5_be.mdb; then how to copy the backed-up copy to replace a damaged back-end file.
Capital Purchases  explains and demonstrates how to set up asset, fund, and expense records in order to make capital purchases and have them properly recorded on the books of the church.
Mortgage Payments explains how to set up a new mortgage as a liability, how to process the actual loan amount, and how to set up the repayment of principal and interest.
Prepayment of Next Year Pledge  shows the setup of an income account to handle prepayments, and the transactions in both years required to handle IRS-driven and church-driven requirements.
Prior Year Pledge Payment explains how to handle "December" offerings received in "January". 
Reconciliation of Bank Statement demonstrates the use of the Reconciliation process, and points out how it is to be used, and the structure of the system itself in order to explain why things need to be done as recommended.
Updates and Upgrades - Download demonstrates how to find and download the CBDBUpdate.exe programs, and when necessary, to execute the UpgradeN.mdb program to upgrade the database file cbw5_be.mdb.
Zip and Unzip a File (cbw5_be.mdb)   demonstrates how to zip your cbw5_be.mdb file and send it to ChurchMouse Development for assistance. 

Check Specifications
Export to Word or Excel
Gifts of Stock
In-Kind Donations
Inter-Fund Transfers
Mutual Funds and Broker Accounts
New Computer - Transfer CBW5 to
Non-Cash Donations
Open a New Year in CBW5
Tax Payments - How to Handle
 

Webmaster@chmouse.com
Copyright © 2002, ChurchMouse Development Corp. All rights reserved.
Revised: 01/17/11