SQL for Microsoft Access

Cecelia L. Allison

ISBN 10: 1598220608 / ISBN 13: 9781598220605

Verlag: Jones And Bartlett Publishers, Inc Jul 2008, 2008

Beschreibung

Neuware - SQL for Microsoft Access unlocks the power of Structured Query Language (SQL) in Microsoft Access. It guides the reader through step-by-step examples that use SQL script in Microsoft Access to create tables, add records to tables, and retrieve and manage records using simple to advanced data manipulation techniques including combined queries, joined queries, nested queries, views, and temporary tables. The reader also discovers how SQL script can be implemented within VBA and ASP code.

Bestandsnummer des Verkäufers 9781598220605

Bibliografische Details

• Titel: SQL for Microsoft Access
• Verlag: Jones And Bartlett Publishers, Inc Jul 2008
• Erscheinungsjahr: 2008
• Sprache: Englisch
• ISBN-10: 1598220608
• ISBN-13: 9781598220605
• Einband: Taschenbuch
• Auflage: 2. Auflage
• Zustand: Neu
• Abmessungen: 232B x 156 H x 22 T Millimeter Breite: 232 mm, Höhe: 156 mm, Tiefe: 22 mm
• Gewicht: 567 Gramm

Über diesen Titel

Inhaltsangabe

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.

Über die Autorinnen und Autoren

Dr. Cecelia Allison'is an author, technical writer, and online professor. Her background as a software tester and technical support specialist has given her extensive hands-on experience using Structured Query Language (SQL). She wrote and facilitates online SQL courses titled “Introduction to SQL”, "Intermediate SQL" and Advanced SQL which are offered through hundreds of educational facilities, and also teaches online technical courses for Park University. She'has been using SQL for over 20 years and has taught over 100,000 students SQL worldwide.'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 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.