Could someone please explain to me how I can use Access as a complex database and can it support complex datatypes? What are the other databases that can be used to complement Access and get a high quality complex database that can deliver on a large scale organization and yet complex data type?
I think what you need is a much larger scale database and not the Microsoft Access programs because it is more easy to use but don't have those complexity that you need so I suggest that you move from Microsoft Access to SQL Server or Oracle. These are the programs that will provide you with the complexity that you need and also it has more data types than the Access and there is what you cal T-SQL that only this programs can support.
If you have so much data in your company, it will be hard to sort and store in groups. So its much better to create a system which is more understandable to use.
