skip to Main Content

Blog

Macros Are Fast Like A Cheetah.

What is a macro?

I hate doing tedious work. Why should I spend minutes or even hours repeating the…

read more

Changing Case

Have you ever had a list where EVERYTHING WAS ACCIDENTALLY ENTERED IN UPPER CASE? oR…

read more

Valentine’s Day Templates

This coming Sunday, February 14, 2021 is Valentine’s Day. Two precious things happen every year…

read more
Calendar Of April 2021

Excel’s April Fools joke
or How to sort month names in Excel

If you sort a list of month names in Excel, will January or April be…

read more
Database

What is a database?

Q:     What is a database? A:      A simple definition of a database…

read more

How to fix a broken Access database link

What causes a broken link? As discussed in What is a split database, a well…

read more
Split Database

What is a split database?

Divide and Conquer This Thursday is Thanksgiving in the US. There will be much to…

read more
Picture Of Abraham Lincoln

Lincoln’s Thanksgiving Day Proclamation

Thanksgiving is coming... The Thanksgiving Holiday in the US is a week from Thursday. I…

read more
Thank You

Happy Thanksgiving

Although it has been a crazy year, we still can take time to consider the…

read more

Input Masks: Face Masks for Data

What is an input mask? An input mask is like a face mask. A face…

read more
Farmer's Field

What is a field?

According to the Oxford dictionary a field is “an area of open land, especially one…

read more

Access Database Objects

Where did that name come from? As you work with computers, you come across terms…

read more
The Declaration Of Independence

A Key to Getting Through Hard Times

Declaring Independence Today is July 2, 2020. Contrary to popular belief, July 2, 1776 is…

read more
Woman Hand With Pen Writing On Notebook

Automated Actions

Logging Events How do you keep track of the things you are supposed to do?…

read more
Students

Student Learning Preferences

Have you ever had the pleasure of trying to stay awake while the professor delivers…

read more
Fill In The Blanks Spreadsheet - Before And After

Quickly fill in the blanks

Have you ever had a need to quickly fill in the blanks of a spreadsheet?…

read more

The wonders of Ctrl G

When I teach an Introduction to Excel course, I challenge my students to a race,…

read more
Excel Quick Reference Card

Learning Shortcuts

There is a debate about whether Mickey (the mouse) is quicker than the Qwerty (the…

read more

Compact and Repair an Access Database

The Problem Access databases are designed to grow as they are used.  As additional records…

read more
Back To Top