Why Not Use MS Access?
Apr 22, 2022 18:59:41 GMT -8
Post by Uncle Buddy on Apr 22, 2022 18:59:41 GMT -8
Here's why not:
Microsoft Access Genealogy Database. Track Ancestry. Build a Family Tree. Self Join.
Don't get me wrong. The video is excellent. Very lucid. If I were going to use Access to create some genieware, I'd watch all his videos. The only genieware I ever liked (Genbox) was built in such a way as to be compatible with Access. (That's all I know about Genbox' code.)
Watching this video on how to get started making genieware with Access... made me glad I gave up Access long ago and learned to write SQL from scratch instead. In the video you will see 10% SQL-related stuff and 90% stuff you would never need to know if you didn't have to learn a bunch of extra stuff in order to work around your unwillingness to learn SQL.
The short version: it's easier to learn SQLite, Python and Tkinter than it is to learn MS Access. And once you do learn to write your own database and its GUI, you are in control of the final product, how it looks, and how it works.
The best part is that Python, SQLite and Tkinter are all open-source, totally free programs, while Access comes to us, not freely, from... well... the usual suspects.
You can't use Access well to do anything complex without learning what SQL does and how SQL does it. That's why I feel that Access is not an advantage for doing complex projects. Once you understand SQL, why not just use it directly?
Microsoft Access Genealogy Database. Track Ancestry. Build a Family Tree. Self Join.
Don't get me wrong. The video is excellent. Very lucid. If I were going to use Access to create some genieware, I'd watch all his videos. The only genieware I ever liked (Genbox) was built in such a way as to be compatible with Access. (That's all I know about Genbox' code.)
Watching this video on how to get started making genieware with Access... made me glad I gave up Access long ago and learned to write SQL from scratch instead. In the video you will see 10% SQL-related stuff and 90% stuff you would never need to know if you didn't have to learn a bunch of extra stuff in order to work around your unwillingness to learn SQL.
The short version: it's easier to learn SQLite, Python and Tkinter than it is to learn MS Access. And once you do learn to write your own database and its GUI, you are in control of the final product, how it looks, and how it works.
The best part is that Python, SQLite and Tkinter are all open-source, totally free programs, while Access comes to us, not freely, from... well... the usual suspects.
You can't use Access well to do anything complex without learning what SQL does and how SQL does it. That's why I feel that Access is not an advantage for doing complex projects. Once you understand SQL, why not just use it directly?