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.
"synopsis" may belong to another edition of this title.
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.
Seller: BooksRun, Philadelphia, PA, U.S.A.
Paperback. Condition: Fair. 2. The item might be beaten up but readable. May contain markings or highlighting, as well as stains, bent corners, or any other major defect, but the text is not obscured in any way. Seller Inventory # 1598220608-7-1
Seller: knowledge_exchange, Franklin Park, IL, U.S.A.
Condition: Fair. This is a used book in acceptable condition. This may be a former library item and contains all library stamps, markings, stickers, and sleeves. It may contain marks, cuts, or bends. All pages, covers. If a book has a dust jacket, it may not be included. Some books have their front and/or rear end leaves removed. Cover art may be different than pictured. Books may contain underlining, highlighting, and notes. Some books contain stains and/or discoloration from normal wear and tear. Access codes, CDs, and other bundled media may not be present or usable. Seller Inventory # OLPL_MF_09-23-26_H0000SBY
Seller: HPB-Red, Dallas, TX, U.S.A.
Paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_481101089
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Condition: As New. Unread book in perfect condition. Seller Inventory # 5643806
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Condition: New. Seller Inventory # 5643806-n
Seller: BargainBookStores, Grand Rapids, MI, U.S.A.
Paperback or Softback. Condition: New. SQL for Microsoft Access. Book. Seller Inventory # BBS-9781598220605
Seller: PBShop.store UK, Fairford, GLOS, United Kingdom
PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # FW-9781598220605
Quantity: 1 available
Seller: Kennys Bookshop and Art Galleries Ltd., Galway, GY, Ireland
Condition: New. Num Pages: 374 pages, black / white illustrations. BIC Classification: UF. Category: (G) General (US: Trade). Dimension: 232 x 156 x 22. Weight in Grams: 518. . 2008. 2 Rev ed. Paperback. . . . . Seller Inventory # V9781598220605
Quantity: 1 available
Seller: BooksRun, Philadelphia, PA, U.S.A.
Paperback. Condition: New. 2. The item is brand new, never used or read. It's in perfect condition and may include supplements and/or access codes or come shrink-wrapped. Seller Inventory # 1598220608-10-1
Seller: Revaluation Books, Exeter, United Kingdom
Paperback. Condition: Brand New. 2nd edition. 374 pages. 9.00x6.00x0.75 inches. In Stock. This item is printed on demand. Seller Inventory # __1598220608
Quantity: 1 available