Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

    Start ReadingShareBuy Print Version
    Microsoft® Access® 2010 Inside Out

    • Microsoft® Access® 2010 Inside Out

    • By: ;

    • Publisher: Microsoft Press

    • Pub. Date:

    • Print ISBN-13: 978-0-7356-2685-0

    • Pages in Print Edition: 1488

    • Subscriber Rating: 0 out of 5 rating0 [0 Ratings]

    1ebooken
    Subscriber Reviews • Browse Similar Topics

    Overview

    Get expert advice and learn how to master Microsoft® Office Access® 2010 -- from the inside out! This book packs hundreds of timesaving solutions, troubleshooting tips, and workarounds, all in concise, fast-answer format.

    Subscriber Reviews

    Average Rating: 0 out of 5 rating Based on 0 Ratings

    No Subscribers have provided a review for this book.

    Table of Contents

     

    View Sample

    Microsoft® Access® 2010 Inside Out

    View Sample

    Dedication

    View Sample

    A Note Regarding Supplemental Files

    View Sample

    Acknowledgments

    View Sample
    About the CD
    View Sample

    What’s on the CD

    View Sample

    Sample Applications

    View Sample

    System Requirements

    View Sample

    Support Information

    View Sample
    Conventions and Features Used in This Book
    View Sample

    Text Conventions

    View Sample

    Design Conventions

    View Sample

    Syntax Conventions

    View Sample
    Introduction
    View Sample

    Getting Familiar with Access 2010

    View Sample

    About This Book

    View Sample

    I. Understanding Access

    View Sample
    1. What Is Access?
    View Sample

    What Is a Database?

    View Sample

    Access as an RDBMS

    View Sample

    Access as an Application Development System

    View Sample

    Deciding to Move to Database Software

    View Sample

    Extending the Power of Access to the Web

    View Sample
    2. Exploring the Access 2010 Interface
    View Sample

    Opening Access for the First Time

    View Sample

    Getting Started with Access 2010

    View Sample

    Understanding Content Security

    View Sample

    Understanding the Office Fluent Ribbon

    View Sample

    Understanding the Navigation Pane

    View Sample

    Using the Single-Document vs. the Multiple-Document Interface

    View Sample

    Modifying Global Settings via the Access Options Dialog Box

    View Sample
    3. Access 2010 Overview
    View Sample

    The Architecture of Access

    View Sample

    Exploring a Desktop Database—Housing Reservations

    View Sample

    What Happened to Project Files (ADP)?

    View Sample

    The Many Faces of Access

    View Sample

    II. Creating a Database and Tables

    View Sample
    4. Designing Client Tables
    View Sample

    Creating a New Database

    View Sample

    Creating Your First Simple Table by Entering Data

    View Sample

    Creating a Table Using Application Parts

    View Sample

    Creating a Table Using Data Type Parts

    View Sample

    Creating a Table in Design View

    View Sample

    Defining Fields

    View Sample

    Defining a Primary Key

    View Sample

    Defining a Table Validation Rule

    View Sample

    Understanding Other Table Properties

    View Sample

    Defining Relationships

    View Sample

    Adding Indexes

    View Sample

    Setting Table Design Options

    View Sample

    Creating a Default Template for New Databases

    View Sample

    Printing a Table Definition

    View Sample

    Database Limitations

    View Sample
    5. Modifying Your Table Design
    View Sample

    Before You Get Started

    View Sample

    Deleting Tables

    View Sample

    Renaming Tables

    View Sample

    Changing Field Names

    View Sample

    Moving Fields

    View Sample

    Inserting Fields

    View Sample

    Copying Fields

    View Sample

    Deleting Fields

    View Sample

    Changing Data Attributes

    View Sample

    Reversing Changes

    View Sample

    Using the Table Analyzer Wizard

    View Sample

    Taking a Look at Lookup Properties

    View Sample

    Working with Multi-Value Lookup Fields

    View Sample

    Changing the Primary Key

    View Sample

    Compacting Your Database

    View Sample
    6. Designing Web Tables
    View Sample

    Working with the Web

    View Sample

    Creating a New Web Database

    View Sample

    Creating Your First Simple Web Table by Entering Data

    View Sample

    Creating a Web Table Using Application Parts

    View Sample

    Using Data Type Parts

    View Sample

    Creating Web Tables in Datasheet View

    View Sample

    Defining a Table Validation Rule for Web Databases

    View Sample

    Defining a Primary Key for Web Databases

    View Sample

    Understanding Other Web Table Properties

    View Sample

    Creating Lookup Fields in a Web Database

    View Sample

    Creating Relationships Using Lookup Fields

    View Sample

    Using the Web Compatibility Checker

    View Sample
    7. Creating Table Data Macros
    View Sample

    Uses of Data Macros

    View Sample

    The Data Macro Design Facility—An Overview

    View Sample

    Working with Before Events

    View Sample

    Working with After Events

    View Sample

    Working with Named Data Macros

    View Sample

    Debugging Data Macros

    View Sample

    Understanding Recursion in Data Macros

    View Sample

    Sharing Data Macro Logic

    View Sample
    8. Importing and Linking Data
    View Sample

    A Word About Open Database Connectivity (ODBC)

    View Sample

    Creating a Data Source to Link to an ODBC Database

    View Sample

    Importing vs. Linking Database Files

    View Sample

    Importing Data and Databases

    View Sample

    Importing Spreadsheet Data

    View Sample

    Importing Text Files

    View Sample

    Modifying Imported Tables

    View Sample

    Linking Files

    View Sample

    Collecting Data via Email

    View Sample

    Importing and Linking SharePoint Data

    View Sample

    Saving Import Procedures

    View Sample

    III. Building Queries

    View Sample
    9. Creating and Working with Simple Queries
    View Sample

    Selecting Data from a Single Table

    View Sample

    Testing Validation Rule Changes

    View Sample

    Working in Query Datasheet View

    View Sample
    10. Building Complex Queries
    View Sample

    Selecting Data from Multiple Tables

    View Sample

    Using a Query Wizard

    View Sample

    Summarizing Information with Totals Queries

    View Sample

    Using Query Parameters

    View Sample

    Customizing Query Properties

    View Sample

    Editing and Creating Queries in SQL View

    View Sample

    Limitations on Using Select Queries to Update Data

    View Sample

    Creating PivotTables and PivotCharts from Queries

    View Sample

    Creating Queries for the Web

    View Sample
    11. Modifying Data with Action Queries
    View Sample

    Updating Groups of Rows

    View Sample

    Creating a New Table with a Make-Table Query

    View Sample

    Inserting Data from Another Table

    View Sample

    Deleting Groups of Rows

    View Sample

    Troubleshooting Action Queries

    View Sample

    IV. Creating Forms

    View Sample
    12. Using Forms in an Access Application
    View Sample

    Uses of Forms

    View Sample

    A Tour of Forms

    View Sample

    Understanding Web Form Limitations

    View Sample

    Moving Around on Forms and Working with Data

    View Sample

    Adding Records and Changing Data

    View Sample

    Searching for and Sorting Data

    View Sample

    Printing Forms

    View Sample
    13. Building a Form
    View Sample

    Forms and Object-Oriented Programming

    View Sample

    Starting from Scratch—A Simple Input Form

    View Sample

    Working with Quick Create and the Form Wizard

    View Sample

    Simplifying Data Input with a Form

    View Sample

    Working with Application Part Forms

    View Sample
    14. Customizing a Form
    View Sample

    Aligning and Sizing Controls in Design View

    View Sample

    Enhancing the Look of a Form

    View Sample

    Setting Control Properties for Client Forms

    View Sample

    Setting Client Form Properties

    View Sample

    Setting Client Form and Control Defaults

    View Sample

    Working with Web Forms in Layout View

    View Sample

    Starting from Scratch—A Simple Input Web Form

    View Sample

    Setting Control Properties for Web Forms

    View Sample

    Setting Web Form Properties

    View Sample

    Using Themes

    View Sample

    Working with Shared Resources

    View Sample
    15. Advanced Form Design
    View Sample

    Basing a Form on a Multiple-Table Query

    View Sample

    Creating and Embedding Subforms

    View Sample

    Displaying Values in an Option Group

    View Sample

    Using Conditional Formatting in Client Forms

    View Sample

    Working with the Tab Control

    View Sample

    Creating Multiple-Page Client Forms

    View Sample

    Working with Client PivotChart Forms

    View Sample

    Working with Navigation Controls

    View Sample

    Using Web Browser Controls

    View Sample

    V. Working with Reports

    View Sample
    16. Using Reports
    View Sample

    Uses of Reports

    View Sample

    A Tour of Reports

    View Sample

    Printing Reports

    View Sample
    17. Constructing a Report
    View Sample

    Starting from Scratch—A Simple Report

    View Sample

    Using the Report Command

    View Sample

    Using the Report Wizard

    View Sample

    Working with Web Reports in Layout View

    View Sample

    Building a Web Report in Layout View

    View Sample

    Understanding Web Report Limitations

    View Sample
    18. Advanced Report Design
    View Sample

    Building a Query for a Complex Report

    View Sample

    Creating the Basic Facility Occupancy By Date Report

    View Sample

    Defining the Grouping and Sorting Criteria

    View Sample

    Setting Section and Report Properties

    View Sample

    Using Calculated Values

    View Sample

    Creating and Embedding a Subreport

    View Sample

    Adding a PivotChart to a Client Report

    View Sample

    VI. Automating an Access Application Using Macros

    View Sample
    19. Understanding Event Processing
    View Sample

    Access as a Windows Event-Driven Application

    View Sample

    Summary of Form and Report Events

    View Sample

    Understanding Event Sequence and Form Editing

    View Sample
    20. Automating a Client Application Using Macros
    View Sample

    Uses of Macros

    View Sample

    The Macro Design Facility—An Overview

    View Sample

    Defining Multiple Actions

    View Sample

    Working with Submacros

    View Sample

    Understanding Conditional Expressions

    View Sample

    Using Embedded Macros

    View Sample

    Using Temporary Variables

    View Sample

    Trapping Errors in Macros

    View Sample

    Understanding Macro Actions That Are Not Trusted

    View Sample

    Making Your Application Come Alive with Macros

    View Sample
    21. Automating a Web Application Using Macros
    View Sample

    Creating Web Macros

    View Sample

    Using Macro Objects for Common Functionality

    View Sample

    Working with Web Form and Control Events

    View Sample

    Passing Parameters to Forms and Reports

    View Sample

    Exploring the Invoice Audit Web Form Macros

    View Sample

    Checking SharePoint User Permission Group Levels

    View Sample

    Performing Different Actions When Opening a Web Form in a Browser

    View Sample

    Avoiding Type Coercion Issues

    View Sample

    VII. Working with the Web

    View Sample
    22. Using Web Applications in a Browser
    View Sample

    Working with SharePoint

    View Sample

    Publishing Your Database to an Access Services Site

    View Sample

    Working with Your Application in a Web Browser

    View Sample

    Exploring the Access Services Shell

    View Sample

    Working with the Recycle Bin

    View Sample

    Extending Your Access Services Application

    View Sample

    Using Your Published Web Database in Access

    View Sample

    Instantiating an Access Services Template

    View Sample
    23. Using Business Connectivity Services
    View Sample

    Understanding Web Services

    View Sample

    Introducing Business Connectivity Services

    View Sample

    Using XML

    View Sample

    Working with BDC Model Definition Files

    View Sample

    Generating Entities

    View Sample

    Connecting Data Services in Access

    View Sample
    A. Installing Your Software
    View Sample

    Installing the Office System

    View Sample

    Converting from a Previous Version of Access

    View Sample

    Installing the Office 64-Bit Version

    View Sample

    Installing the Sample Files

    View Sample

    B. About the Authors

    View Sample

    Index

    View Sample

    VIII. Automating an Access Application Using Visual Basic

    View Sample
    24. Understanding Visual Basic Fundamentals
    View Sample

    The Visual Basic Development Environment

    View Sample

    Variables and Constants

    View Sample

    Declaring Constants and Variables

    View Sample

    Collections, Objects, Properties, and Methods

    View Sample

    Functions and Subroutines

    View Sample

    Understanding Class Modules

    View Sample

    Controlling the Flow of Statements

    View Sample

    Running Macro Actions and Menu Commands

    View Sample

    Trapping Errors

    View Sample

    Some Complex Visual Basic Examples

    View Sample

    Working with 64-Bit Access Visual Basic for Applications

    View Sample
    25. Automating Your Application with Visual Basic
    View Sample

    Why Aren’t We Using Macros?

    View Sample

    Assisting Data Entry

    View Sample

    Validating Complex Data

    View Sample

    Controlling Tabbing on a Multiple-Page Form

    View Sample

    Automating Data Selection

    View Sample

    Linking to Related Data in Another Form or Report

    View Sample

    Automating Complex Tasks

    View Sample

    Automating Reports

    View Sample

    Calling Named Data Macros

    View Sample

    IX. After Completing Your Application

    View Sample
    26. The Finishing Touches
    View Sample

    Creating Custom Ribbons with XML

    View Sample

    Loading Ribbon XML

    View Sample

    Using Ribbon Attributes

    View Sample

    Disabling Layout View

    View Sample

    Controlling How Your Application Starts and Runs

    View Sample

    Performing a Final Visual Basic Compile

    View Sample
    27. Distributing Your Application
    View Sample

    Using Linked Tables in a Desktop Database

    View Sample

    Understanding Runtime Mode

    View Sample

    Creating a Database Template

    View Sample

    Creating Custom Data Type Parts

    View Sample

    Creating an Execute-Only Database

    View Sample

    Creating an Application Shortcut

    View Sample

    Encrypting Your Database

    View Sample

    Packaging and Signing Your Database

    View Sample
    28. Article 1 Designing Your Database Application
    View Sample

    Application Design Fundamentals

    View Sample

    An Application Design Strategy

    View Sample

    Data Analysis

    View Sample

    Database Design Concepts

    View Sample

    When to Break the Rules

    View Sample
    29. Article 2 Understanding SQL
    View Sample

    SQL SELECT Queries

    View Sample

    SQL Action Queries

    View Sample
    30. Article 3 Exporting Data
    View Sample

    Exporting to Another Access Database

    View Sample

    Exporting to a Spreadsheet or to a dBASE File

    View Sample

    Exporting to a Text File

    View Sample

    Exporting to a Mail Merge Document in Word

    View Sample

    Exporting to an ODBC Database

    View Sample

    Exporting Data to SharePoint

    View Sample

    31. Article 4 Function Reference

    View Sample

    32. Article 5 Color Names and Codes

    View Sample

    33. Article 6 Macro Actions

    View Sample

    About the Authors

    View Sample

    Copyright

    Extras

    The publisher has provided additional content related to this title.


    Description
    Content

    Visit the catalog page for Microsoft® Access® 2010 Inside Out

    • Catalog Page

    Visit the errata page for Microsoft® Access® 2010 Inside Out

    • Errata

    Download the supplemental electronic content for Microsoft® Access® 2010 Inside Out

    • Supplemental Content