Programming Microsoft Office Access 2003 Introduction Chapter 1 - Data Access Models: Part I Chapter 2 - Data Access Models: Part II Chapter 3 - The ADOX Library and Tables Chapter 4 - Jet SQL, the ADOX Library, and Queries Chapter 5 - Forms, Controls, and Data Chapter 6 - Reports, Controls, and Data Chapter 7 - Designing and Using PivotTables and PivotCharts Chapter 8 - Microsoft Office Objects Chapter 9 - Integrating Access with Other Office Applications Chapter 10 - Database Security Chapter 11 - Using Access to Build SQL Server Solutions: Part I Chapter 12 - Using Access to Build SQL Server Solutions: Part II Chapter 13 - Using Access to Build SQL Server Solutions: Part III Chapter 14 - Access Does the Web Chapter 15 - XML and Access
Part I: Just the Basics8 Chapter 1: Getting Familiar with Reporting Services 9 Chapter 2: Retrieving Data from a Database29 Chapter 3: Building and Running a Simple Report47 Part II: Building Reports — Your Creativity Options 63 Chapter 4: We’re Off to See the Wizard65 Chapter 5: Styling with Report Types71 Chapter 6: Accessorizing Your Reports93 Chapter 7: Reporting with Parameters and Format Options117 Chapter 8: Using Report Builder 139 Part III: Publishing, Accessing, and Subscribing to Reports 155 Chapter 9: Publish or Perish — Getting the Report Out 157 Chapter 10: Executing and Accessing Reports on Demand181 Chapter 11: Delivering Your Reports 201 Part IV: Maintaining Your Reports 225 Chapter 12: Managing and Administering Your Reports227 Chapter 13: Securing Report Server 245 Chapter 14: Optimizing Report Performance 257 Part V: Developing Advanced Reports271 Chapter 15: More About Interactive Reporting 273 Chapter 16: Drilling Down to the Details 289 Chapter 17: Reporting from OLAP Data Sources307 Chapter 18: Helping Executives See the Big Business Picture 323 Part VI: Migrating from Other Reporting Tools 339 Chapter 19: Comparing Reporting Services to Other Popular Reporting Tools 341 Chapter 20: Converting Reports from Access 355 Part VII: The Part of Tens 365 Chapter 21: Ten Cool Tricks with Reporting Services367 Chapter 22: Ten Ways to Hook Into the Microsoft BI Platform375 Chapter 23: Ten Places to Find Reporting Services Support379 Chapter 24: Ten Third Party Tools to Use with Reporting Services 383
Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database? Chapter 2: Tools of the Trade Chapter 3: The Foundation Statements of T-SQL Chapter 4: JOINs Chapter 5: Creating and Altering Tables Chapter 6: Constraints Chapter 7: Adding More to Our Queries Chapter 8: Being Normal: Normalization and Other Basic Design Issues Chapter 9: SQL Server Storage and Index Structures Chapter 10: Views Chapter 11: Writing Scripts and Batches Chapter 12: Stored Procedures Chapter 13: User Defined Functions Chapter 14: Transactions and Locks Chapter 15: Triggers Chapter 16: A Brief XML Primer Chapter 17: Reporting for Duty, Sir!: A Look At Reporting Services Chapter 18: Getting Integrated With Integration Services Chapter 19: Playing Administrator
Part I: SQL Server 2005: An Overview7 Chapter 1: Introducing SQL Server 2005 9 Chapter 2: New Features in SQL Server 200521 Chapter 3: Introducing and Configuring Management Studio 35 Part II: Basic Operations51 Chapter 4: Creating Databases, Tables, and Relationships with T-SQL53 Chapter 5: Asking Questions and Getting Answers 67 Chapter 6: Building a Simple Application87 Part III: Working with SQL Server99 Chapter 7: Working with XML 101 Chapter 8: Using the Common Language Runtime 121 Chapter 9: Using Stored Procedures131 Chapter 10: Error Handling in T-SQL143 Part IV: Protecting Your Data 155 Chapter 11: Securing Your Data157 Chapter 12: Availability and Preventing Data Loss 173 Chapter 13: Maintaining Integrity with Transactions 185 Chapter 14: Maintaining Data Integrity with Constraints and Triggers191 Part V: Administering a SQL Server System 209 Chapter 15: Configuring a SQL Server System 211 Chapter 16: Scheduling SQL Server Agent Jobs 231 Chapter 17: Sending Information Using Notification Services253 Chapter 18: Maintaining a SQL Server System 261 Chapter 19: Working with Multiple Servers 283 Part VI: Using SQL Server Business Intelligence (BI) Services305 Chapter 20: SQL Server Integration Services307 Chapter 21: Analysis Services337 Chapter 22: Building Business Reports with Reporting Services 359 Part VII: The Part of Tens 377 Chapter 23: Ten Sources of Information on SQL Server 2005379 Chapter 24: Products that Work with SQL Server 2005383
Chapter 1 A First Introduction to MDX Chapter 2 Introduction to MDX Calculated Members and Named Sets Chapter 3 Common Calculations and Selections in MDX Chapter 4 MDX Query Context and Execution Chapter 5 Named Sets and Set Aliases Chapter 6 Sorting and Ranking in MDX Chapter 7 Advanced MDX Application Topics Chapter 8 Using the Attribute Data Model of Microsoft Analysis Services Chapter 9 Using Attribute Dimensions and Member Properties in Hyperion Essbase Chapter 10 Extending MDX through External Functions Chapter 11 Changing the Cube and Dimension Environment through MDX Chapter 12 The Many Ways to Calculate in Microsoft Analysis Services Chapter 13 MDX Scripting in Analysis Services 2005 Chapter 14 Enriching the Client Interaction Chapter 15 Client Programming Basics Chapter 16 Optimizing MDX Chapter 17 Working with Local Cubes
作者:George Spofford,Sivakumar Hari
出版商: Wiley
更新: 2007-01-05
归类: Ms SQL
大小: 10.6M
■CHAPTER 1 The Oracle DBA’s World ■CHAPTER 2 Relational Database Modeling and Database Design ■CHAPTER 3 Essential UNIX (and Linux) for the Oracle DBA ■CHAPTER 4 Introduction to the Oracle Database 10g Architecture ■CHAPTER 5 Schema Management ■CHAPTER 6 Oracle Transaction Management ■CHAPTER 7 Installing the Oracle Database 10g RDBMS ■CHAPTER 8 Upgrading to Oracle Database 10g ■CHAPTER 9 Creating an Oracle Database ■CHAPTER 10 Connectivity and Networking ■CHAPTER 11 User Management and Database Security ■CHAPTER 12 Using SQL*Plus and iSQL*Plus ■CHAPTER 13 Loading and Transforming Data ■CHAPTER 14 Using Data Pump Export and Import ■CHAPTER 15 Backing Up Databases ■CHAPTER 16 Database Recovery ■CHAPTER 17 Automatic Management and Online Capabilities ■CHAPTER 18 Managing and Monitoring the Operational Database ■CHAPTER 19 Using Oracle Enterprise Manager ■CHAPTER 20 Managing Oracle Databases on Windows and Linux Systems ■CHAPTER 21 Improving Database Performance: SQL Query Optimization . ■CHAPTER 22 Performance Tuning: Tuning the Instance ■CHAPTER 23 The Oracle Data Dictionary and the Dynamic Performance Views ■CHAPTER 24 Using Oracle PL/SQL Packages ■APPENDIX A Oracle Database 10g SQL and PL/SQL: A Brief Primer
Chapter 1: Getting Started with SQL Server 2005 Express Edition Chapter 2: Database Basics with SQL Server Management Studio Express Edition Chapter 3: Creating a Simple Database Application Chapter 4: Developing a Rich Client Database Application Chapter 5: Developing a Rich Web Database Application Chapter 6: Understanding Xcopy Deployment and User Instance Model Chapter 7: Using XML in Your Database Application Chapter 8: Debugging Database Applications Chapter 9: Understanding SQL Server Express Setup Chapter 10: Deploying Your Application Chapter 11: Migrating from Microsoft Desktop Engine (MSDE) Chapter 12: Migrating from Jet and Microsoft Access to MSDE and SSE Chapter 13: Securing Your Multi-User Database Application Chapter 14: Upgrading from SSE to Other SQL Server 2005 Editions Chapter 15: Building Robust Multi-User Database Applications
作者:Rajesh George and Lance Delano
出版商: Wiley
更新: 2006-12-28
归类: Ms SQL
大小: 8.3M