SQL for Microsoft Access Contributor(s): Allison, Cecelia L. (Author), Berkowitz, Neal A. (Author) |
|
ISBN: 1598220608 ISBN-13: 9781598220605 Publisher: Jones & Bartlett Publishers OUR PRICE: $39.59 Product Type: Paperback - Other Formats Published: June 2008 Annotation: 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. |
Additional Information |
BISAC Categories: - Computers | Desktop Applications - Databases - Computers | Programming Languages - Sql |
Dewey: 005.756 |
LCCN: 2008016899 |
Series: Wordware Applications Library |
Physical Information: 0.82" H x 6.05" W x 9" (1.15 lbs) 374 pages |
Descriptions, Reviews, Etc. |
Publisher Description: 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. |
Contributor Bio(s): Allison, Cecelia L.: - Park UniversityBerkowitz, Neal A.: - web designer |