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 Plain & Simple

    • Microsoft® Access® 2010 Plain & Simple

    • By:

    • Publisher: Microsoft Press

    • Pub. Date:

    • Print ISBN-13: 978-0-7356-2730-7

    • Pages in Print Edition: 288

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

    1ebooken
    Subscriber Reviews • Browse Similar Topics

    Overview

    With this full color, no-nonsense guide, you'll learn the quickest ways to solve a problem or learn a skill with Microsoft Access 2010. Easy-to-follow steps and concise, straightforward language make learning plain and simple!

    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 Plain & Simple

    View Sample
    1. Introduction: About This Book
    View Sample

    No Computerese!

    View Sample

    A Quick Overview

    View Sample

    A Few Assumptions

    View Sample

    A Final Word (or Two)

    View Sample
    2. What’s New in Access 2010?
    View Sample

    Managing Access Settings and Files in Backstage View

    View Sample

    Customizing the Access 2010 User Interface

    View Sample

    Creating Databases Using Improved Templates

    View Sample

    Building Databases by Re-Using Application Parts

    View Sample

    Creating Navigation Forms

    View Sample

    Formatting Database Objects Using Office Themes

    View Sample

    Gaining Insights into Data Using Conditional Formatting

    View Sample

    Defining Calculated Fields Using the Improved Expression Builder

    View Sample
    3. Introducing Access 2010
    View Sample

    Introducing Databases

    View Sample

    Starting Access 2010

    View Sample

    Surveying the Access 2010 Window

    View Sample

    Opening a Database

    View Sample

    Viewing Multiple Database Objects

    View Sample

    Closing a Database and Exiting Access 2010

    View Sample

    Displaying and Managing Database Objects

    View Sample

    Using the Access 2010 Help System

    View Sample
    4. Creating a Database
    View Sample

    Designing a Database

    View Sample

    Viewing a Sample Database

    View Sample

    Creating a New Database

    View Sample

    Creating Databases Using Database Templates

    View Sample

    Creating a New Table in Design View

    View Sample

    Creating a New Table by Typing

    View Sample

    Creating a New Table Using a Template

    View Sample

    Creating a New Table Using Application Parts

    View Sample

    Setting a Primary Key

    View Sample

    Getting Data from Other Access 2010 Tables

    View Sample

    Relationships Explained

    View Sample

    Creating Relationships Between Tables

    View Sample

    Enforcing Referential Integrity

    View Sample
    5. Customizing Fields
    View Sample

    Working with Tables

    View Sample

    Assigning a Data Type

    View Sample

    Viewing or Changing Field Properties

    View Sample

    Introducing the Expression Builder

    View Sample

    Formatting Field Contents

    View Sample

    Creating Input Masks

    View Sample

    Assigning Required Fields and Requiring Data Entry

    View Sample

    Setting Default Values

    View Sample

    Indexing Field Values

    View Sample

    Validating Data Entry

    View Sample

    Creating a Lookup Field

    View Sample

    Creating an Append-Only Memo Field

    View Sample

    Creating an Attachment Field

    View Sample
    6. Customizing Tables
    View Sample

    Finding and Replacing Text

    View Sample

    Entering Data Using AutoCorrect

    View Sample

    Adding and Editing Text

    View Sample

    Manipulating Columns

    View Sample

    Modifying Columns and Rows

    View Sample

    Viewing a Subworksheet

    View Sample

    Filtering Table Records

    View Sample
    7. Creating Forms
    View Sample

    Creating a Simple Form

    View Sample

    Creating a Form Using the Form Wizard

    View Sample

    Creating a Form in Design View

    View Sample

    Creating a Multiple Items Form

    View Sample

    Modifying an Existing Form

    View Sample

    Adding and Deleting Form Controls

    View Sample

    Adding a Date Picker Control

    View Sample

    Creating a Subform

    View Sample

    Displaying a Form and Its Datasheet Simultaneously

    View Sample
    8. Creating Queries
    View Sample

    Introducing Query Types

    View Sample

    Creating a Query Using the Query Wizard

    View Sample

    Editing a Query in Design View

    View Sample

    Using Criteria to Focus Query Results

    View Sample

    Introducing Operators

    View Sample

    Using Queries to Calculate Values

    View Sample

    Creating a Parameter Query

    View Sample

    Finding Duplicate Records

    View Sample

    Finding Unmatched Records

    View Sample

    Writing Query Results to a New Table

    View Sample

    Creating an Update Query

    View Sample

    Creating a Crosstab Query

    View Sample

    Finding the Largest and Smallest Values in a Field by Using a Query

    View Sample
    9. Creating Reports
    View Sample

    Creating a Report Using the Report Wizard

    View Sample

    Creating a Summary Report

    View Sample

    Creating a Report in Design View

    View Sample

    Modifying an Existing Report

    View Sample

    Adding and Deleting Report Controls

    View Sample

    Calculating Values in a Report

    View Sample

    Introducing Report Sections

    View Sample

    Grouping Report Records

    View Sample

    Creating a Subform or Subreport

    View Sample

    Creating Mailing Labels

    View Sample
    10. Beautifying Forms and Reports
    View Sample

    Formatting Text

    View Sample

    Introducing Office Themes

    View Sample

    Applying Office Themes

    View Sample

    Setting Control Appearance

    View Sample

    Adding Lines, Shapes, and Borders

    View Sample

    Showing Gridlines in a Report

    View Sample

    Coloring Alternate Rows in a Form or Report

    View Sample

    Adding a Totals Row to a Worksheet

    View Sample

    Adding a Picture

    View Sample

    Applying Conditional Formatting

    View Sample

    Changing the Source of an Image

    View Sample

    Setting Image Alignment and Backing Color

    View Sample

    Tiling a Picture

    View Sample

    Setting Image Height and Width

    View Sample
    11. Creating Charts in Access 2010
    View Sample

    Creating a Chart

    View Sample

    Formatting Chart Elements

    View Sample

    Customizing Chart Axes

    View Sample

    Add Information to a Chart

    View Sample

    Changing a Chart’s Type

    View Sample
    12. Interacting with Other Programs
    View Sample

    Introducing Linking and Embedding

    View Sample

    Inserting a New Object

    View Sample

    Manipulating Objects

    View Sample

    Inserting Excel 2010 Charts and Worksheets

    View Sample

    Importing Data from Another Access 2010 Database

    View Sample

    Linking to a Table in Another Access 2010 Database

    View Sample

    Working with Hyperlinks

    View Sample

    Importing Data from an Excel 2010 File

    View Sample

    Importing Data from a Text File

    View Sample

    Importing Data from an XML File

    View Sample

    Exporting Data to a Text File

    View Sample

    Exporting Data to Another Access 2010 File

    View Sample

    Exporting Data to an XML File

    View Sample

    Saving Database Objects As Web Files

    View Sample

    Analyzing Data with Excel 2010

    View Sample

    Publishing Data to Word 2010

    View Sample

    Collecting Data from E-mail Messages

    View Sample
    13. Administering a Database
    View Sample

    Introducing Database Security

    View Sample

    Encrypting a Database

    View Sample

    Locking Database Records

    View Sample

    Creating a Navigation Form

    View Sample

    Documenting a Database

    View Sample

    Setting Startup Options

    View Sample
    14. Customizing Access 2010
    View Sample

    Adding Commands to the Quick Access Toolbar

    View Sample

    Modifying the Ribbon User Interface

    View Sample

    Changing AutoCorrect Options

    View Sample
    15. Presenting Table and Query Data Dynamically
    View Sample

    Introducing PivotTables and PivotCharts

    View Sample

    Creating a PivotTable

    View Sample

    Adding and Removing PivotTable Fields

    View Sample

    Pivoting a PivotTable

    View Sample

    Filtering PivotTable Data

    View Sample

    Formatting a PivotTable

    View Sample

    Creating a PivotChart

    View Sample

    A. About the Author

    View Sample

    Index

    View Sample

    About the Author

    View Sample

    Copyright

    Extras

    The publisher has provided additional content related to this title.


    Description
    Content

    Visit the catalog page for Microsoft® Access® 2010 Plain & Simple

    • Catalog Page

    Visit the errata page for Microsoft® Access® 2010 Plain & Simple

    • Errata