Rather than messing around with the preamble, if simple Author-year citations is all you need they can be configured in the document settings.

If you need more customization than that you should probably start looking at biblatex. That however is not straightforwardly integrated into Lyx and if you intend to customize you'll need to know at least some basic (La)Tex.