When we import (or “dump”) database records into a new MS Access database, so-called “migration” issues arise. Bearing in mind the old “GI-GO” (garbage-in, garbage-out) principle, the MS Access user must take great care and be on the lookout for potential data conversion problems.
Is it time for you to learn database programming? Maybe you have a wealth of data, but it is languishing on unwieldy spreadsheets or in Word files. This is Part 1 of a 5-part series on MS Access Database structure.
If you have been keeping large spreadsheet tables of data that have gone wide and deep, it may be time to switch to a database. The power and the flexibility of the database application are worth the steepened learning curve.