You shouldn't have to lift your aquarium. If you thought that was necessary for cleaning, I have good news

. "Cleaning" an aquarium consists of changing out some of the water (not all of it) and maybe vacuuming the substrate. Cycled aquariums rely on beneficial bacteria for most of the filtration, combined with mechanical and chemical filtration provided by the filter.
It's hard (if not impossible) to give general care information since different set-ups and fish species can need drastically different care. I would first decide where you want to place the fish tank, from there you can figure out how large the tank can be. I wouldn't go any smaller than a 20-gallon and a 29-gallon or larger would be ideal. On the other hand, going larger than a 55-gallon could be overwhelming and expensive for a new aquarium owner. The reason I don't suggest small tanks is because they're difficult to keep stable and you can't keep many fish (which is frustrating for new people who want a "community" set-up with all different species). A small mistake can cause a tank crash in a desktop aquarium but not even affect a larger aquarium. You just have more room for error

.
Once you have an idea of the volume you'll be working with, I'd visit a local pet store that has fish on display. DON'T LET THEM SELL YOU ANYTHING. Unless it's a good book or something. Just take a look at the fish and get ideas

. Write down the names of fish you're interested in (or even take pictures) and look them up when you get home. Post on here, too, so people can give you their personal experiences with the species in question. The best way to put together a good aquarium set-up is to pick a species you really like and then build the aquarium based on their needs.
I would also read up on cycling. Most people who have issues with fish didn't properly cycle their aquariums. You can start here:
http://www.paw-talk.net/forums/f77/cycling-a-freshwater-aquarium-43789.html
Cycling sounds like scary chemistry at first but it's really not. You essentially need to "grow" good bacteria before you add fish. This can be as simple as using a product like SafeStart or adding a pinch of fish food to start the process.