Microsoft Access 2010 in depth
By: Roger Jennings
Publisher: Que Pub.
Published: 2011
Place of publication: Indianapolis, Ind
Language: eng
Number of pages: 1521
ISBN-13: 9780789743077
Subjects: Microsoft Access; Database management
Notes: Includes index.
Table of contents: title: Introduction; title: GETTING ACQUAINTED WITH ACCESS 2010: Access 2010 for Access 2007 users: what's new; title: Building a simple application; title: Navigating the fluent user interface; title: LEARNING THE FUNDAMENTALS OF ACCESS DATABASES: Exploring relational database theory and practice; title: Working with Access databases and tables; title: Entering, editing, and validating Access databases and tables; title: Sorting, finding, and validating data; title: Linking, importing, and exporting data; title: TRANSFORMING DATA WITH QUERIES AND TABLES: Designing queries for access databases; title: Understanding Access query operators and expressions; title: Creating multitable and crosstab queries; title: Working with PivotTable and PivotChart views; title: Creating and updating Access tables with action queries; title: DESIGNING FORMS AND REPORTS: Creating and using Access forms; title: Designing custom multitable forms; title: Working with simple reports and mailing labels; title: Preparing advanced reports; title: Adding graphs, PivotCharts, and PivotTables; title: PROGRAMMING DATABASES WITH MACROS: Automating Access applications with macros and procedures; title: Emulating table triggers with Access data macros; title: COLLABORATING WITH ACCESS DATA: Linking Access front ends to Access and client/server tables; title: Collaborating with Windows SharePoint Foundation 2010; title: Sharing Web databases with SharePoint Server 2010; title: WORKING WITH HTML AND XML DOCUMENTS: Importing and exporting Web Pages: 1007 (Online); title: Integrating with XML and InfoPath 2010 : 1053 (Online); title: CREATING ACCESS FRONT ENDS WITH SQL SERVER DATABASES: Exploring Access Data Projects and SQL Server 2008: 1089 (Online); title: Upsizing Access applications to Access Data Projects and SQL Azure: 1171 (Online); title: PROGRAMMING AND CONVERTING ACCESS APPLICATIONS: Learning Visual Basic for applications: 1239 (Online); title: Handling events with VBA and macros: 1279 (Online); title: Programming Combo and List boxes: 1317 (Online); title: Understanding Data Access Objects, OLE DB, and ADO: 1349 (Online); title: Upgrading Access 2003 and earlier applications to Access 2010: 1403 (Online); title: APPENDIX: A: What was new in Access 2007 for users of Access 2003 and earlier: 1423 (Online); title: B: Glossry: 1475 (Online)