This is the most important step and is the process I refer to as Reverse Engineering!
The best way to build the Access database architecture correctly is start with the end result The Reports! by sketching out what reports you want to end up with. After all, database systems are there to serve and we want information please!
As an exercise, if you were migrating from a paper based system or an older database system Continue reading “Microsoft Access Database Design Concept – Step 2 of 7”