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 , you may want to lay […]

Tags: access database deisgn, access database normalisation, buliding an access database, how to build an access database, microsoft access database design

Working with Microsoft Access designing a new database, the question here is what is the core process of the database that you are trying to define? Access Database design is more of an art than a science and common sense will prevail. By taking the time to identify the core process correctly, you will find that additional processes will plug in easily keeping the structure of the system stable and solid enough as time goes by and data volume increases. […]

Tags: access database deisgn, access database normalisation, buliding an access database, how to build an access database, microsoft access database design