25 Women to Read Before You Die
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Original Essays | August 18, 2015

    Rinker Buck: IMG Just Passing Through: Embracing the Covered Wagon Mind-Set



    When people learn that I recently spent a long summer riding 2,000 miles across the Oregon Trail in a covered wagon pulled by mules, they invariably... Continue »
    1. $19.60 Sale Hardcover add to wish list

    spacer
Qualifying orders ship free.
$54.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
5 Local Warehouse Personal Computers- Desktop Applications- Databases

Microsoft Access 2010 Inside Out

by

Microsoft Access 2010 Inside Out Cover

 

Synopses & Reviews

Publisher Comments:

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 Access 2010 — and challenge yourself to new levels of mastery!
  • Master essential data management and design techniques
  • Import and link to data from spreadsheets, databases, text files, and other sources
  • Use action queries to quickly insert, update, or delete entire sets of data
  • Create custom forms to capture and display data
  • Design reports to calculate, summarize, and highlight critical data--and learn advanced techniques
  • Automate your application with macros and Visual Basic for Applications (VBA)
  • Use Access Services to extend your database application to the Web
  • Try out the sample client and web database applications in both 32-bit and 64-bit versions
A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. The sample client and web database applications are provided in both 32-bit and 64-bit versions. Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions.

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Synopsis:

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 Access 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 Microsoft Visual Basic® for Applications
  • Customize the Office Fluent™ Ribbon
  • Explore using XML and Windows® SharePoint® Services to create Web-based applications

About the Author

Jeff Conrad has been an active participant in the Access newsgroups for many years. Best known as the Access Junkie, he maintains a website (accessjunkie.com) that provides useful information and resources for those needing help with Access. He owns Conrad Systems Development, a company that creates custom database and spreadsheet applications for the food service industry.

John L. Viescas is a database expert who provides consulting and training services to companies around the globe. He is a Microsoft MVP and the author of several popular books, including Microsoft® Office Access® 2003 Inside Out and Building Microsoft® Access® Applications.

Table of Contents

