What do you think of a 1992 Honda Accord?

I'm thinking of getting one as my first car.

I just wish I had a car

Those things can last forever, although it's a very old car

1992 Honda Accords are very well built, reliable cars. You still really need to take into account that a 23 year old car could possibly need some extensive maintenance, depending on how well the previous owner(s) took care of the car.
If you don't know very much about cars, I suggest having an independent mechanic look over it before you buy it. It usually costs about $50, but it can save you a lot of money. If the owner won't let you do this, then don't buy it.

A 23 year old car is a bad investment especially of you don't know it's history.

It's a poor person piece of sh*t.