Page Tools:

SQL for Microsoft Access, Second Edition

Author(s): Cecelia L. Allison, ITT Technical Institute and Park University
Neal A. Berkowitz, web designer
Details:
  • ISBN-13: 9781598220605
  • ISBN-10:1598220608
  • Paperback    374 pages      © 2008
Price: International Sales $49.95 US List
Add to Cart Request a Review Copy

Overview

SQL for Microsoft Access, Second Edition provides a guide to getting the most out of Microsoft Access through the use of Structured Query Language. Step-by-step examples demonstrate how to use SQL script to create tables, add records to tables, and retrieve and manage records. Readers will also learn about calculated fields, Access projects, and the integration of SQL script in VBA and ASP code.

  • Explore the relational database structure and the basics of SQL.
  • Understand how table joins, unions, and subqueries are used to retrieve records from multiple tables simultaneously.
  • Learn how to filter records and group data.
  • Discover how to create parameter queries that prompt users for data.
  • Test your knowledge and comprehension with the end-of-chapter quizzes and projects.

ShowKey Features

Explore the relational database structure and the basics of SQL.

Understand how table joins, unions, and subqueries are used to retrieve records from multiple tables simultaneously.

Learn how to filter records and group data.

Discover how to create parameter queries that prompt users for data.

Test your knowledge and comprehension with the end-of-chapter quizzes and projects!

Back to top

ShowAbout the Author(s)

Cecelia L. Allison-ITT Technical Institute and Park University

Cecelia Allison is an author and on-line professor. Her background as a software tester and technical support specialist has given her extensive hands-on experience using SQL. She wrote and facilitates an on-line SQL course titled “Introduction to SQL” (www.iwanttolearnsql.com) that is offered through hundreds of educational facilities, and also teaches on-line technical courses for ITT Technical Institute and Park University. She holds a bachelor’s degree in finance and a master’s degree in computer information systems.

Neal A. Berkowitz-web designer

Neal Berkowitz is a consultant, author, web designer, and system analyst and architect, with more than 25 years of experience covering all aspects of computers. An acknowledged Access expert in the Dallas area, he has co-authored six books for Wordware and published numerous articles on computing and software.

Back to top

ShowSamples & Additional Resources

Back to top

ShowResources

Back to top