SQL for Microsoft® Access, 2nd Edition
by Neal A. Berkowitz, Cecelia L. Allison
SQL for Microsoft Access, 2nd Edition
- Contents
- Acknowledgments
- Introduction
- Chapter 1 The Relational Database Structure
- Chapter 2 Structured Query Language and Microsoft Access
- Chapter 3 Creating Tables and Inserting Records
- Chapter 4 Retrieving Records
- Chapter 5 Filtering Retrieved Records
- Chapter 6 Creating Calculated Fields
- Chapter 7 Grouping Data
- Chapter 8 Creating Table Joins and Unions
- Chapter 9 Creating Subqueries
- Chapter 10 Creating Views
- Chapter 11 Table Management and Indexes
- Chapter 12 Temporary Tables vs. Views
- Introduction
- Definitions
- Creating a View
- Creating a Temporary Table
- Accessing the Temporary Table
- Querying a Temporary Table
- Indexing a Temporary Table
- Updating a Temporary Table
- Copying Records from One Temporary Table to a New Temporary Table Simultaneously
- Deleting a Temporary Table
- Why Do We Need Temporary Tables?
- Summary
- Chapter 13 Parameter Queries
- Introduction
- Definitions
- Parameter Queries
- Creating a Simple Query
- Creating a Parameter Query
- Customizing Your Dialog Box
- Creating Multiple Prompts
- Using the LIKE Keyword to Prompt the User
- Prompting the User for Dates
- Creating a Button to Prompt the User
- View the New Button on the Form
- SQL Syntax for a Parameter Query in SQL View
- Non-parameter Parameter Queries
- Summary
- Chapter 14 Integrating SQL Script in VBA Code
- Chapter 15 Integrating SQL Script into ASP Code
- Chapter 16 Access Projects
- Chapter 17 Concluding Thoughts
- Appendix A Answers to Quizzes and Projects
- Appendix B Frequently Used SQL Keywords in Microsoft Access
- Appendix C Terms and Definitions
- Appendix D Microsoft Access Data Types
- Appendix E SQL Script to Create the Tables in This Book
- Create and Populate the Activities Table
- Create and Populate the Committee1 Table
- Create and Populate the Committee2 Table
- Create and Populate the Computers Table
- Create and Populate the Customers Table
- Create and Populate the Customers2 Table
- Create and Populate the Departments Table
- Create and Populate the Employees Table
- Create and Populate the Friends Table
- Create and Populate the Manufacturers Table
- Create and Populate the Numbers Table
- Create and Populate the Products Table
- Create and Populate the Sales Table
- Create and Populate the Tools Table
- Create and Populate the Toys Table
- Create and Populate the Transactions Table
- Index
To my wonderful parents, Willie A. Coney and Rosa D. Coney, my loving husband, John F. Allison, and my sweet daughter, Kayla Desiree Allison. You each played a special role in inspiring me to reach for the stars, stay focused, and work hard. I love you!
Cecelia L. Allison
To my wife, Deborah, who puts up with my idiosyncrasies and is always there for me. When we got married she promised that I would never be bored, and she has definitely exceeded that promise. She is the love of my life and, while I don’t say it often enough, Ihopethatsheknowsit.
With special thanks to the members of the Metroplex Access Developers (MAD) group — colleagues and friends who are always available.
Neal A. Berkowitz
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.