Structured Query Language (SQL) is the industry standard database programming language. It is
used to create databases, manipulate and retrieve data, and to provide
security for relational databases. Some of the more popular Database
Management Systems (DBMSs) that implement SQL include Microsoft Access,
Microsoft SQL Server, Oracle and MySQL. If you manage data or plan to work in
a field managing data, you should make learning SQL a priority.
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.
Click
hereto "obtain the SQL script" to create the
tables used in the book.
Note: SQL for Microsoft Access 2nd edition is also
available at Barnes and Noble.It is also available through most on-line bookstores. For example, www.amazon.com and
www.barnesandnoble.com
About the Authors
Dr. 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 worldwide. She is an experienced software
tester and technical specialist with many years of hands-on
experience using and teaching SQL. Dr. Allison is 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 Park University.
Dr. Allison holds a Bachelor of Science in finance, a Master of Science in information systems, and a Doctor of Business Administration in management 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.
