For sounds, just find programs that do half of the work for you!
Here are the two sound programs that have helped me the most when I was just starting out:
- SFXR - Random Sound Generation Based Off Of Noise.
- PixiTracker -A minimalistic tracker used to create small chiptune-styled songs. (Requires a tad bit of musical knowledge)
If you have a bit more musical knowledge I would recommend getting something like FamiTracker, it’s a lot less linear.
However I must say that a lot of the musical knowledge you have won’t benefit your game development too much. I’ve been playing Saxophone and Piano for years, but making the music for video games is still a skill I haven’t gained. 
As for art, let me start ranting on this topic.
There are different approaches that can be taken with art.
Approach A:
Focus on programming and leave art as the last thing to worry about. I think a good example of this was the original prototype of Braid (Screenshot here. Left = Original Prototype, Right = Final Game). I personally have nothing against this approach and I believe it’s great for all people who just want to get something going. It’s one strategy I see used in Ludum Dare quite often.
Approach B:
Focus on art and programming simultaneously. This I see used by numerous developers and I believe it is the most popular way to go in this topic. Back when I was much newer to game development as a whole, I was perfectly fine with doing this. Needless to say my games didn’t look that good back then.
Approach C:
Focus on art at the same time as programming, but focus on art vaguely. This is what I’ve recently started doing. Just work on art until you run into certain problems, then fix those problems before release. In my case, I will create all of the sprite-sheets and tile-maps for a level in whatever game I’m developing, but leave things like complex animation for future development. This is all about finding your weaknesses in art and seeing what threshold should be focused on for Art/Programming.
I too get demotivated by this, and I have thought about finding an artist for some of my games, but with my past work in web design, I can confirm that working with an artist is one of the most painful things you will ever come across. :emo:
Hopefully this helped you gain a perspective of the different paths there are to making art in video games. 