Microsoft Access 2010 Inside Out

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780735626850 | 0735626855
Cover: Paperback
Copyright: 8/15/2010

eBook

Available Instantly

Online: 1825 Days

Downloadable: Lifetime Access

$56.91

You're beyond the basics, so dive right in and really put your database skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Accessr 2010 -- and challenge yourself to new levels of mastery! Create tables that support your database design strategy Import and link to data from spreadsheets, text files, databases, and other ODBC data sources Build simple to complex queries to manipulate data Learn advanced techniques for building and customizing user interface forms Design attractive reports to calculate and analyze large sets of data Automate your application with Microsoftr Visual Basicr for Applications Customize the Office Fluent'„¢ Ribbon Explore using XML and Windowsr SharePointr Services to create Web-based applications

Acknowledgments
About the CD
What's on the CD
Sample Applications
System Requirements
Support Information
Conventions and Features Used in This Book
Text Conventions
Design Conventions
Syntax Conventions
Introduction
Getting Familiar with Access 2010
About This Book
Understanding Access
What Is Access?
What Is a Database?
Access as an RDBMS
Access as an Application Development System
Deciding to Move to Database Software
Extending the Power of Access to the Web
Exploring the Access 2010 Interface
Opening Access for the First Time
Getting Started with Access 2010
Understanding Content Security
Understanding the Office Fluent Ribbon
Understanding the Navigation Pane
Using the Single-Document vs. the Multiple-Document Interface
Modifying Global Settings via the Access Options Dialog Box
Access 2010 Overview
The Architecture of Access
Exploring a Desktop Database—Housing Reservations
What Happened to Project Files (ADP)?
The Many Faces of Access; Creating a Database and Tables
Designing Client Tables
Creating a New Database
Creating Your First Simple Table by Entering Data
Creating a Table Using Application Parts
Creating a Table Using Data Type Parts
Creating a Table in Design View
Defining Fields
Defining a Primary Key
Defining a Table Validation Rule
Understanding Other Table Properties
Defining Relationships
Adding Indexes
Setting Table Design Options
Creating a Default Template for New Databases
Printing a Table Definition
Database Limitations
Modifying Your Table Design
Before You Get Started
Deleting Tables
Renaming Tables
Changing Field Names
Moving Fields
Inserting Fields
Copying Fields
Deleting Fields
Changing Data Attributes
Reversing Changes
Using the Table Analyzer Wizard
Taking a Look at Lookup Properties
Working with Multi-Value Lookup Fields
Changing the Primary Key
Compacting Your Database
Designing Web Tables
Working with the Web
Creating a New Web Database
Creating Your First Simple Web Table by Entering Data
Creating a Web Table Using Application Parts
Using Data Type Parts
Creating Web Tables in Datasheet View
Defining a Table Validation Rule for Web Databases
Defining a Primary Key for Web Databases
Understanding Other Web Table Properties
Creating Lookup Fields in a Web Database
Creating Relationships Using Lookup Fields
Using the Web Compatibility Checker
Creating Table Data Macros
Uses of Data Macros
The Data Macro Design Facility—An Overview
Working with Before Events
Working with After Events
Working with Named Data Macros
Debugging Data Macros
Understanding Recursion in Data Macros
Sharing Data Macro Logic
Importing and Linking Data
A Word About Open Database Connectivity (ODBC)
Creating a Data Source to Link to an ODBC Database
Importing vs. Linking Database Files
Importing Data and Databases
Importing Spreadsheet Data
Importing Text Files
Modifying Imported Tables
Linking Files
Collecting Data via Email
Importing and Linking SharePoint Data
Saving Import Procedures; Building Queries
Creating and Working with Simple Queries
Selecting Data from a Single Table
Testing Validation Rule Changes
Working in Query Datasheet View
Building Complex Queries
Selecting Data from Multiple Tables
Using a Query Wizard
Summarizing Information with Totals Queries
Using Query Parameters
Customizing Query Properties
Editing and Creating Queries in SQL View
Limitations on Using Select Queries to Update Data
Creating PivotTables and PivotCharts from Queries
Creating Queries for the Web
Modifying Data with Action Queries
Updating Groups of Rows
Creating a New Table with a Make-Table Query
Inserting Data from Another Table
Deleting Groups of Rows
Troubleshooting Action Queries; Creating Forms
Using Forms in an Access Application
Uses of Forms
A Tour of Forms
Understanding Web Form Limitations
Moving Around on Forms and Working with Data
Adding Records and Changing Data
Searching for and SSSSSSorting Data
Printing Forms
Building a Form
Forms and Object-Oriented Programming
Starting from Scratch—A Simple Input Form
Working with Quick Create and the Form Wizard
Simplifying Data Input with a Form
Working with Application Part Forms
Customizing a Form
Aligning and Sizing Controls in Design View
Enhancing the Look of a Form
Setting Control Properties for Client Forms
Setting Client Form Properties
Setting Client Form and Control Defaults
Working with Web Forms in Layout View
Starting from Scratch—A Simple Input Web Form
Setting Control Properties for Web Forms
Setting Web Form Properties
Using Themes
Working with Shared Resources
Advanced Form Design
Basing a Form on a Multiple-Table Query
Creating and Embedding Subforms
Displaying Values in an Option Group
Using Conditional Formatting in Client Forms
Working with the Tab Control
Creating Multiple-Page Client Forms
Working with Client PivotChart Forms
Working with Navigation Controls
Using Web Browser Controls; Working with Reports
Using Reports
Uses of Reports
A Tour of Reports
Printing Reports
Constructing a Report
Starting from Scratch—A Simple Report
Using the Report Command
Using the Report Wizard
Working with Web Reports in Layout View
Building a Web Report in Layout View
Understanding Web Report Limitations
Advanced Report Design
Building a Query for a Complex Report
Creating the Basic Facility Occupancy By Date Report
Defining the Grouping and Sorting Criteria
Setting Section and Report Properties
Using Calculated Values
Creating and Embedding a Subreport
Adding a PivotChart to a Client Report; Automating an Access Application Using Macros
Understanding Event Processing
Access as a Windows Event-Driven Application
Summary of Form and Report Events
Understanding Event Sequence and Form Editing
Automating a Client Application Using Macros
Uses of Macros
The Macro Design Facility—An Overview
Defining Multiple Actions
Working with Submacros
Understanding Conditional Expressions
Using Embedded Macros
Using Temporary Variables
Trapping Errors in Macros
Understanding Macro Actions That Are Not Trusted
Making Your Application Come Alive with Macros
Automating a Web Application Using Macros
Creating Web Macros
Using Macro Objects for Common Functionality
Working with Web Form and Control Events
Passing Parameters to Forms and Reports
Exploring the Invoice Audit Web Form Macros
Checking SharePoint User Permission Group Levels
Performing Different Actions When Opening a Web Form in a Browser
Avoiding Type Coercion Issues; Working with the Web
Using Web Applications in a Browser
Working with SharePoint
Publishing Your Database to an Access Services Site
Working with Your Application in a Web Browser
Exploring the Access Services Shell
Working with the Recycle Bin
Extending Your Access Services Application
Using Your Published Web Database in Access
Instantiating an Access Services Template
Using Business Connectivity Services
Understanding Web Services
Introducing Business Connectivity Services
Using XML
Working with BDC Model Definition Files
Generating Entities
Connecting Data Services in Access
Installing Your Software
Installing the Office System
Converting from a Previous Version of Access
Installing the Office 64-Bit Version
Installing the Sample Files
About The Authors
Table of Contents provided by Publisher. All Rights Reserved.

Please wait while the item is added to your bag...

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Microsoft Access 2010 Inside Out

Summary

Author Biography

Table of Contents

Supplemental Materials