Custom cover image
Access 2010 bible : [create tables and design bulletproof databases; integrate Access with other applications; organize, view, analyze, and share data] / Michael R. Groh
Resource type: Ressourcentyp: Buch (Online)Book (Online)Language: English Series: Bible ; v.695Publisher: Indianapolis, IN : Wiley Publishing, 2010Edition: Online-AusgDescription: Online-Ressource (xlvi, 1343 p.) : illISBN:- 9780470475348
- 1282681613
- 9781282681613
- 9780470872024
- Nebent.: Microsoft Access 2010 bible
- Micorsoft Access 2010 bible
- 005.7565
- 005.75/65 23
- QA76.9.D3
Contents:
Summary: The expert guidance you need to get the most out of Access 2010 Get the Access 2010 information you need to succeed with this comprehensive reference. If this is your first encounter with Access, you'll appreciate the thorough attention to database fundamentals and terminology. If you're familiar with earlier versions, you can jump right into Access 2010 enhancements such as the new Access user interface and wider use of XML and Web services.Takes you under the hood of Microsoft Access 2010, the database application included with Microsoft Office 2010Explores the latest enhancements, such as aPPN: PPN: 665055145Package identifier: Produktsigel: GBV-EBRARY-UBCL | ZDB-38-EAC | ZDB-38-EBR | ZDB-26-MYL | ZDB-30-PAD | ZDB-30-PQE
Microsoft® Access® 2010 Bible; About the Author; About the Technical Editor; Credits; Contents at a Glance; Contents; Acknowledgments; Introduction; Part I: Access Building Blocks; Chapter 1: An Introduction to Database Development; The Database Terminology of Access; Relational Databases; Access Database Objects; A Five-Step Design Method; Summary; Chapter 2: Creating Access Tables; Getting Started with Access; Creating a Database; The Access 2010 Environment; Creating a New Table; Creating tblCustomers; Changing a Table Design; Understanding tblCustomers Field Properties
Setting the Primary KeyIndexing Access Tables; Printing a Table Design; Saving the Completed Table; Manipulating Tables; Adding Records to a Database Table; Understanding Attachment Fields; Summary; Chapter 3: Designing Bulletproof Databases; Building Bulletproof Databases; Data Normalization; Table Relationships; Integrity Rules; Keys; Summary; Chapter 4: Selecting Data with Queries; Introducing Queries; Creating a Query; Adding Fields; Displaying the Recordset; Working with Fields; Changing the Sort Order; Displaying Only Selected Records; Printing a Query's Recordset; Saving a Query
Creating Multi-Table QueriesWorking with the Table Pane; Creating and Working with Query Joins; Understanding Table Join Types; Summary; Chapter 5: Using Operators and Expressions in Access; Introducing Operators; Using Operators and Expressions in Queries; Entering Single-Value Field Criteria; Using Multiple Criteria in a Query; Entering Criteria in Multiple Fields; Summary; Chapter 6: Working with Datasheet View; Understanding Datasheets; Looking at the Datasheet Window; Opening a Datasheet; Entering New Data; Navigating Records in a Datasheet; Changing Values in a Datasheet
Using the Undo FeatureCopying and Pasting Values; Replacing Values; Adding New Records; Deleting Records; Displaying Records; Sorting and Filtering Records in a Datasheet; Focusing on Special Features of Datasheets; Printing Records; Summary; Chapter 7: Creating Basic Access Forms; Formulating Forms; Working with Controls; Introducing Properties; Summary; Chapter 8: Working with Data on Access Forms; Using Form View; Changing Values in a Form; Printing a Form; Working with Form Properties; Adding a Form Header or Footer; Changing the Layout; Creating a Calculated Control
Converting a Form to a ReportSummary; Chapter 9: Presenting Data with Access Reports; Introducing Reports; Creating a Report, from Beginning to End; Banded Report Design Concepts; Creating a Report from Scratch; Improving the Report's Appearance; Summary; Part II: Programming Microsoft Access; Chapter 10: VBA Programming Fundamentals; Introducing Visual Basic for Applications; Understanding VBA Terminology; Starting with VBA Code Basics; Migrating from Macros to VBA; Creating VBA Programs; Understanding VBA Branching Constructs; Working with Objects and Collections
Looking at Access Options for Developers
""Table of Contents""; ""Title Page""; ""Foreword""; ""Part I: Access Building Blocks""; ""Chapter 1: An Introduction to Database Development""; ""Chapter 2: Creating Access Tables""; ""Chapter 3: Designing Bulletproof Databases""; ""Chapter 4: Selecting Data with Queries""; ""Chapter 5: Using Operators and Expressions in Access""; ""Chapter 6: Working with Datasheet View""; ""Chapter 7: Creating Basic Access Forms""; ""Chapter 8: Working with Data on Access Forms""; ""Chapter 9: Presenting Data with Access Reports""; ""Part II: Programming Microsoft Access""
""Chapter 10: VBA Programming Fundamentals""""Chapter 11: Mastering VBA Data Types and Procedures""; ""Chapter 12: The Access Event Model""; ""Chapter 13: Accessing Data with VBA Code""; ""Chapter 14: Debugging Your Access Applications""; ""Chapter 15: Using Access Data Macros""; ""Part III: More-Advanced Access Techniques""; ""Chapter 16: Working with External Data""; ""Chapter 17: Importing and Exporting Data""; ""Chapter 18: Advanced Access Query Techniques""; ""Chapter 19: Advanced Access Form Techniques""; ""Chapter 20: Advanced Access Report Techniques""
""Chapter 21: Building Multiuser Applications""""Chapter 22: Integrating Access with Other Applications""; ""Chapter 23: Handling Errors and Exceptions""; ""Part IV: Professional Database Development""; ""Chapter 24: Optimizing Access Applications""; ""Chapter 25: Advanced Data Access with VBA""; ""Chapter 26: Bulletproofing Access Applications""; ""Chapter 27: Using the Windows Application Programming Interface""; ""Chapter 28: Object-Oriented Programming with VBA""; ""Chapter 29: Customizing Access Ribbons""; ""Chapter 30: Using Access Macros""
""Chapter 31: Distributing Access Applications""""Part V: Access and Windows SharePoint Services""; ""Chapter 32: Understanding Windows SharePoint Services""; ""Chapter 33: Integrating Access with SharePoint""; ""Chapter 34: Understanding Access Services""; ""Chapter 35: Deploying Access Applications to SharePoint""; ""Part VI: Access as an Enterprise Platform""; ""Chapter 36: Client/Server Concepts""; ""Chapter 37: SQL Server as an Access Companion""; ""Chapter 38: Upsizing Access Databases to SQL Server""; ""Part VII: Appendixes""; ""Appendix A: Access 2010 Specifications""
""Appendix B: What's New in Access 2010""""Appendix C: What's on the CD-ROM""; ""Download CD/DVD Content""
No physical items for this record
Electronic reproduction; Available via World Wide Web
Reproduktion. [S.l.] : Ebrary, 2010. (ebrary online). Electronic reproduction; Available via World Wide Web |2010||||||||||