Input Masks: Face Masks for Data

Input Masks: Face Masks for Data

What is an input mask? An input mask is like a face mask. A face mask covers the opening (mouth) that otherwise would allow bad things into the human body. An input mask is similar. It acts like a mask by preventing bad things from being entered into a database field....
What is a field?

What is a field?

According to the Oxford dictionary a field is “an area of open land, especially one planted with crops or pasture, typically bounded by hedges or fences.” A farmer may have many fields; some that grow cotton, others that grow corn, or wheat or potatoes. Some, as shown...
Access Database Objects

Access Database Objects

Where did that name come from? As you work with computers, you come across terms that make you wonder how they got their names. For example, why is the main circuit board of your computer called a “motherboard”? Or why is your computer’s digital...
Automated Actions

Automated Actions

Logging Events How do you keep track of the things you are supposed to do? Do you find that sometimes you do the same important things multiple times because you forgot that you had already done it? Worse, what happens when the auditors, boss, consultant, or mother...
Compact and Repair an Access Database

Compact and Repair an Access Database

The Problem Access databases are designed to grow as they are used.  As additional records are added the database grows.  By design, when records are deleted, the space allocated for those records is not recovered.  Consequently, the backend database...