Application with access database

Question

I am building something like (shop) application. All products are stored in database, and when the seler sels something, it is also writen in database in different table. for example
one table for all products (articles) named tblArts, and other table for every sale in tblSales
tblArts contain this columns (art_id, art_name, art_price...) 

tblSales contain this columns (sale_id, seller_name, sale_price, sale_date...)
now we know that first table (tblArts) almost never change since you enter all articles.. (maybe one in a week adding a few more.. ) but however it probably not be containing more tnat  2 000-3 000 records.. 
but the other table (tblSales) fills rapidly (it will probbably grow for 200-300 records every day) so my question is what aproach you thing is the best for doing this..

since there would be queryes like ("Select * from tblSale where saler_name = ? and sale_date between ? and ?" after few monts (not to mention years) of using, this application would perform this query very slow..
i was thinking to use different table for let's say every year.. but would it solve the problem?? every year exequte query for creating table, where the name of the table contains the current year...  what do you think???

any sugestions would be wellcome
i am using c# programing language, and access database ( i am limited with time and since i don't have experience with sql databases yet, for this project i must stick with access database), and i also would like to know if sql would do it faster so i start learinng it for future projects  
thank you