Approved Workman Database 5.9 - User Guide

Using AWdb to track VBS

Using AWdb to track VBS

Previous topic Next topic  

Using AWdb to track VBS

Previous topic Next topic  

AWdb can be used to track participants and attendance for a summer Bible School or Camp. The Registration Form can be customized for VBS/Camp use. Other reports such as Clubber Lists, Mailing Labels, Name Tags, etc. might also be helpful.

Icon-Tip

For Camp, follow the same instructions below, but substitute "Camp" for "VBS".

To set up the database:

1.Update to the newest version of AWdb.
2.Finish out the current Awana Club Year.

Icon-Warning

Do not proceed setting up VBS until the current club sessions are completed!

3.Go to Admin > Generic Lookups and select Club Years. Add a new record to represent the specific VBS year. For example, use Club Year "VBS 2019", Logical Order one greater than what is shown for the existing 2018-2019 Club Year, and "1" as the Meeting Interval value. Click the check mark at the bottom of the grid to post the new record.
4.Go to Admin > Database Utilities and run the Backup Utility.
5.Click New Year Setup (also under Admin > Database Utilities) and follow these steps:
Step 1a: select "VBS 2019" as the Club Year and enter VBS Starting and Ending Dates.
Step 1b: review/add/edit the specific "Club Names" to use for VBS.  Note: all records should have a Base Club value of "VBS".  Keep in mind that, just like Awana, a specific Grade and Gender can only be assigned to a single specific club name.
Step 2, Promotions: be careful about whether or not to "Promote each clubber's School Grade to the next level".  It's OK to do it for VBS; but if you DO, then DO NOT PROMOTE AGAIN when the New Year Setup is run for the next Awana club year.
Step 3, Club Assignments: select the appropriate Club Name for each Grade and Gender.
Step 4: review each field to decide how to handle each of the resets.
Step 5, click the Begin Processing button to generate the VBS weekly attendance records.