Tables

RelationshipAnatomy

     

Posted in Database

DNS Changer (computer help Ottawa)

Apparently computers that are currently affected by this virus/malware are relying on an FBI service which will be discontinued on Monday. I’m not sure if affected computers are at risk of data loss but they may be at risk of

Posted in Security

Excel Core

If you are an Excel user there is good news! Of all the hundreds of functions in Excel there are only a few that seem to be used frequently. If you know them you practically know Excel. Common Functions: =+-/*()

Posted in Uncategorized

Transferring a blog to Hostpapa.ca

I purchased three years of hosting services from hostpapa.ca a while back. The pricing seemed good and the services looked good. I’ve installed a few Web sites on Host Papa by using their cPanel to install WordPress and it’s seems

Posted in Uncategorized

Splitting a string using Split function

I made a quick program to separate the first and last name fields. It was able to grab the middle name as well. I had just finished the blog post and I realized that there was a much quicker way

Tagged with:
Posted in Database

Separating first name and last name

I did a quick blurb on how to change data programmatically in Access. This program took a full name (entered into a field called “Alias”) and separated the first and last name and placed them in their respective fields. Here

Tagged with:
Posted in Database

Programmatically changing data in Access

I wanted to pull together some fun test data for a membership database. I did a search for a list of famous people and found this list (copy of it). I took the table below and pasted the names into the

Tagged with:
Posted in Database

Merging two or more PDF files

Here’s a great site that does this for you automatically. FoxyUtils For those of you who are more technical here is some more info.

Posted in End User

Is your computer backed up?

This is an important issue that is overlooked by many. If you don’t backup your files you will loose them some day. Storage systems and computers break down and it will take your data with it. If you are not

Tagged with:
Posted in Methodology

Computer programming slang!

Have a look at this link on computer programming slang! Apparently I use “Egyptian Braces”.

Posted in Uncategorized