by Tom Chandler | Aug 28, 2026 | Databases
Open an unfamiliar database and you can usually tell within thirty seconds whether the person who built it thought about naming. Tables called “Table1,” queries called “Query3,” and a report saved as “Copy of Copy of Report” are a...
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...
