jump to navigation

O’Reilly Acces 2010, The Missing Manual 13 octubre, 2010

Posted by omnimikemx in Bases de Datos.

Get the guide that makes learning Microsoft Access 2010 plain and simple! This full color, no-nonsense book shows you the quickest ways to build a database and sort information, using easy-to-follow steps and concise, straightforward language. You’ll learn how out-of-the-box templates and reusable components make Access 2010 a fast and simple database solution.

Here’s WHAT you’ll learn:

  • Design and build your own database quickly
  • Use Access forms to collect information with ease
  • Create and modify tables to organize your data
  • Store files such as documents and images
  • Exchange data with other databases and documents
  • Bring your data alive with colorful reports

Here’s HOW you’ll learn it:

  • Jump in whenever you need answers
  • Easy-to-follow STEPS and SCREENSHOTS show exactly what to do
  • Handy TIPS teach new techniques and shortcuts
  • Quick TRY THIS! exercises help apply what you learn right away
  1. Chapter 1 Introduction: About This Book

    1. No Computerese!

    2. A Quick Overview

    3. A Few Assumptions

    4. A Final Word (or Two)

  2. Chapter 2 What’s New in Access 2010?

    1. Managing Access Settings and Files in Backstage View

    2. Customizing the Access 2010 User Interface

    3. Creating Databases Using Improved Templates

    4. Building Databases by Re-Using Application Parts

    5. Creating Navigation Forms

    6. Formatting Database Objects Using Office Themes

    7. Gaining Insights into Data Using Conditional Formatting

    8. Defining Calculated Fields Using the Improved Expression Builder

  3. Chapter 3 Introducing Access 2010

    1. Introducing Databases

    2. Starting Access 2010

    3. Surveying the Access 2010 Window

    4. Opening a Database

    5. Viewing Multiple Database Objects

    6. Closing a Database and Exiting Access 2010

    7. Displaying and Managing Database Objects

    8. Using the Access 2010 Help System

  4. Chapter 4 Creating a Database

    1. Designing a Database

    2. Viewing a Sample Database

    3. Creating a New Database

    4. Creating Databases Using Database Templates

    5. Creating a New Table in Design View

    6. Creating a New Table by Typing

    7. Creating a New Table Using a Template

    8. Creating a New Table Using Application Parts

    9. Setting a Primary Key

    10. Getting Data from Other Access 2010 Tables

    11. Relationships Explained

    12. Creating Relationships Between Tables

    13. Enforcing Referential Integrity

  5. Chapter 5 Customizing Fields

    1. Working with Tables

    2. Assigning a Data Type

    3. Viewing or Changing Field Properties

    4. Introducing the Expression Builder

    5. Formatting Field Contents

    6. Creating Input Masks

    7. Assigning Required Fields and Requiring Data Entry

    8. Setting Default Values

    9. Indexing Field Values

    10. Validating Data Entry

    11. Creating a Lookup Field

    12. Creating an Append-Only Memo Field

    13. Creating an Attachment Field

  6. Chapter 6 Customizing Tables

    1. Finding and Replacing Text

    2. Entering Data Using AutoCorrect

    3. Adding and Editing Text

    4. Manipulating Columns

    5. Modifying Columns and Rows

    6. Viewing a Subworksheet

    7. Filtering Table Records

  7. Chapter 7 Creating Forms

    1. Creating a Simple Form

    2. Creating a Form Using the Form Wizard

    3. Creating a Form in Design View

    4. Creating a Multiple Items Form

    5. Modifying an Existing Form

    6. Adding and Deleting Form Controls

    7. Adding a Date Picker Control

    8. Creating a Subform

    9. Displaying a Form and Its Datasheet Simultaneously

  8. Chapter 8 Creating Queries

    1. Introducing Query Types

    2. Creating a Query Using the Query Wizard

    3. Editing a Query in Design View

    4. Using Criteria to Focus Query Results

    5. Introducing Operators

    6. Using Queries to Calculate Values

    7. Creating a Parameter Query

    8. Finding Duplicate Records

    9. Finding Unmatched Records

    10. Writing Query Results to a New Table

    11. Creating an Update Query

    12. Creating a Crosstab Query

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

  9. Chapter 9 Creating Reports

    1. Creating a Report Using the Report Wizard

    2. Creating a Summary Report

    3. Creating a Report in Design View

    4. Modifying an Existing Report

    5. Adding and Deleting Report Controls

    6. Calculating Values in a Report

    7. Introducing Report Sections

    8. Grouping Report Records

    9. Creating a Subform or Subreport

    10. Creating Mailing Labels

  10. Chapter 10 Beautifying Forms and Reports

    1. Formatting Text

    2. Introducing Office Themes

    3. Applying Office Themes

    4. Setting Control Appearance

    5. Adding Lines, Shapes, and Borders

    6. Showing Gridlines in a Report

    7. Coloring Alternate Rows in a Form or Report

    8. Adding a Totals Row to a Worksheet

    9. Adding a Picture

    10. Applying Conditional Formatting

    11. Changing the Source of an Image

    12. Setting Image Alignment and Backing Color

    13. Tiling a Picture

    14. Setting Image Height and Width

  11. Chapter 11 Creating Charts in Access 2010

    1. Creating a Chart

    2. Formatting Chart Elements

    3. Customizing Chart Axes

    4. Add Information to a Chart

    5. Changing a Chart’s Type

  12. Chapter 12 Interacting with Other Programs

    1. Introducing Linking and Embedding

    2. Inserting a New Object

    3. Manipulating Objects

    4. Inserting Excel 2010 Charts and Worksheets

    5. Importing Data from Another Access 2010 Database

    6. Linking to a Table in Another Access 2010 Database

    7. Working with Hyperlinks

    8. Importing Data from an Excel 2010 File

    9. Importing Data from a Text File

    10. Importing Data from an XML File

    11. Exporting Data to a Text File

    12. Exporting Data to Another Access 2010 File

    13. Exporting Data to an XML File

    14. Saving Database Objects As Web Files

    15. Analyzing Data with Excel 2010

    16. Publishing Data to Word 2010

    17. Collecting Data from E-mail Messages

  13. Chapter 13 Administering a Database

    1. Introducing Database Security

    2. Encrypting a Database

    3. Locking Database Records

    4. Creating a Navigation Form

    5. Documenting a Database

    6. Setting Startup Options

  14. Chapter 14 Customizing Access 2010

    1. Adding Commands to the Quick Access Toolbar

    2. Modifying the Ribbon User Interface

    3. Changing AutoCorrect Options

  15. Chapter 15 Presenting Table and Query Data Dynamically

    1. Introducing PivotTables and PivotCharts

    2. Creating a PivotTable

    3. Adding and Removing PivotTable Fields

    4. Pivoting a PivotTable

    5. Filtering PivotTable Data

    6. Formatting a PivotTable

    7. Creating a PivotChart

  1. Appendix About the Author





No comments yet — be the first.


Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión /  Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión /  Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión /  Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión /  Cambiar )


Conectando a %s

A %d blogueros les gusta esto: