This book unlocks the power of Structured Query Language (SQL) in Microsoft Access. It guides the reader through step-by-step examples that use SQL script in Microsoft Access to create tables, add records to tables, and retrieve and manage records using simple to advanced data manipulation techniques including combined queries, joined queries, nested queries, views, and temporary tables. The reader also discovers how SQL script can be implemented within VBA and ASP code. Beginners learn about early forms of data storage, the structure of a relational database, and how to plan the design of a database. The reader will learn how to use a database design technique called normalisation, and will also encounter the ERD data model, which is used to demonstrate how to organise and document data that will be stored in the database. Examples of the one-to-one relationship, many-to-one relationship, and the many-to-many relationship are also discussed. Intermediate Microsoft Access users will learn to use the SQL View interface within Microsoft Access to create simple to advanced SQL queries. They will learn to use SQL script to create a table from the ground up that includes columns with data types, constraints, field sizes, indexes, and default values. They will also learn to use SQL script to insert records into a table and to create customized queries that retrieve records from a single table or multiple tables simultaneously. Other topics include using SQL script to create calculated fields, manipulate strings, compute dates, create temporary tables, create views, and create parameter queries that prompt the user to enter data. The advanced reader will discover how SQL script can be integrated into VBA and ASP code.