Access 2010: The Missing Manual

Spis treści ebooka

• Access 2010: The Missing Manual
  • SPECIAL OFFER: Upgrade this ebook with OReilly
  • A Note Regarding Supplemental Files
  • The Missing Credits
    • About the Author
    • About the Creative Team
    • Acknowledgements
    • The Missing Manual Series
  • Introduction
    • What You Can Do with Access
      • The Two Sides of Access
      • Access vs. Excel
      • Access vs. SQL Server
    • The Modern Face of Access
      • Backstage View
      • The Ribbon
      • Using the Ribbon with the Keyboard
      • The Quick Access Toolbar
    • The New Features in Access 2010
    • About This Book
      • About the Outline
      • AboutTheseArrows
        • Contextual tabs
        • Drop-down buttons
        • Backstage view
        • Ordinary menus
      • About Shortcut Keys
      • Examples
      • About MissingManuals.com
      • Safari Books Online
  • One. Storing Information in Tables
    • 1. Creating Your First Database
      • Understanding Access Databases
      • Getting Started with Your First Database
        • Understanding Tables
        • Creating a Simple Table
        • Editing a Table
          • Edit mode
          • Datasheet shortcut keys
          • Cut, copy, and paste
      • Saving Databases
        • Making Backups
        • Saving a Database with a Different Name or Format
        • Shrinking a Database
      • Opening Databases
        • Designating a Database as Trusted
        • Opening Recent Databases
        • Opening More Than One Database at Once
        • Opening a Database Created in an Older Version of Access
      • The Navigation Pane
        • Browsing Tables with the Navigation Pane
        • Managing Database Objects
    • 2. Building Smarter Tables
      • Understanding Data Types
      • Design View
        • Organizing and Describing Your Fields
        • How Updates Work in Design View
      • Access Data Types
        • Text
          • Text length
        • Memo
          • Formatted text
        • Number
          • Number size
          • Number formatting
        • Currency
        • Date/Time
          • Custom date formats
        • Yes/No
        • Hyperlink
        • Attachment
        • AutoNumber
          • Using AutoNumbers without revealing the size of your table
          • Using replication IDs
        • Calculated
      • The Primary Key
        • Creating Your Own Primary Key Field
      • Six Principles of Database Design
        • 1. Choose Good Field Names
        • 2. Break Down Your Information
        • 3. Include All the Details in One Place
        • 4. Avoid Duplicating Information
        • 5. Avoid Redundant Information
        • 6. Include an ID Field
    • 3. Mastering the Datasheet: Sorting, Searching, Filtering, and More
      • Datasheet Customization
        • Formatting the Datasheet
        • Rearranging Columns
        • Resizing Rows and Columns
        • Hiding Columns
        • Freezing Columns
      • Datasheet Navigation
        • Sorting
          • Sorting on multiple fields
        • Filtering
          • Quick filters
          • Filter by selection
          • Filter by condition
        • Searching
      • Advanced Editing
        • The Spell Checker
          • Spell-checking options
        • AutoCorrect
        • Special Characters
      • Printing the Datasheet
        • Print Preview
          • Moving around the print preview
          • Changing the page layout
        • Fine-Tuning a Printout
    • 4. Blocking Bad Data
      • Data Integrity Basics
        • Preventing Blank Fields
          • Blank values and empty text
        • Setting Default Values
        • Preventing Duplicate Values with Indexes
          • Multifield indexes
      • Input Masks
        • Using a Readymade Mask
        • Creating Your Own Mask
      • Validation Rules
        • Applying a Field Validation Rule
        • Writing a Field Validation Rule
          • Validating numbers
          • Validating dates
          • Validating text
          • Combining validation conditions
        • Creating a Table Validation Rule
      • Lookups
        • Creating a Simple Lookup with Fixed Values
        • Adding New Values to Your Lookup List
    • 5. Linking Tables with Relationships
      • Relationship Basics
        • Redundant Data vs. Related Data
        • Matching Fields: The Relationship Link
        • Linking with the ID Column
        • The Parent-Child Relationship
      • Using a Relationship
        • Defining a Relationship
        • Editing Relationships
        • Referential Integrity
          • Blank values for unlinked records
          • Cascading deletes
          • Cascading updates
        • Navigating a Relationship
        • Lookups with Related Tables
      • More Exotic Relationships
        • One-to-One Relationship
        • Many-to-Many Relationship
          • Junction tables
          • Multi-value fields
      • Relationship Practice
        • The Music School
          • Identifying the tables
          • Identifying the relationships
          • Getting more detailed
        • The Chocolate Store
          • The product catalog and customer list
          • Ordering products
  • Two. Manipulating Data with Queries
    • 6. Queries That Select Records
      • Query Basics
      • Creating Queries
        • Creating a Query in Design View
          • Building filter expressions
          • Getting the top records
        • Creating a Simple Query with the Query Wizard
        • Understanding the SQL View
          • Analyzing a query
          • Creating a union query
      • Queries and Related Tables
        • Joining Tables in a Query
        • Outer Joins
          • Finding unmatched records
        • Multiple Joins
    • 7. Essential Query Tricks
      • Calculated Fields
        • Defining a Calculated Field
        • Simple Math with Numeric Fields
          • Date fields
          • Order of operations
        • Expressions with Text
      • Query Functions
        • Using a Function
          • Nested functions
        • The Expression Builder
        • Formatting Numbers
        • More Mathematical Functions
        • Text Functions
        • Date Functions
        • Dealing with Blank Values (Nulls)
      • Summarizing Data
        • Grouping a Totals Query
        • Joins in a Totals Query
      • Query Parameters
    • 8. Queries That Update Records
      • Understanding Action Queries
        • Testing Action Queries (Carefully)
        • The Action Query Family
      • Update Queries
      • Append Queries
        • Creating an Append (or Make-Table) Query
        • Getting AutoNumbers to Start at Values Other Than 1
      • Delete Queries
      • Tutorial: Flagging Out-of-Stock Orders
        • Finding Out-of-Stock Items
        • Putting the Orders on Hold
    • 9. Analyzing Data with Crosstab Queries and Pivot Tables
      • Understanding Crosstab Queries
      • Creating Crosstab Queries
        • Creating a Crosstab Query with the Wizard
        • Creating a Crosstab Query from Scratch
      • Pivot Tables
        • Building a Pivot Table
        • Manipulating a Pivot Table
        • Creating a Calculated Field
        • Hiding and Showing Details
        • Filtering Pivot Tables
      • Pivot Charts
        • Choosing a Chart Type
        • Printing a Pivot Chart
  • Three. Printing Reports
    • 10. Creating Reports
      • Report Basics
        • Creating a One-Click Report
        • Building a Report in Layout View
        • The Many Views of a Report
        • Rearranging a Report
      • Printing, Previewing, and Exporting a Report
        • Previewing a Report
        • Export Formats
        • Exporting a Report to a PDF
        • Exporting a Report to a Different Format
      • Formatting a Report
        • Applying a Theme
        • Formatting Columns and Column Headers
          • Formatting numeric fields
          • Alternating row formatting
          • Gridlines
          • Borders
          • Margin and padding
          • Background image
        • Conditional Formatting
        • Data Bars
      • Filtering and Sorting a Report
        • Filtering a Report
        • Sorting a Report
    • 11. Designing Advanced Reports
      • Improving Reports in Design View
        • The Design View Sections
        • Understanding Controls
        • Moving Fields Out of a Layout
        • Adding More Controls
        • Creating a Report from Scratch (in Design View)
      • The Report Wizard
      • The Label Wizard
      • Fine-Tuning Reports with Properties
        • Modifying Common Properties
      • Expressions
      • Grouping
        • Report Grouping
        • Fine-Tuning with the Group, Sort, and Total Pane
          • Sort by
          • Group on
          • With A on top / from smallest to largest
          • By entire value
          • With totaled
          • With title
          • With a header section / with a footer section
          • Keep group together on one page
        • Multiple Groups
  • Four. Building a User Interface with Forms
    • 12. Creating Simple Forms
      • Creating Forms
        • Building a Simple Form
        • Using AutoNumber Fields in Forms
        • Showing Pictures from a Table
      • Using Forms
        • Finding and Editing a Record
        • Adding a Record
        • Deleting a Record
        • Printing Records
      • Sorting and Filtering in a Form
        • Sorting a Form
        • Filtering a Form
        • Using the Filter by Form Feature
        • Saving Filters for the Future
      • Creating Fancy Forms
        • Manipulating Layouts
          • Inserting columns and rows
          • Splitting and merging cells
        • Liberating Controls from Layouts
        • Using Tabular Layouts
        • Showing Multiple Records in any Form
        • Split Forms
        • More Useful Form Properties
      • The Form Wizard
    • 13. Designing Advanced Forms
      • Customizing Forms in Design View
        • Form Sections: The Different Parts of Your Form
        • Adding Controls to Your Form
        • The Control Gallery: A Quick Tour
        • Arranging Controls on Your Form
          • Aligning controls
          • Sizing controls
          • Spacing controls
          • Controls that overlap
        • Anchoring: Automatically Resizing Controls
          • Making controls as wide as the form
          • Making a single control as large as possible
        • Tab Order: Making Keyboard Navigation Easier
      • Taking Control of Controls
        • Locking Down Fields
        • Prevent Errors with Validation
        • Performing Calculations with Expressions
        • Organizing with Tab Controls
        • Going Places with Links
        • Showing Web Pages with the Web Browser
        • Navigating with Lists
        • Performing Actions with Command Buttons
      • Forms and Linked Tables
        • Table Relationships and Simple Forms
        • The Subform Control
        • Creating Customized Subforms
    • 14. Building a Navigation System
      • Mastering the Navigation Pane
        • Configuring the Navigation List
        • Better Filtering
        • Hiding Objects
        • Using Custom Groups
        • Searching the Navigation List
      • Building Forms with Navigation Smarts
        • Custom Menu Forms
        • Designating a Startup Form
        • Compound Forms
        • Showing All Your Forms in a List
      • Navigation Forms
        • Creating a Single-Level Navigation Form
        • Creating a Two-Level Navigation Form
        • Fine-Tuning Your Navigation Buttons
      • Linking to Related Data
        • Showing Linked Records in Separate Forms
        • Showing More Detailed Reports with Links
  • Five. Programming Access
    • 15. Automating Tasks with Macros
      • Macro Essentials
        • Creating a Macro
        • Running a Macro
        • Editing a Macro
        • Finding Actions in the Action Catalog
        • Collapsing, Expanding, and Grouping Macro Actions
        • Solving Macro Problems
      • Macros and Security
        • Unsafe Macro Actions
        • Trusted Databases
        • Temporary Trust
        • The Trust Center
        • Setting Up a Trusted Location
      • Three Macro Recipes
        • Find a Record
        • Print a Report
        • Email Your Data
      • Managing Macros
        • Submacros
        • Assigning a Macro to a Keystroke
        • Configuring a Startup Macro
    • 16. Connecting Macros to Forms and Tables
      • Macro-Powered Forms
        • Understanding Events
        • Attaching a Macro to an Event
        • Reading Arguments from a Form
        • Changing Form Properties
      • Conditional Macros
        • Building a Condition
        • Validating Data with Conditions
        • More Complex Conditional Macros
      • Data Macros
        • Table Events
        • Validation with Before Events
        • Keeping a Change Log
        • Debugging Data Macros
        • An Advanced Data Macro: Synchronizing Data
    • 17. Automating Tasks with Visual Basic
      • The Visual Basic Editor
        • Adding a New Module
        • Writing the Simplest Possible Code Routine
      • Putting Code in a Form
        • Responding to a Form Event
        • Calling the Code in a Module
        • Reading and Writing the Fields on a Form
      • Understanding Objects
        • Properties
        • Methods
        • Events
      • Using Objects
        • Indicating That a Record Has Changed
        • Creating a Mouseover Effect
    • 18. Writing Smarter Code
      • Exploring the VB Language
        • Storing Information in Variables
        • Making Decisions
        • Repeating Actions with a Loop
        • Creating Custom Functions
        • Putting It All Together: A Function for Testing Credit Cards
      • Dealing with Trouble
        • Debugging
        • Error Handling
      • Deeper into Objects
        • The DoCmd Object
        • Converting a Macro to VB Code
      • Using VB to Run a Better Business
        • Keeping a Running Total
        • Getting Price Information
        • Adding a New Product During an Order
        • Managing Order Fulfillment
        • Updating Stock Numbers
  • Six. Sharing Access with the Rest of the World
    • 19. Sharing a Database with Multiple Users
      • Opening Up Your Database to the World
        • How Access Sharing Works
      • Preparing Your Database
        • Understanding Split Databases
        • Splitting a Database with the Wizard
        • How Linked Tables Work
        • Manually Splitting a Database
        • Locking Down Your Front End
        • Sharing a Database with People Who Dont Own Access
      • Playing Well with Others
        • Seeing Changes As They Happen
        • Dealing with Editing Conflicts
        • Using Locks to Stop Overlapping Edits
        • Opening a Database in Exclusive Mode
      • Data Corruption
        • Diagnosing (and Fixing) Corrupt Databases
        • Preventing Corruption
      • Securing Your Database
        • Password-Protecting Your Database
        • Passwords and Split Databases
        • Using Windows File Security
    • 20. Importing and Exporting Data
      • Case for Importing and Exporting
        • Understanding Exports
        • Understanding Imports
      • Using the Clipboard
        • Copying a Table from Access to Somewhere Else
        • Copying Cells from Excel into Access
      • Import and Export Operations
        • Importable File Types
        • Importing Data
        • Importing from an Excel File
        • Importing from a Text File
        • Exportable File Types
        • Exporting Data
        • Reusing Import and Export Settings
      • Access and XML
        • What Is XML, Really?
        • Three Rules of XML
          • The prolog
          • Elements
          • Nesting
        • XML Files and Schemas
        • The Access XML Story
        • Exporting to an XML File
        • Importing from an XML File
      • Collecting Info by Email
        • Creating an Email Message
        • Processing Replies Manually
        • Processing Replies Automatically
        • Managing Your Email Collection Settings
    • 21. Connecting Access to SQL Server
      • Should You Switch to SQL Server?
        • How SQL Server Works
        • A Cheaper SQL Server
      • Getting Started: SQL Server Express
        • Preparing for SQL Server Express
        • Downloading SQL Server Express
        • Installing SQL Server Express
        • Putting SQL Server on the Network
      • Creating a SQL Server Database
        • Upsizing a Database
        • Managing Your Database
        • Creating a SQL Server Database from Scratch
      • Adding Objects to a SQL Server Database
        • Creating a Table
          • SQL Server data types
          • AutoNumber fields
          • Lookups
          • Relationships
        • Understanding Queries
        • Creating a View
    • 22. Connecting Access to SharePoint
      • Understanding SharePoint
        • What You Can Do in SharePoint
      • Setting Up SharePoint
        • Creating a Team Site
        • Customizing Your Site
      • SharePoint and Access
        • Building a List
        • Exporting a Table to SharePoint
        • Importing a List in Access
        • Moving a Whole Database to SharePoint
        • Editing Your SharePoint Data in Access
        • Making Offline Changes
    • 23. Building a Web Database
      • Understanding Web Databases
      • Your First Web Database
        • Creating a New Web Database
        • Client Objects and Web Objects
      • Publishing a Web Database
        • The SharePoint Web Database Page
        • Web Forms
        • Distributing Your Database
        • Synchronizing Your Database
        • Working Offline
      • Delving Deeper into Web Objects
        • Web Forms
        • Web Reports
        • Web Queries
        • Web Macros
      • Converting an Existing Database to a Web Database
        • Checking Web Compatibility
        • Migration Strategies
  • Seven. Appendix
    • A. Customizing Access
      • Adding Your Favorites to the QAT
        • Adding Buttons
        • Customizing Specific Databases
      • Personalizing the Ribbon
        • Changing Existing Tabs
        • Creating Your Own Tab
        • Saving and Reusing Your Custom Ribbon
  • Index
  • About the Author
  • SPECIAL OFFER: Upgrade this ebook with OReilly

pokaż cały spis treści

ukryj recenzje