Database creation help

Hello,

I am currently building a website that allows agents to manage all of their clients' information. With the database I'm building, I will obviously want a table for clients and a table for agents. Although the agents table only needs like 10 fields, my clients table is looking like it could hold about 500 fields of info about each client. I'm new at databases, but I'm pretty sure that that is a crazy amount of fields to have for a table, so in order to get the most efficient database possible, I'm asking how you would organize this information.

Added info: there will be 6 large forms that will input all of the client info into the database, so perhaps a solution is to break the clients table into 6 tables?

I am very appreciative of any help! Thanks

elisha