Books aren't written to accommodate ones business-requirements. There are a bunch of video's and how-to's on MSDN, that'd might be a useful introduction into the specific topics you request. I'd recommend "Head on C#", but it's not about VB and not about Access.
I am a VB.Net programmmer. I use the SQL Server and as backend but when I deploy my application to another computer, It is required the SQL Server must be installed on another computer. Please suggest how to work with SQL database (.mdf,.ldf) without installing SQL Server on another computer becuase I cannot go everywhere for each computer to install the application If user of my application is just simple user. If there is another solution, please let me know. I will be very thankful to him/her.