|C) Due to my lack of experience, my preference as of now is non-OO style, unless this is unwise|
Due to my lack of experience posting on computing.net, I will never post on Computing.net. Also, all three languages you specified are OO. Finally, you might want to look at C#, or one of the other .NET languages.
D) Due to my lack of experience, I think I need all the help I can get from a development environment
IDEs are nice tools, but they aren't crutches. After all, what use is a list of functions if you don't know what they do? Most of them cost, too. Visual Studio Express is one of the best C/C++ IDEs, but I don't think its license allows you to sell whatever it builds. The Pro version is $800, and that doesn't include an upgrade to VS 2010 (currently in Beta).
E) I'm looking for a really good looking gui, preferably not "Windows" looking. If possible I'd like to be able to choose the color pallet and fonts, etc. If possible, please tell me where to view screenshots for any suggestions?
With Java, I think you'll be stuck with the Java GUI. How robust its controls are, I don't know. With C++, you can make it look however you want, but GUI building will take the longest. I know Python has many GUI frameworks; perhaps one of them could work for you.
F) From what I can tell, SQL Express or SQLite would be good, free back-ends, and have licenses that would allow me to sell the product
SQLite is public domain; many countries, including the USA, do not legally recognize public domain. I doubt the authors of SQLite will ever sue, but it's an interesting bit of trivia, no?
Anyways, it's a moot point; you already said its DB backend would be Access. Also, I don't know what the commercial license of Access looks like, so you'll want to get with a lawyer before selling something Access backed.
G) I'm not and don't anticipate ever working in a computer related field (so experience for experience's sake isn't a high priority)
Prepare for much frustration, especially if you go the C++ route.