“Cleaning” information before you import it into your database is pretty standard – after all, one of the reasons you’ve started to use a database is so that you can predictably query that database for set criteria right…right? So how you handle...
Read more »Exporting information from Microsoft Access is incredibly easy – assuming you only want to produce a single export file. But what do you do when you need to split a query (or table) into multiple export files? For example, if you need to export a...
Read more »We’ve said it before, but it’s worth repeating - linked tables can be really useful in your databases for a number of reasons. But one big drawback of linked tables is performance – running queries against them, especially if they aren’t Microsoft...
Read more »