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 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 worldwide.

She wrote SQL Simplified: Learn to Read and Write Structured Query Language and SQL for Microsoft Access 1st and 2nd edition. She also teaches computer science and information system courses through on-line colleges.

Dr. Allison has been using SQL for over 20 years and has taught over 80,000 students SQL worldwide. Through her past 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.

JAFFA Inc. Computer Learning Center

jaffainc.com

SQL COURSES

Introduction to SQL: yougotclass.org

Intermediate SQL: yougotclass.org

Advanced SQL: yougotclass.org

ADDITIONAL COURSES

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 Open SQL View in Microsoft Access 2013
youtube.com/watch?v=jxtqb9dH8gY

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

"About this title" may belong to another edition of this title.

Store Description

GreatBookPrices.com is your top source for finding new books at the absolute lowest prices, guaranteed ! We offer big discounts - everyday - on millions of titles in virtually any category, from Architecture to Zoology -- and everything in between. Discover great deals and super-savings, on professional books, text book titles, the newest computer guides, or your favorite fiction authors. You'll find it all - at HUGE SAVINGS - at GreatBookPrices. Browse through our complete online product catalog today. Serving customers around the world for years, we help thousands find just the books they're looking for -- at incredibly low, bargain prices.

Visit Seller's Storefront

Seller's business information

Far Corner Europe Limited
19-20 Bourne Court, 19-20 Bourne Court, Woodford Green, IG8 8HD, United Kingdom

Sale & Shipping Terms

Terms of Sale

Company Name: GreatBookPricesUK
Legal Entity: Far Corner Europe Limited
Address: 19-20 Bourne Court, Southend Road, Woodford Green Essex, UK IG8 8HD
Registration #: 10691061
Authorized representative: Danielle Hainsey

Shipping Terms

Our warehouses across the globe are fully operational without substantial delays. We are working hard and continue to overcome the daily challenges presented by COVID-19. There have been reports that delivery carriers are experiencing large delays resulting in longer than normal deliveries to customers. See USPS's website for further detail. We would like to apologize in advance if your item arrives later than the expected delivery due date.

Internal processing of your order will take about 1-2 business days. Please allow an additional 4-14 business days for Media Mail delivery. We have multiple ship-from locations - MD,IL,NJ,UK,IN,NV,TN & GA

Shipping rates from United Kingdom to U.S.A.

Shipping rates from United Kingdom to U.S.A.
Order quantity	10 to 30 business days	10 to 27 business days
First item	US$ 20.45	US$ 20.45

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.