standalone client - client connects to local db. gui is used.
network connected client - client connects to the remote server. gui is used.
server - remote(or virtually remote) server starts up. Database exists here too. This mode of operation only starts the server and no GUI is used.
Am I catching on now or am I still a million miles off?