Multi tier architecture is the basis for developing top class database applications. This involves separating UI, Database access code, the database, reporting into separate layers. The benefits gained are immense and help you develop sturdy applications and maintain with less trouble.
Do note that it is not necessary that you are an expert to start with multi tier architecture. Also, decide on a particular domain and then build sophisticated applications for the domain. This will make it easier..