For the macro shots your probably getting to close to your subject. I would look at the camera's manual to see what the minimum focusing distance is and try not to go any closer to your subject or it will continue to be out of focus. Love your aquarium. Your going to have some awesome photo op's in the coming months.
14 gal biocube salt
1 orange zoo polyp colony, 2 toad stool (small), 1 umbrella leather (large), 2 pulsing xenia, 1 star polyp colony, 7 blue mushrooms, snails, pep. shrimp, 3 blue legged hermits, 2 onyx percula clowns