Microsoft Access 2010 Inside Out
by Conrad, Jeff; Viescas, John L.Edition: 1st
Format: Paperback
Pub. Date: 2010-08-15
Publisher(s): Microsoft Press
Other versions by this Author
List Price: $54.99
Rent Book
Select for Price
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
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
Author Biography
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 | |
| 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. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.