SQL

Susan Sales Harkins is an independent consultant specializing in Microsoft Access, Office, and Visual Basic for Applications. For several years, Susan was editor-in-chief at The Cobb Group, publishing several computer-based monthly journals. She's the author of two books on Access: Using Microsoft Access 97 and Using Microsoft Access 2000. Currently, Susan writes for a number of publishers, including Element K Journals, PC Magazine, ZDNet, CNet, and TechRepublic.

1: Structured Query Language.- 2: An Introduction to Using Jet SQL in Access.- 3: An Introduction to Relational Database Theory.- 4: SQL Grammar.- 5: Retrieving Data.- 6: Modifying Data.- 7: Grouping and Summarizing Data.- 8: Creating and Modifying Tables.- 9: Manipulating Relationships and Indexes.- 10: Advanced Manipulation Techniques.- 11: Queries: The Sequel.- 12: An Introduction to the SQL Server 2000 Desktop Engine.- 13: Introduction to SQL Server.- 14: SQL Server Views.- 15: SQL Server Structure.- 16: Working with Stored Procedures.- 17: Upsizing Directly from Access.- 18: Security Issues.- 19: SQL Server Meets the Web.- Appendix A: More SQL Solutions to Common Problems.- Problem 1: Begin a Label Report at Any Label on the Sheet.- Problem 2: Finding the Second-Highest or -Lowest Value in a Group.- Problem 3: Adding a Summary Row to a Query.- Problem 4: Returning Alternating Rows.- Problem 5: Producing a Random Sort.- Problem 6: Counting Specific Entries.- Problem 7: Counting Unique Values.- Problem 8: Finding Unique Values.- Problem 9: Displaying Optional Data in a List Control.- Problem 10: Custom Sort for Controls.- Appendix B: An Introduction to Using ADO and ADOX with SQL.- Microsoft ActiveX Data Objects Library (ADO).