Database
Online Database Systems (Cloud/CRM)
List of known off the shelf / online database systems. Also see Non-profit database Capsule CRM (John BNI) Dalia recommend too $18/user/month Insightly free Airtable.com and monday.com found in 2019. Task management. Sync devices. Membee – membership and event management Not For Profit Easy – used by Bats Theatre. Donor Management, Volunteer Management, Fundraising, Event and […]
10 Things we LOVE about Access 2013
http://accessexperts.com/blog/2012/08/20/10-things-we-love-about-access-2013/ Microsoft Access 2013 is out and both Ben and have been experimenting with it for sometime now. Here are 10 things we love about the new Access web services: 1. It’s SQL Server-based. (Ben) It used to be that Access had its own database engine, known originally as JET and now called ACE. We could […]
SQL Server 2012 Express Installation Tutorial
http://www.soheib.com/technical-knowledge/sql-server-2012-express-installation-tutorial/ Before we begin the installation process, it is important that you choose the correct version of SQL Server Express. To learn more about which version to download, read the following article and download the right SQL Express version: SQL Express 2012 Versions After downloading the correct version, make sure that you have the right […]
Truncation of Memo fields
http://allenbrowne.com/ser-63.html In Access tables, Text fields are limited to 255 characters, but Memo fields can handle 64,000 characters (about 8 pages of single-spaced text) – even more programmatically. So why do memo fields sometimes get cut off? Queries Access truncates the memo if you ask it to process the data based on the memo: aggregating, de-duplicating, formatting, and so on. Here […]
Access Rich-Text: Which subset of HTML is supported?
http://office.microsoft.com/en-us/access-help/insert-or-add-a-rich-text-field-HA010014097.aspx
Access VBA trick
1. How to ‘hide’ 0 as the chart label, format the label as custom $#,##0_);($#,##0);
Features Supported by the Editions of SQL Server
2012 http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx 2008R2 http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx 2008 http://msdn.microsoft.com/en-us/library/cc645993(v=sql.100).aspx
MySQL Data Types
Properly defining the fields in a table is important to the overall optimization of your database. You should use only the type and size of field you really need to use; don’t define a field as 10 characters wide if you know you’re only going to use 2 characters. These types of fields (or columns) […]
Suppressing Zeros in chart labels
The Problem: Susan’s issue is that not every data point is represented by her sales reps. Here, you’ll notice that Kim has no Service Contracts for the month selected. This not only causes the data label to show ($0), but it also muddles the placement of the Service Contract data label. The Solution: An […]