Access 2013 Bible

Häftad, Engelska, 2013

Del i serien Bible

380 kr

Beställningsvara. Skickas inom 5-8 vardagar. Fri frakt över 249 kr.

Beskrivning

A comprehensive reference to the updated and new features of Access 2013As the world's most popular database management tool, Access enables you to organize, present, analyze, and share data as well as build powerful database solutions. However, databases can be complex. That's why you need the expert guidance in this comprehensive reference. Access 2013 Bible helps you gain a solid understanding of database purpose, construction, and application so that whether you're new to Access or looking to upgrade to the 2013 version, this well-rounded resource provides you with a thorough look at everything Access can do. Explains how to create tables, manipulate datasheets, and work with multiple tablesTeaches you how to apply the seven-step design method to build databases that are tailored to your needsCovers building forms with wizards, creating bound and unbound forms, and adding data validationShows you ways to automate query parameters, create functions and subroutines, and add programmed error routinesFeatures a bonus website with content that contains all source code from the book as well as bonus shareware, freeware, trial, demo, and evaluation programsIf you are looking for a comprehensive book on all things Access, look no further than Access 2013 Bible.

Produktinformation

Utgivningsdatum:2013-05-03
Mått:188 x 234 x 51 mm
Vikt:1 882 g
Format:Häftad
Språk:Engelska
Serie:Bible
Antal sidor:1 296
Upplaga:1
Förlag:John Wiley & Sons Inc
ISBN:9781118490358

Utforska kategorier

Databaser inom Data och IT

Mer om författaren

Michael Alexander is a Microsoft Certified Application Developer (MCAD) and author of eight books on advanced business analysis with Microsoft Access and Excel. He has more than 15 years of experience consulting and developing Office solutions. Michael has been named a Microsoft MVP for his ongoing contributions to the Excel community.Dick Kusleika has been helping users get the most out of Microsoft Office products for more than 15 years through online forums, blogging, book contributions, and conferences.

Innehållsförteckning

Acknowledgments ix Contents at a Glance xiContents xiiiIntroduction xxxixPart I: Access Building Blocks 1Chapter 1: An Introduction to Database Development 3Chapter 2: Getting Started with Access 19Part II: Understanding Access Tables 31Chapter 3: Creating Access Tables 33Chapter 4: Understanding Table Relationships 89Chapter 5: Working with Access Tables 129Chapter 6: Importing and Exporting Data 167Chapter 7: Linking to External Data 201Part III: Working with Access Queries 227Chapter 8: Selecting Data with Queries 229Chapter 9: Using Operators and Expressions in Access 261Chapter 10: Going Beyond Select Queries 301Part IV: Analyzing Data in Access 337Chapter 11: Transforming Data in Access 339Chapter 12: Working with Calculations and Dates 363Chapter 13: Performing Conditional Analyses 389Chapter 14: Fundamentals of Using Access SQL 407Chapter 15: Subqueries and Domain Aggregate Functions 427Chapter 16: Running Descriptive Statistics in Access 451Part V: Working with Access Forms and Reports 469Chapter 17: Creating Basic Access Forms 471Chapter 18: Working with Data on Access Forms 509Chapter 19: Working with Form Controls 541Chapter 20: Presenting Data with Access Reports 575Chapter 21: Advanced Access Report Techniques 631Part VI: Access Programming Fundamentals 675Chapter 22: Using Access Macros 677Chapter 23: Getting Started with Access VBA 715Chapter 24: Mastering VBA Data Types and Procedures 757Chapter 25: Understanding the Access Event Model 799Chapter 26: Debugging Your Access Applications 821Part VII: Advanced Access Programming Techniques 853Chapter 27: Accessing Data with VBA Code 855Chapter 28: Advanced Data Access with VBA 897Chapter 29: Integrating Access and SQL Server 915Chapter 30: Customizing the Ribbon 957Chapter 31: Preparing Your Access Application for Distribution 993Part VIII: Access and Windows SharePoint Services 1037Chapter 32: Understanding Windows SharePoint Services 1039Chapter 33: Integrating Access with SharePoint 1045Chapter 34: Understanding Access Services 1059Chapter 35: Deploying Access Applications to SharePoint 1067Chapter 36: Using Access Data Macros 1089Part IX: Appendixes 1109Appendix A: Access 2013 Specifications 1111Appendix B: Optimizing Access Applications 1117Appendix C: Understanding Query Performance and Database Corruption 1139Appendix D: Function Reference for Data Analysts 1147Index 1183