SQL for Microsoft Access
- 3h 1m
- Cecelia L. Allison, Neal A. Berkowitz
- Jones and Bartlett Learning
- 2005
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 examples 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 Authors
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.
In this Book
-
SQL for Microsoft Access
-
Introduction
-
The Relational Database Structure
-
Structured Query Language and Microsoft Access
-
Creating Tables and Inserting Records
-
Retrieving Records
-
Filtering Retrieved Records
-
Creating Calculated Fields
-
Grouping Data
-
Creating Table Joins and Unions
-
Creating Subqueries
-
Creating Views
-
Table Management and Indexes
-
Temporary Tables vs. Views
-
Parameter Queries
-
Integrating SQL Script in VBA Code
-
Integrating SQL Script into ASP Code
-
Access Projects
-
Concluding Thoughts
