What is a database?

What is a database?

What is a database? A simple definition of a database is a collection of organized data. So, by that definition, if you throw your receipts into a shoe box, is that a database? Well, it is a collection of data, but it is not really organized, so no it is not a...
How to fix a broken Access database link

How to fix a broken Access database link

What causes a broken link? Step-by-step: How to relink the database using Access 365 / 2019 Start Microsoft Access 365 / 2019 Open the front-end database. If you get an error message, just click OK. On the ribbon, select External Data, Linked Table Manager. Check the...
What is a split database?

What is a split database?

Divide and Conquer This Thursday is Thanksgiving in the US. There will be much to do. Someone has to prepare the turkey, and then someone has to cook it.  Someone has to wash and peel potatoes before they are mashed and cooked. Then there’s the cranberry sauce,...
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...