Sorry, that is incorrect. Your "unbound system" will definitely NOT improve data quality and security and most likely will do the opposite. Pretty much guarantee that. Access is designed to manage data using bound forms. They have put a lot of functionality into this design. It has been doing this well for 30 years (as of last month). So I doubt you are going to be the guy that finally comes up with some magical way to do this better.I will have more work to develop the unlinked system, however, it is to guarantee the quality and security of the information as well.
I've also read, that using classes facilitates this approach.
would use Classes to define and assign methods and procedures for certain records.
Ex.:
A Customer Registration form would use a Customer Class, and this class would contain all the methods, properties and procedures of this registration.
Classes are a way to organize the system too and maintenance is easier to do too.
I believe that working with classes is more for an intermediate/advanced level, but if I managed to be a doctor, I don't think I'm a 7-headed animal to learn.
but if I managed to be a doctor,
TBF, pretty good analogy.MajP
“Instead of wasting your time going in this direction, learn how to build the most functional bound form that ensures data integrity and provides a good user experience. Seems like you do not know how to drive a car yet, but you want to start by racing a Formula One vehicle.”
what would be a good start of learning for this?
thank you for the tips.
When I worked tech support for a large media provider here in the UK, I took a call from a doctor.
She could not get online, hence the call.
Now the first thing we were told to do, was disable the firewall, but she would have none of it.
So i tried other methods, to no avail, eventually I had to say, 'we will have to disable your firewall', which we then did.
Lo and behold, she could get on ther internet.
Only then does she mention that she got a Norton update at 09:30 and since then she had been unable to connect to the internet. ??????
Worst of it all, was my team leader was listening in to the call, and came over to me after the 30 min call, and said to me 'What is the first thing you should have done?' So I got a telling off for that call.
So please, just being a doctor, might make you au faix with medical matters, but logic?, perhaps not so much?
understand.MajP
“Instead of wasting your time going in this direction, learn how to build the most functional bound form that ensures data integrity and provides a good user experience. Seems like you do not know how to drive a car yet, but you want to start by racing a Formula One vehicle.”
what would be a good start of learning for this?
thank you for the tips.
IMO the best resource ever done for Access is the
Access Desktop Developer's Handbook. It was written 20 years ago, but it still is relevant. There will be features that no longer exist or have been improved.
Get it used for cheap (under $20). If you understand the principles in that you will be able to build robust applications.
Access 2002 Desktop Developer's Handbook: 9780782140095: Computer Science Books @ Amazon.com
Access 2002 Desktop Developer's Handbook: 9780782140095: Computer Science Books @ Amazon.comwww.amazon.com
Thanks for explication.I also recommend this site for getting the basics of SQL.
I recommend going through every topic.SQL Tutorial
W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.www.w3schools.com
In the very early days Access suffered from corruption of data, but now that is mostly unheard of. It is not, however, designed to work over a wifi connection to the backend data or a web based repository. There are many things to do, especially in a multi user environment to improve and ensure data integrity, but making unbound forms is not high on the list as a best practice.
This isnt the first time you touted this book, some other AWF Heavyweights have as well. I received mine in the mail today - damn hefty book, almost 3 times the size of the 2010 version.IMO the best resource ever done for Access is the
Access Desktop Developer's Handbook. It was written 20 years ago, but it still is relevant. There will be features that no longer exist or have been improved.
Get it used for cheap (under $20). If you understand the principles in that you will be able to build robust applications.
Access 2002 Desktop Developer's Handbook: 9780782140095: Computer Science Books @ Amazon.com
Access 2002 Desktop Developer's Handbook: 9780782140095: Computer Science Books @ Amazon.comwww.amazon.com