SQL for Microsoft Access (Wordware Applications Library)

SQL for Microsoft Access (Wordware Applications Library)

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

About the Author
Cecelia Allison is an experienced software tester and technical support specialist with extensive hands-on experience using and teaching SQL. She wrote and facilitates an on-line course titled Introduction to SQL that is offered through hundreds of accredited colleges, universities, and other educational facilities around the world. She also facilitates on-line technical courses for ITT Technical Institute and Park University. She holds a bachelor’s degree in finance and a master’s degree in computer information systems.

Neal Berkowitz is a computer consultant, author, web designer, system analyst, and computer builder with 25 years of experience. An acknowledged Access expert in the Dallas area, he has co-authored four books for Wordware and written a number of articles.

download

Uploading
Rapidshare

Password default : booktraining.net