SQL For Microsoft Access

Overview

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 ...
See more details below
Paperback (2E)
$27.74
BN.com price
(Save 30%)$39.99 List Price
Other sellers (Paperback)
  • All (1) from $26.73   
  • New (1) from $26.73   
SQL for Microsoft Access

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$22.99
BN.com price
(Save 42%)$39.95 List Price

Overview

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.
Read More Show Less

Product Details

  • ISBN-13: 9781598220605
  • Publisher: Jones & Bartlett Learning
  • Publication date: 6/20/2008
  • Edition description: 2E
  • Edition number: 2
  • Pages: 374
  • Sales rank: 695,731
  • Product dimensions: 5.90 (w) x 8.90 (h) x 0.90 (d)

Table of Contents


Acknowledgments     xiii
Introduction     xiv
The Relational Database Structure     1
Introduction     1
Early Forms of Data Storage     3
The Relational Database Structure     4
Tables     4
Keys     5
The Planning Stage     6
Data Modeling     7
Entities and Relationships     7
Normalization     10
Client/Server Databases     11
Database Management Systems     11
Summary     12
Structured Query Language and Microsoft Access     15
Introduction     15
Structured Query Language     16
SQL Versions     16
Switching to Version SQL-92 in Microsoft Access 2007     17
Switching to Version SQL-92 in Microsoft Access 2003     17
SQL Components     17
SQL Syntax     18
The Power of SQL in Microsoft Access     19
The Query Wizard     19
The Query Design Tool and SQL View     20
Opening Microsoft Access and Switching to SQL View     21
Opening Microsoft Access     21
Switching to SQL View in Microsoft Access 2007     23
Switching to SQL View in Microsoft Access 2003     25
Summary     28
Creating Tables and Inserting Records     31
Introduction     31
The Data Definition Language Component     32
CREATE TABLE Syntax     34
Data Types     36
Example 1     39
Constraints     40
Example 2     40
NULL/NOT NULL Constraint     41
PRIMARY KEY Constraint     42
Example 3     43
FOREIGN KEY Constraint     44
UNIQUE Constraint     45
Adding Constraints to Existing Tables     45
Example 4     46
Example 5     46
Constraint Syntax     47
Inserting Records     48
Example 6     48
Inserting Data without Specifying Column Names     50
Example 7     50
Inserting NULL Values     51
Example 8     51
Copying Records from One Table to an Existing Table     51
Example 9     51
Copying Records from One Table to a New Table Simultaneously     53
Example 10     53
Updating Records      54
Update a Record with a Text Value     54
Example 11     54
Update a Record with a New Calculated Value     55
Example 12     55
Update Multiple Columns     55
Example 13     55
Update a Column that Contains a Date     56
Example 14     56
Deleting Records     58
Example 15     58
Summary     59
Retrieving Records     61
Introduction     61
The SELECT Statement     62
Example 1     65
Example 2     66
The ORDER BY Clause     68
Sorting in Descending Order     69
Example 3     69
Sorting in Ascending Order     70
Example 4     70
Sorting Multiple Columns     71
Example 5     71
Example 6     72
Sorting Using Numbers     73
Example 7     73
Example 8     74
Handling Duplicate Values     74
The DISTINCT Keyword     74
Example 9     75
The DISTINCTROW Keyword     75
Handling Duplicate Subsets of the Entire Result Collection      76
The TOP Keyword     76
Example 10     76
Example 11     77
The TOP PERCENT Keywords     78
Example 12     78
Example 13     79
Creating an Alias     80
Example 14     80
Create an Alias that Contains a Space     81
Example 15     81
Concatenation     82
Concatenate Multiple Fields and Characters     82
Example 16     82
Concatenate Multiple Fields from Multiple Tables     83
Example 17     83
Summary     84
Filtering Retrieved Records     87
Introduction     87
The WHERE Clause     88
Comparison Operators     89
Logical Operators     90
Operator Precedence     91
The AND, OR, =, and < Operators     91
Example 1     91
The LIKE Operator     95
Example 2     96
Example 3     97
Example 4     97
Example 5     97
Example 6     98
Example 7     98
Example 8     98
Example 9     98
The BETWEEN Operator     99
Example 10     99
The IN and NOT Operators     100
Example 11     101
Example 12     101
The IS NULL and IS NOT NULL Operators     102
Example 13     102
Summary     103
Creating Calculated Fields     105
Introduction     105
Operators and Functions     106
Arithmetic Operators     108
Use an Arithmetic Operator with SELECT     110
Example 1     110
Use an Arithmetic Operator in the WHERE clause     111
Example 2     111
Aggregate Functions     112
Using the AVG 0, FIRST 0, LAST 0, SUM 0, MAX 0, and MIN 0 Functions     113
Example 3     113
Using the COUNT 0 Function     114
Example 4     114
String Functions and Operations     115
Use of the + and &     117
Example 5     118
Using the LEFT 0, UCASE 0, LEN 0, and TRIM 0 Functions     118
Example 6     118
Using the MID 0 and INSTR 0 Functions     120
Example 7     120
Date and Time Functions     122
Inserting Dates into a Table     124
Example 8     124
Using the FORMAT 0 Function     125
Example 9     125
Using the DATE 0, TIME 0, MONTH 0, DAY 0, and YEAR 0 Functions     127
Example 10     127
Miscellaneous Functions     128
Using the CCUR 0 Function     129
Example 11     129
Summary     130
Grouping Data     133
Introduction     133
The GROUP BY Clause     134
Example 1     135
Using the GROUP BY Clause with the ORDER BY Clause     138
Example 2     138
The HAVING Clause     140
Example 3     140
Using the HAVING Clause with the WHERE Clause     142
Example 4     142
Summary     144
Creating Table Joins and Unions     145
Introduction     145
Table Joins - An Overview     146
Qualification     146
Inner Join     147
Example 1     148
Using the DISTINCTROW Keyword     152
Example 2     152
Self Join     153
Example 3     155
Nested Join      156
Example 4     156
Outer Joins     159
Right Outer Join     160
Example 5     160
Left Outer Join     163
Example 6     163
Create a Join that Contains an Aggregate Function     165
Example 7     165
UNION and UNION ALL Keywords     167
UNION     167
Example 8     167
UNION ALL     171
Example 9     171
Summary     172
Creating Subqueries     175
Introduction     175
Subqueries     176
Correlated and Non-Correlated Subqueries     176
The IN Subquery     176
Example 1     177
The EXISTS Subquery     180
Example 2     180
The ANY and SOME Subqueries     183
Example 3     184
The ALL Subquery     185
Example 4     185
Nested Subqueries     186
Example 5     186
Using a Subquery to Find the Second Highest Value     189
Example 6     189
Summary     190
Creating Views     191
Introduction      191
Creating a View     192
Example 1     192
Creating a View Using the CREATE VIEW Keywords in SQL-92     194
Create a View that Contains a Complex Join     195
Example 2     195
Query the Customers Total Transactions View     196
Example 3     196
Filtering a Record through a View     197
Example 4     197
Example 5     198
Updating a Record through a View     198
Example 6     199
Deleting a View     199
Example 7     200
Summary     200
Table Management and Indexes     201
Introduction     201
Adding a Column to an Existing Table     202
Example 1     203
Changing a Column     204
Example 2     204
Setting a Default Value for a Column     205
Example 3     205
Removing a Column from a Table     206
Example 4     206
Removing a Table     207
Improving Data Retrieval Time Using Indexes     207
Index Options     208
Creating an Index     209
Example 5      209
Indexing in Descending Order     210
Example 6     210
Viewing and Editing Indexes     211
Deleting an Index     212
Example 7     213
Summary     213
Temporary Tables vs. Views     215
Introduction     215
Creating a View     216
Example 1     216
Creating a Temporary Table     218
Example 2     218
Accessing the Temporary Table     219
Querying a Temporary Table     220
Example 3     220
Indexing a Temporary Table     221
Example 4     221
Updating a Temporary Table     222
Example 5     222
Copying Records from One Temporary Table to a New Temporary Table Simultaneously     223
Example 6     223
Deleting a Temporary Table     224
Example 7     224
Why Do We Need Temporary Tables?     224
Summary     228
Parameter Queries     229
Introduction     229
Parameter Queries     229
Creating a Simple Query     230
Example 1     230
Creating a Parameter Query      231
Example 2     231
Customizing Your Dialog Box     233
Example 3     233
Creating Multiple Prompts     234
Example 4     234
Example 5     236
Using the LIKE Keyword to Prompt the User     237
Example 6     237
Prompting the User for Dates     238
Example 7     238
Creating a Button to Prompt the User     239
Example 8     239
View the New Button on the Form     244
SQL Syntax for a Parameter Query in SQL View     246
Example 9     246
Example 10     247
Non-parameter Parameter Queries     248
Summary     250
Integrating SQL Script in VBA Code     253
Introduction     253
Fixed Queries vs. "On-the-Fly" Queries     254
Filtered Recordsets for Forms     259
Filtered Recordsets for Combo Boxes     263
Recordsets for Subforms     265
Report Filters     270
Summary     274
Integrating SQL Script into ASP Code     275
Introduction     275
Basics     276
Building the Components      277
ODBC Connection     277
Code     281
Building SQL Statements     286
Summary     291
Access Projects     293
Introduction     293
Overview     293
Differences between Access Projects and Access Databases     298
Project Window     301
Tables     302
Database Diagrams     307
Queries     310
Views     311
Stored Procedures     316
Functions     318
Summary     321
Concluding Thoughts     323
Introduction     323
Common Rules     323
Summary     324
Answers to Quizzes and Projects     327
Frequently Used SQL Keywords in Microsoft Access     341
Terms and Definitions     345
Microsoft Access Data Types     351
SQL Script to Create the Tables in This Book     353
Index     369
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted January 7, 2012

    No text was provided for this review.

Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)