In other words, this Church Records Manager job came by way of repeat business.<\/em><\/strong><\/h3>\nI actually up-sold the idea to him while we were working on the database project, and he mentioned challenges he was having using a\u00a0large unwieldy\u00a0MS Excel spreadsheet to handle the different church records in his spare time.<\/em><\/p>\nThis client remains\u00a0a friend (and mentor of sorts) today.<\/p>\n
Last year, when I paid him a visit in his office, he requested my help in resetting the app for use in the Church office, following some changes to the computer setup there.<\/p>\n
In building the app, I'd worked closely with him (and the\u00a0church's office staff).<\/p>\n
To meet their requirements, I recall clearly is that my habit of keeping a \"black box\" or reusable code from other projects I'd done, turned out to be a huge time saver. <\/strong><\/h3>\nEach time they requested for a particular feature, I often found that it was related to one that I'd taken care of in a previous client's project, and so I only needed to make slight modifications to adapt it to suit their needs.<\/p>\n
From generating automated notifications and reminders of members' birthday anniversary celebrations, to allowing dynamic query of the database (using various field parameters), to enabling tracking of bank related handling of church monies for reconciliation - and more.<\/p>\n
Due to budget limitations, my modeless floating dynamic menu driven data entry forms (like the ones in my\u00a0Bank Transactions Monitor (BTM) \u2122Excel-VB Driven App<\/a>) could not be incorporated into it, to reduce manual data entry effort required.<\/strong><\/p>\nThat notwithstanding, this basic app's novice-proof GUI design\u00a0made it unnecessary for the user to be Excel savvy. Typically, as is the case with my other apps a user could get started using it competently within a few hours of interaction.<\/p>\n
The screenshots below highlight some of the key\u00a0interfacess in the app<\/em><\/p>\n1. This is the Splash Screen that shows when the app is opened in MS Excel - after Macros are ENABLED.<\/strong><\/h3>\n![\"crm00\"](\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/08\/crm00.png\")
<\/p>\n
2.\u00a0After the app is fully loaded into MS Excel, this custom login form interface appears. The user is assigned a username and case sensitive password to use.<\/strong><\/h3>\n![\"crm0\"](\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/08\/crm0.png\")
<\/a><\/p>\n3. Once logged in, this Main Menu appears. <\/strong><\/h3>\nNB: This is a standard feature I found useful to include in all my apps. Very intuitive. Anywhere in the app, this menu\u00a0can be called up by pressing the ENTER key while the cursor is on the spreadsheet. Alternatively, the Main Menu button placed at the top of the spreadsheet interfaces can be clicked to load the menu.<\/em><\/p>\n![\"crm1\"](\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/08\/crm1.png\")
<\/a><\/p>\n4. This is the spreadsheet table formatted to hold up to 50,000 records.<\/strong><\/h3>\nNote that I've also built Excel-VB apps that link to a backend database to retrieve data to be used for trending\/analysis and report generation. However, I've found that clients (mostly individuals\/SMEs) have preferred everything to be in Excel, because they felt their needs were relatively small.\u00a0<\/em><\/p>\n\u00a0<\/p>\n
![\"crm10\"](\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/08\/crm10.png\")
<\/a><\/p>\nBelow: Screenshots of Income and Expense Summary Reports Generated using Drop Menus\u00a0<\/strong><\/h3>\n![\"crm8\"](\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/08\/crm8.png\")
<\/a><\/p>\n![\"crm7\"](\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/08\/crm7.png\")
<\/a><\/p>\n![\"crm4\"](\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/08\/crm4.png\")
<\/a><\/p>\n![\"crm3\"](\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/08\/crm3.png\")
<\/a><\/p>\nBelow: Screenshots of Income\/Bank Lodgement and Expenses\/Bank Withdrawals Tables\u00a0<\/strong><\/h3>\n![\"crm5\"](\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/08\/crm5.png\")
<\/a><\/p>\n\u00a0<\/p>\n
![\"crm2\"](\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/08\/crm2.png\")
<\/a><\/p>\nBelow: Dialog box shows the user lodgement details picked by the app for posting into the column for the selected bank account. A reconciliation table is auto-updated and used to compare with the bank account balances on a weekly basis.<\/strong><\/p>\n![\"crm6\"](\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/08\/crm6.png\")
<\/a><\/p>\nBelow: Screenshot of simple (print-ready) menu driven query spreadsheet interface<\/strong><\/h3>\n![\"crm11\"](\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/08\/crm11.png\")
<\/a><\/p>\nHow to get this Church Records Manager FREE?<\/strong><\/h3>\nClick here to request details<\/a><\/p>\n================================<\/p>\n
GET BUILT-IN MS EXCEL SOLUTIONS DEVELOPMENT<\/strong><\/h3>\nSelf-Development Academy (SDAc)\u2019s Excel Heaven\u2122 was founded by Tayo K. Solagbade in 2002, as the FIRST provider of On-Demand Preprogrammed Custom Spreadsheet Solutions for individuals and businesses in Nigeria\/Africa.<\/p>\n
We offer Workbook Auditing\/Optimisation and VBA Automation; Custom Spreadsheet Software Development; Sales; Job-Based Spreadsheet Coaching; and Consulting\/Advisory Services on effective application of spreadsheets for business use.<\/p>\n
Call +234-803-302-1263 (in Nigeria) or +229-66-122-136 (in Benin).<\/strong><\/p>\nSee video demos here<\/a>.<\/p>\nVisit our Excel Heaven mini-site : here<\/a>.<\/p>\n[Invitation] Join Tayo\u2019s Excel Heaven Visual Basic Automation Club:<\/h3>\n
This client remains\u00a0a friend (and mentor of sorts) today.<\/p>\n
Last year, when I paid him a visit in his office, he requested my help in resetting the app for use in the Church office, following some changes to the computer setup there.<\/p>\n
In building the app, I'd worked closely with him (and the\u00a0church's office staff).<\/p>\n
To meet their requirements, I recall clearly is that my habit of keeping a \"black box\" or reusable code from other projects I'd done, turned out to be a huge time saver. <\/strong><\/h3>\nEach time they requested for a particular feature, I often found that it was related to one that I'd taken care of in a previous client's project, and so I only needed to make slight modifications to adapt it to suit their needs.<\/p>\n
From generating automated notifications and reminders of members' birthday anniversary celebrations, to allowing dynamic query of the database (using various field parameters), to enabling tracking of bank related handling of church monies for reconciliation - and more.<\/p>\n
Due to budget limitations, my modeless floating dynamic menu driven data entry forms (like the ones in my\u00a0Bank Transactions Monitor (BTM) \u2122Excel-VB Driven App<\/a>) could not be incorporated into it, to reduce manual data entry effort required.<\/strong><\/p>\nThat notwithstanding, this basic app's novice-proof GUI design\u00a0made it unnecessary for the user to be Excel savvy. Typically, as is the case with my other apps a user could get started using it competently within a few hours of interaction.<\/p>\n
The screenshots below highlight some of the key\u00a0interfacess in the app<\/em><\/p>\n1. This is the Splash Screen that shows when the app is opened in MS Excel - after Macros are ENABLED.<\/strong><\/h3>\n<\/p>\n
2.\u00a0After the app is fully loaded into MS Excel, this custom login form interface appears. The user is assigned a username and case sensitive password to use.<\/strong><\/h3>\n<\/a><\/p>\n3. Once logged in, this Main Menu appears. <\/strong><\/h3>\nNB: This is a standard feature I found useful to include in all my apps. Very intuitive. Anywhere in the app, this menu\u00a0can be called up by pressing the ENTER key while the cursor is on the spreadsheet. Alternatively, the Main Menu button placed at the top of the spreadsheet interfaces can be clicked to load the menu.<\/em><\/p>\n<\/a><\/p>\n4. This is the spreadsheet table formatted to hold up to 50,000 records.<\/strong><\/h3>\nNote that I've also built Excel-VB apps that link to a backend database to retrieve data to be used for trending\/analysis and report generation. However, I've found that clients (mostly individuals\/SMEs) have preferred everything to be in Excel, because they felt their needs were relatively small.\u00a0<\/em><\/p>\n\u00a0<\/p>\n
<\/a><\/p>\nBelow: Screenshots of Income and Expense Summary Reports Generated using Drop Menus\u00a0<\/strong><\/h3>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\nBelow: Screenshots of Income\/Bank Lodgement and Expenses\/Bank Withdrawals Tables\u00a0<\/strong><\/h3>\n<\/a><\/p>\n\u00a0<\/p>\n
<\/a><\/p>\nBelow: Dialog box shows the user lodgement details picked by the app for posting into the column for the selected bank account. A reconciliation table is auto-updated and used to compare with the bank account balances on a weekly basis.<\/strong><\/p>\n<\/a><\/p>\nBelow: Screenshot of simple (print-ready) menu driven query spreadsheet interface<\/strong><\/h3>\n<\/a><\/p>\nHow to get this Church Records Manager FREE?<\/strong><\/h3>\nClick here to request details<\/a><\/p>\n================================<\/p>\n
GET BUILT-IN MS EXCEL SOLUTIONS DEVELOPMENT<\/strong><\/h3>\nSelf-Development Academy (SDAc)\u2019s Excel Heaven\u2122 was founded by Tayo K. Solagbade in 2002, as the FIRST provider of On-Demand Preprogrammed Custom Spreadsheet Solutions for individuals and businesses in Nigeria\/Africa.<\/p>\n
We offer Workbook Auditing\/Optimisation and VBA Automation; Custom Spreadsheet Software Development; Sales; Job-Based Spreadsheet Coaching; and Consulting\/Advisory Services on effective application of spreadsheets for business use.<\/p>\n
Call +234-803-302-1263 (in Nigeria) or +229-66-122-136 (in Benin).<\/strong><\/p>\nSee video demos here<\/a>.<\/p>\nVisit our Excel Heaven mini-site : here<\/a>.<\/p>\n[Invitation] Join Tayo\u2019s Excel Heaven Visual Basic Automation Club:<\/h3>\n
That notwithstanding, this basic app's novice-proof GUI design\u00a0made it unnecessary for the user to be Excel savvy. Typically, as is the case with my other apps a user could get started using it competently within a few hours of interaction.<\/p>\n
The screenshots below highlight some of the key\u00a0interfacess in the app<\/em><\/p>\n NB: This is a standard feature I found useful to include in all my apps. Very intuitive. Anywhere in the app, this menu\u00a0can be called up by pressing the ENTER key while the cursor is on the spreadsheet. Alternatively, the Main Menu button placed at the top of the spreadsheet interfaces can be clicked to load the menu.<\/em><\/p>\n Note that I've also built Excel-VB apps that link to a backend database to retrieve data to be used for trending\/analysis and report generation. However, I've found that clients (mostly individuals\/SMEs) have preferred everything to be in Excel, because they felt their needs were relatively small.\u00a0<\/em><\/p>\n \u00a0<\/p>\n \u00a0<\/p>\n Below: Dialog box shows the user lodgement details picked by the app for posting into the column for the selected bank account. A reconciliation table is auto-updated and used to compare with the bank account balances on a weekly basis.<\/strong><\/p>\n Click here to request details<\/a><\/p>\n ================================<\/p>\n Self-Development Academy (SDAc)\u2019s Excel Heaven\u2122 was founded by Tayo K. Solagbade in 2002, as the FIRST provider of On-Demand Preprogrammed Custom Spreadsheet Solutions for individuals and businesses in Nigeria\/Africa.<\/p>\n We offer Workbook Auditing\/Optimisation and VBA Automation; Custom Spreadsheet Software Development; Sales; Job-Based Spreadsheet Coaching; and Consulting\/Advisory Services on effective application of spreadsheets for business use.<\/p>\n Call +234-803-302-1263 (in Nigeria) or +229-66-122-136 (in Benin).<\/strong><\/p>\n See video demos here<\/a>.<\/p>\n Visit our Excel Heaven mini-site : here<\/a>.<\/p>\n1. This is the Splash Screen that shows when the app is opened in MS Excel - after Macros are ENABLED.<\/strong><\/h3>\n
<\/p>\n2.\u00a0After the app is fully loaded into MS Excel, this custom login form interface appears. The user is assigned a username and case sensitive password to use.<\/strong><\/h3>\n
<\/a><\/p>\n3. Once logged in, this Main Menu appears. <\/strong><\/h3>\n
<\/a><\/p>\n4. This is the spreadsheet table formatted to hold up to 50,000 records.<\/strong><\/h3>\n
<\/a><\/p>\nBelow: Screenshots of Income and Expense Summary Reports Generated using Drop Menus\u00a0<\/strong><\/h3>\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\nBelow: Screenshots of Income\/Bank Lodgement and Expenses\/Bank Withdrawals Tables\u00a0<\/strong><\/h3>\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\nBelow: Screenshot of simple (print-ready) menu driven query spreadsheet interface<\/strong><\/h3>\n
<\/a><\/p>\nHow to get this Church Records Manager FREE?<\/strong><\/h3>\n
GET BUILT-IN MS EXCEL SOLUTIONS DEVELOPMENT<\/strong><\/h3>\n
[Invitation] Join Tayo\u2019s Excel Heaven Visual Basic Automation Club:<\/h3>\n