I have 1 large database in excell that I am importing into access 2010, If I wanna make a query and find out a specific thing in the database should I break up my database or can I just make a query from the single database, if so what would be the easiest way of doing this?, also if I did need multiple databases would I need to duplicate some columns for primary keys?
Thanks
Thanks