Sql for Ms Access

This book unlocks the power of Structured Query Language (SQL) in Microsoft Access. It guides the reader through step-by-step realistic examples on how to create a database in Microsoft Access, how to use SQL script to create tables, how to add records to tables, and how to retrieve and manage records using simple to advanced data manipulation techniques such as combined queries, joined queries, nested queries, and views. The reader also encounters examples on how to integrating SQL script into VBA and ASP code.