Details

Access 2013 Bible

Bible 1. Aufl.

von: Michael Alexander, Richard Kusleika
32,99 €
Verlag:	Wiley
Format:	PDF
Veröffentl.:	01.04.2013
ISBN/EAN:	9781118491546
Sprache:	englisch
Anzahl Seiten:	1296

In den Warenkorb

Als Gutschein

DRM-geschütztes eBook, Sie benötigen z.B. Adobe Digital Editions und eine Adobe ID zum Lesen.

Beschreibungen

Titelbeschreibung

A comprehensive reference to the updated and new features of Access 2013 As 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. <ul> <li>Explains how to create tables, manipulate datasheets, and work with multiple tables</li> <li>Teaches you how to apply the seven-step design method to build databases that are tailored to your needs</li> <li>Covers building forms with wizards, creating bound and unbound forms, and adding data validation</li> <li>Shows you ways to automate query parameters, create functions and subroutines, and add programmed error routines</li> <li>Features a bonus website with content that contains all source code from the book as well as bonus shareware, freeware, trial, demo, and evaluation programs</li> </ul> If you are looking for a comprehensive book on all things Access, look no further than Access 2013 Bible.

Inhaltsverzeichnis

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

Autorenportrait

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.

Back cover copy

DESIGN YOUR OWN RELATIONAL DATABASES BUILD POWERFUL ANALYTICS AND REPORTING PROGRAM AND PUBLISH YOUR OWN APPLICATIONS Your all-access guide to Access 2013 This information-packed reference is exactly what you need to take your Access abilities to a whole new level. From using Access to store data and analyze information to building reports, creating applications, and more, you'll start with the basics and work your way through detailed instruction on more advanced tools. Learn to create effective tables, powerful analytic queries, robust applications with Access forms, and attractive Access reports while gaining insight on topics like SharePoint® integration and Visual Basic programming. Whether you're new to Access or just new to Access 2013, this book is an invaluable, in-depth resource for all things Access. <ul> <li>Get a solid grounding in database fundamentals</li> <li>Use Access to analyze large amounts of data</li> <li>Turn your data into attractive PDF-style reports and outputs</li> <li>Automate redundant reporting and analysis using Access macros</li> <li>Build powerful departmental applications with Access forms</li> <li>Save time and increase productivity with Access VBA</li> <li>Integrate or publish your data on SharePoint sites</li> <li>Follow along with downloadable examples and database files from the book</li> </ul> Create data collection mechanisms that can be shared online Build custom applications designed just for you Use the intuitive Query Builder in Access for easy analysis