splitting the table into two or three

[vasu1211]

We have a huge freight database - ms access in our organization and pretty much all the data is in one table- like about 1.3 million records. Three of us use that database and work with queries, forms and reports. When I say database, it is pretty much one table. My question, is it better to split that table into two or three. Will the database be faster and efficient? what are the other advantages.
Thanks for some insights

 

[GrahamHills]

Can you index the table to make it more efficient?

 

[Remou]

Have you looked at Tools->Analyse->Table?