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...
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...
