Que and qué are not the only words that have accent free and accent version. Check also the difference between si and sí as well as the difference between tú and tu. Que is homophonous with a number of other words, most of which have wildly different spellings and meanings. One of the words that people are looking for when they look up que is queue, a. That, than, that, not translated, that, and, what, who (m), that, that, than, let, that, which, who.
Que can be a relative pronoun used to describe a noun. As a relative pronoun que can be translated as that, which, or who depending on the circumstances: