Access 2013 Bible

  • 19h 33m
  • Dick Kusleika, Michael Alexander
  • John Wiley & Sons (US)
  • 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.

About the Authors

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.

In this Book

  • An Introduction to Database Development
  • Getting Started with Access
  • Creating Access Tables
  • Understanding Table Relationships
  • Working with Access Tables
  • Importing and Exporting Data
  • Linking to External Data
  • Selecting Data with Queries
  • Using Operators and Expressions in Access
  • Going Beyond Select Queries
  • Transforming Data in Access
  • Working with Calculations and Dates
  • Performing Conditional Analyses
  • Fundamentals of Using Access SQL
  • Subqueries and Domain Aggregate Functions
  • Running Descriptive Statistics in Access
  • Creating Basic Access Forms
  • Working with Data on Access Forms
  • Working with Form Controls
  • Presenting Data with Access Reports
  • Advanced Access Report Techniques
  • Using Access Macros
  • Getting Started with Access VBA
  • Mastering VBA Data Types and Procedures
  • Understanding the Access Event Model
  • Debugging Your Access Applications
  • Chapter Accessing Data with VBA Code
  • Advanced Data Access with VBA
  • Integrating Access and SQL Server
  • Customizing the Ribbon
  • Preparing Your Access Application for Distribution
  • Understanding Windows SharePoint Services
  • Integrating Access with SharePoint
  • Understanding Access Services
  • Deploying Access Applications to SharePoint
  • Using Access Data Macros