by Tom Chandler | Jul 4, 2026 | Databases
In January 1776, Thomas Paine published Common Sense — a pamphlet that spread through the colonies like wildfire and helped galvanize public opinion toward independence. Paine was a meticulous communicator. Now imagine he kept a subscriber list in a notebook with...
by Tom Chandler | Jun 30, 2022 | Databases
A Microsoft Access database can have different types of tables including… Local information tablesLocal information tables store, in your local database, information you wish to track. This may include information about employees, clients, products, facilities,...
by Tom Chandler | Feb 10, 2022 | Databases
The problem A client emailed me recently – something terrible was going on with their database. Soon after they opened the database they got an error message “Cannot open any more databases” error #3048. You can read more about it on this...
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...