You are previewing Access 2013 Bible.
O'Reilly logo
Access 2013 Bible

Book Description

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.

  • Explains how to create tables, manipulate datasheets, and work with multiple tables

  • Teaches you how to apply the seven-step design method to build databases that are tailored to your needs

  • Covers building forms with wizards, creating bound and unbound forms, and adding data validation

  • Shows you ways to automate query parameters, create functions and subroutines, and add programmed error routines

  • 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

If you are looking for a comprehensive book on all things Access, look no further than Access 2013 Bible.

Table of Contents

  1. Cover
  2. Table of Contents
  3. Title Page
  4. Introduction
  5. Part I: Access Building Blocks
    1. Chapter 1: An Introduction to Database Development
    2. Chapter 2: Getting Started with Access
  6. Part II: Understanding Access Tables
    1. Chapter 3: Creating Access Tables
    2. Chapter 4: Understanding Table Relationships
    3. Chapter 5: Working with Access Tables
    4. Chapter 6: Importing and Exporting Data
    5. Chapter 7: Linking to External Data
  7. Part III: Working with Access Queries
    1. Chapter 8: Selecting Data with Queries
    2. Chapter 9: Using Operators and Expressions in Access
    3. Chapter 10: Going Beyond Select Queries
  8. Part IV: Analyzing Data in Access
    1. Chapter 11: Transforming Data in Access
    2. Chapter 12: Working with Calculations and Dates
    3. Chapter 13: Performing Conditional Analyses
    4. Chapter 14: Fundamentals of Using Access SQL
    5. Chapter 15: Subqueries and Domain Aggregate Functions
    6. Chapter 16: Running Descriptive Statistics in Access
  9. Part V: Working with Access Forms and Reports
    1. Chapter 17: Creating Basic Access Forms
    2. Chapter 18: Working with Data on Access Forms
    3. Chapter 19: Working with Form Controls
    4. Chapter 20: Presenting Data with Access Reports
    5. Chapter 21: Advanced Access Report Techniques
  10. Part VI: Access Programming Fundamentals
    1. Chapter 22: Using Access Macros
    2. Chapter 23: Getting Started with Access VBA
    3. Chapter 24: Mastering VBA Data Types and Procedures
    4. Chapter 25: Understanding the Access Event Model
    5. Chapter 26: Debugging Your Access Applications
  11. Part VII: Advanced Access Programming Techniques
    1. Chapter 27: Accessing Data with VBA Code
    2. Chapter 28: Advanced Data Access with VBA
    3. Chapter 29: Integrating Access and SQL Server
    4. Chapter 30: Customizing the Ribbon
    5. Chapter 31: Preparing Your Access Application for Distribution
  12. Part VIII: Access and Windows SharePoint Services
    1. Chapter 32: Understanding Windows SharePoint Services
    2. Chapter 33: Integrating Access with SharePoint
    3. Chapter 34: Understanding Access Services
    4. Chapter 35: Deploying Access Applications to SharePoint
    5. Chapter 36: Using Access Data Macros
  13. Part IX: Appendixes
    1. Appendix A: Access 2013 Specifications
    2. Appendix B: Optimizing Access Applications
    3. Appendix C: Understanding Query Performance and Database Corruption
    4. Appendix D: Function Reference for Data Analysts