- Home
- Browser a Book
- SQL for Microsoft Access (Wordware Applications Library)
SQL for Microsoft Access (Wordware Applications Library)
Publisher: Wordware Publishing, Inc.
Keywords: applications, library, wordware, access, microsoft, sql
Number of Pages: 368
Published: 2005-10-25
List price: $39.95
ISBN-10: 1556220928
ISBN-13: 9781556220920
Book Description:
SQL for Microsoft Access unlocks the power of Structured Query Language (SQL) in Microsoft Access. It guides the reader through step-by-step examples of creating a database in Microsoft Access using SQL script to create tables, add records to tables, and retrieve and manage records using simple to advanced data manipulation techniques including queries and views. The reader also encounters exam-ples of integrating SQL script into VBA and ASP code.
* Explore the relational database structure and the basics of SQL. * Learn how to insert, retrieve, and filter records. * Understand how table joins, unions, and subqueries are used to retrieve records from multiple tables. * Learn how to use views and temporary tables. * Discover how to prompt the user for information with parameter queries. * Find out how SQL can be used to enhance Active Server pages. * Test your knowledge through the end-of-chapter quizzes and projects.
Reviews:
Loading Google Book Reviews...
Related Books
- SQL Simplified:: Learn to Read and Write Structured Query Language
- Integrating Excel and Access
- Access 2007 VBA Programmer’s Reference (Programmer to Programmer)
- Learn Database Programming Using SQL of Microsoft Access - Second Edition
- Microsoft Access Data Analysis: Unleashing the Analytical Power of Access