; Acknowledgments; About the CD; Whats 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; Chapter 1: What Is Access?; 1.1 What Is a Database?; 1.2 Access as an RDBMS; 1.3 Access as an Application Development System; 1.4 Deciding to Move to Database Software; 1.5 Extending the Power of Access to the Web; Chapter 2: Exploring the Access 2010 Interface; 2.1 Opening Access for the First Time; 2.2 Getting Started with Access 2010; 2.3 Understanding Content Security; 2.4 Understanding the Office Fluent Ribbon; 2.5 Understanding the Navigation Pane; 2.6 Using the Single-Document vs. the Multiple-Document Interface; 2.7 Modifying Global Settings via the Access Options Dialog Box; Chapter 3: Access 2010 Overview; 3.1 The Architecture of Access; 3.2 Exploring a Desktop Database—Housing Reservations; 3.3 What Happened to Project Files (ADP)?; 3.4 The Many Faces of Access; Creating a Database and Tables; Chapter 4: Designing Client Tables; 4.1 Creating a New Database; 4.2 Creating Your First Simple Table by Entering Data; 4.3 Creating a Table Using Application Parts; 4.4 Creating a Table Using Data Type Parts; 4.5 Creating a Table in Design View; 4.6 Defining Fields; 4.7 Defining a Primary Key; 4.8 Defining a Table Validation Rule; 4.9 Understanding Other Table Properties; 4.10 Defining Relationships; 4.11 Adding Indexes; 4.12 Setting Table Design Options; 4.13 Creating a Default Template for New Databases; 4.14 Printing a Table Definition; 4.15 Database Limitations; Chapter 5: Modifying Your Table Design; 5.1 Before You Get Started; 5.2 Deleting Tables; 5.3 Renaming Tables; 5.4 Changing Field Names; 5.5 Moving Fields; 5.6 Inserting Fields; 5.7 Copying Fields; 5.8 Deleting Fields; 5.9 Changing Data Attributes; 5.10 Reversing Changes; 5.11 Using the Table Analyzer Wizard; 5.12 Taking a Look at Lookup Properties; 5.13 Working with Multi-Value Lookup Fields; 5.14 Changing the Primary Key; 5.15 Compacting Your Database; Chapter 6: Designing Web Tables; 6.1 Working with the Web; 6.2 Creating a New Web Database; 6.3 Creating Your First Simple Web Table by Entering Data; 6.4 Creating a Web Table Using Application Parts; 6.5 Using Data Type Parts; 6.6 Creating Web Tables in Datasheet View; 6.7 Defining a Table Validation Rule for Web Databases; 6.8 Defining a Primary Key for Web Databases; 6.9 Understanding Other Web Table Properties; 6.10 Creating Lookup Fields in a Web Database; 6.11 Creating Relationships Using Lookup Fields; 6.12 Using the Web Compatibility Checker; Chapter 7: Creating Table Data Macros; 7.1 Uses of Data Macros; 7.2 The Data Macro Design Facility—An Overview; 7.3 Working with Before Events; 7.4 Working with After Events; 7.5 Working with Named Data Macros; 7.6 Debugging Data Macros; 7.7 Understanding Recursion in Data Macros; 7.8 Sharing Data Macro Logic; Chapter 8: Importing and Linking Data; 8.1 A Word About Open Database Connectivity (ODBC); 8.2 Creating a Data Source to Link to an ODBC Database; 8.3 Importing vs. Linking Database Files; 8.4 Importing Data and Databases; 8.5 Importing Spreadsheet Data; 8.6 Importing Text Files; 8.7 Modifying Imported Tables; 8.8 Linking Files; 8.9 Collecting Data via Email; 8.10 Importing and Linking SharePoint Data; 8.11 Saving Import Procedures; Building Queries; Chapter 9: Creating and Working with Simple Queries; 9.1 Selecting Data from a Single Table; 9.2 Testing Validation Rule Changes; 9.3 Working in Query Datasheet View; Chapter 10: Building Complex Queries; 10.1 Selecting Data from Multiple Tables; 10.2 Using a Query Wizard; 10.3 Summarizing Information with Totals Queries; 10.4 Using Query Parameters; 10.5 Customizing Query Properties; 10.6 Editing and Creating Queries in SQL View; 10.7 Limitations on Using Select Queries to Update Data; 10.8 Creating PivotTables and PivotCharts from Queries; 10.9 Creating Queries for the Web; Chapter 11: Modifying Data with Action Queries; 11.1 Updating Groups of Rows; 11.2 Creating a New Table with a Make-Table Query; 11.3 Inserting Data from Another Table; 11.4 Deleting Groups of Rows; 11.5 Troubleshooting Action Queries; Creating Forms; Chapter 12: Using Forms in an Access Application; 12.1 Uses of Forms; 12.2 A Tour of Forms; 12.3 Understanding Web Form Limitations; 12.4 Moving Around on Forms and Working with Data; 12.5 Adding Records and Changing Data; 12.6 Searching for and SSSSSSorting Data; 12.7 Printing Forms; Chapter 13: Building a Form; 13.1 Forms and Object-Oriented Programming; 13.2 Starting from Scratch—A Simple Input Form; 13.3 Working with Quick Create and the Form Wizard; 13.4 Simplifying Data Input with a Form; 13.5 Working with Application Part Forms; Chapter 14: Customizing a Form; 14.1 Aligning and Sizing Controls in Design View; 14.2 Enhancing the Look of a Form; 14.3 Setting Control Properties for Client Forms; 14.4 Setting Client Form Properties; 14.5 Setting Client Form and Control Defaults; 14.6 Working with Web Forms in Layout View; 14.7 Starting from Scratch—A Simple Input Web Form; 14.8 Setting Control Properties for Web Forms; 14.9 Setting Web Form Properties; 14.10 Using Themes; 14.11 Working with Shared Resources; Chapter 15: Advanced Form Design; 15.1 Basing a Form on a Multiple-Table Query; 15.2 Creating and Embedding Subforms; 15.3 Displaying Values in an Option Group; 15.4 Using Conditional Formatting in Client Forms; 15.5 Working with the Tab Control; 15.6 Creating Multiple-Page Client Forms; 15.7 Working with Client PivotChart Forms; 15.8 Working with Navigation Controls; 15.9 Using Web Browser Controls; Working with Reports; Chapter 16: Using Reports; 16.1 Uses of Reports; 16.2 A Tour of Reports; 16.3 Printing Reports; Chapter 17: Constructing a Report; 17.1 Starting from Scratch—A Simple Report; 17.2 Using the Report Command; 17.3 Using the Report Wizard; 17.4 Working with Web Reports in Layout View; 17.5 Building a Web Report in Layout View; 17.6 Understanding Web Report Limitations; Chapter 18: Advanced Report Design; 18.1 Building a Query for a Complex Report; 18.2 Creating the Basic Facility Occupancy By Date Report; 18.3 Defining the Grouping and Sorting Criteria; 18.4 Setting Section and Report Properties; 18.5 Using Calculated Values; 18.6 Creating and Embedding a Subreport; 18.7 Adding a PivotChart to a Client Report; Automating an Access Application Using Macros; Chapter 19: Understanding Event Processing; 19.1 Access as a Windows Event-Driven Application; 19.2 Summary of Form and Report Events; 19.3 Understanding Event Sequence and Form Editing; Chapter 20: Automating a Client Application Using Macros; 20.1 Uses of Macros; 20.2 The Macro Design Facility—An Overview; 20.3 Defining Multiple Actions; 20.4 Working with Submacros; 20.5 Understanding Conditional Expressions; 20.6 Using Embedded Macros; 20.7 Using Temporary Variables; 20.8 Trapping Errors in Macros; 20.9 Understanding Macro Actions That Are Not Trusted; 20.10 Making Your Application Come Alive with Macros; Chapter 21: Automating a Web Application Using Macros; 21.1 Creating Web Macros; 21.2 Using Macro Objects for Common Functionality; 21.3 Working with Web Form and Control Events; 21.4 Passing Parameters to Forms and Reports; 21.5 Exploring the Invoice Audit Web Form Macros; 21.6 Checking SharePoint User Permission Group Levels; 21.7 Performing Different Actions When Opening a Web Form in a Browser; 21.8 Avoiding Type Coercion Issues; Working with the Web; Chapter 22: Using Web Applications in a Browser; 22.1 Working with SharePoint; 22.2 Publishing Your Database to an Access Services Site; 22.3 Working with Your Application in a Web Browser; 22.4 Exploring the Access Services Shell; 22.5 Working with the Recycle Bin; 22.6 Extending Your Access Services Application; 22.7 Using Your Published Web Database in Access; 22.8 Instantiating an Access Services Template; Chapter 23: Using Business Connectivity Services; 23.1 Understanding Web Services; 23.2 Introducing Business Connectivity Services; 23.3 Using XML; 23.4 Working with BDC Model Definition Files; 23.5 Generating Entities; 23.6 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;

