Contact Ann Dosen, Community
Relations Manager, for details at 727-384-5200
SQL for Microsoft Access 2nd editionunlocks the power of Structured Query Language (SQL) in
Microsoft Access. It guides the reader through step-by-step examples of
creating a database in Microsoft Access using SQL script to create tables,
add records to tables, and retrieve and manage records using simple to
advanced data manipulation techniques including queries and views. The reader
also encounters examples of integrating SQL script into VBA and ASP code.
Explore the relational
database structure and the basics of SQL.
Learn how to insert,
retrieve, and filter records.
Understand how table
joins, unions, and subqueries are used to retrieve records from multiple
tables.
Learn how to use views
and temporary tables.
Discover how to prompt
the user for information with parameter queries.
Find out how SQL can
be used to enhance Active Server pages.
Test your knowledge
through the end-of-chapter quizzes and projects.
About the Authors
Cecelia L. Allison wrote and facilitates an on-line SQL course (Introduction to SQL) that is offered on-line
through hundreds of accredited colleges, universities, and other accredited
educational facilities around the world. She is an experienced software
tester and technical support specialist with many years of hands-on
experience using and teaching SQL. Mrs. Allison is also a freelance Webmaster
and the author of SQL Simplified: Learn to
Read and Write Structured Query Language and SQL for Microsoft Access 2nd edition. She teaches
on-line technical courses for ITT
Technical Institute and Park
University. Mrs. Allison holds a Bachelor of Science in Finance
and a Master of Science in Computer Information Systems.
Neal Berkowitz is a computer consultant, author, web designer,
system analyst, and computer builder with 25 years of experience. An
acknowledged Access expert in the Dallas area, he has co-authored four books
for Wordware and written a number of articles.
