How to use Access Database as a complex database

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?