Product Details

ISBN:
9780735626850
Author:
Conrad, Jeff
Publisher:
Microsoft Press
Author:
Viescas, John
Author:
Viescas, John L.
Subject:
Desktop Applications - MS Access
Subject:
Database design
Subject:
Personal Computers-Desktop Applications-Databases
Subject:
Database Management - General
Edition Description:
Trade Paper
Series:
Inside Out
Publication Date:
20100831
Binding:
TRADE PAPER
Language:
English
Pages:
1500
Dimensions:
9.00 x 7.38 in

Other books you might like

  1. Inside Relational Databases with... New Trade Paper $54.95
  2. Microsoft Access 2010 Step by Step Used Trade Paper $18.00

Related Subjects


Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Databases
Engineering » Civil Engineering » General
Religion » Comparative Religion » General
Travel » Travel Writing » General

Microsoft Access 2010 Inside Out New Trade Paper
0 stars - 0 reviews
$54.99 In Stock
Product details 1500 pages Microsoft Press - English 9780735626850 Reviews:
"Synopsis" by ,

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 Access 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 Microsoft Visual Basic® for Applications
  • Customize the Office Fluent™ Ribbon
  • Explore using XML and Windows® SharePoint® Services to create Web-based applications

spacer
spacer
  • back to top

FOLLOW US ON...

       
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.