SQL for Microsoft Access (Wordware Applications Library) - Softcover

Allison, Cecelia L.; Berkowitz, Neal A.

Softcover

ISBN 10: 1598220608 ISBN 13: 9781598220605

Publisher: Jones & Bartlett Learning, 2008

Synopsis

SQL for Microsoft Access (2nd 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.

About this title

About the Author

Dr. Cecelia L. Allison is a published author, technical writer, and an online professor. She writes and facilitates on-line SQL courses (Intro. & Intermed. SQL) that are offered on-line through hundreds of accredited colleges, universities, and other accredited educational facilities world wide.

She wrote SQL Simplified: Learn to Read and Write Structured Query Language and SQL for Microsoft Access 1st and 2nd edition. She also facilitates on-line technical courses for several colleges on-line.

Dr. Allison has been using SQL for over 15years. Through her past and present employment as a technical specialist and software tester she has gained extensive experience in writing and implementing SQL. She holds a Bachelor of Science in Finance, a Master of Science in Information Systems, and a Doctor of Business Administration in Management Information Systems.
SQL COURSES

Introduction to SQL: ed2go.com
Intermediate SQL: ed2go.com
ADDITIONAL COURSES

ITT Technical Institute: itt-tech.edu
Park University: park.edu
YOUTUBE VIDEOS

How to find "SQL VIEW" in Microsoft Access:
youtube.com/watch?v=DM-3DD7nyNY

Create Parameter Queries in Microsoft Access (SQL View):
youtube.com/watch?v=jxhiLZGt4FA

How to Execute SQL Script in SQL Server 2012:
youtube.com/watch?v=iLa_hKS6wK4

Synopsis of SQL for Microsoft Access 2nd edition:
youtube.com/watch?v=jzCpyyHFzCA

Edition details

• Publisher: Jones & Bartlett Learning
• Publication date: 2008
• ISBN 10: 1598220608
• ISBN 13: 9781598220605
• Binding: Paperback
• Language: English
• Edition number: 2
• Number of pages: 374