by Tom Chandler | Apr 25, 2021 | Databases
One rule of database design is to make your fields atomic. This article discusses what an atomic field is, and why it’s important. What is an atom? First, let’s talk about atoms. In physics, an atom is the smallest unit of ordinary matter. We used to think atoms could...
by Tom Chandler | Apr 15, 2021 | Databases
Q: Data Relationships, what does that mean? A: It means data, usually in a database, can be related to other data in the database. Q: Really? How can data in a database be related to other data in a database? Are you saying one piece of data can begat another piece of...
by Tom Chandler | Apr 8, 2021 | Databases
What is a table?A table is an object that holds things. For example, a kitchen table hold things like plates, cups, and other things we use to eat our food. What is a database table?A database table also holds things. A database table holds data. How is the data...
by Tom Chandler | Jan 26, 2021 | Databases
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...
by Tom Chandler | Dec 8, 2020 | Databases
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...
by Tom Chandler | Nov 25, 2020 | Databases
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,...
