Access 2010: The Missing Manual - Helion

ebook

Autor: Matthew MacDonald
ISBN: 978-14-493-9417-2
stron: 834, Format: ebook
Data wydania: 2010-06-18
Księgarnia: Helion

Cena książki: 109,65 zł (poprzednio: 127,50 zł)
Oszczędzasz: 14% (-17,85 zł)

Osoby, które kupiły tę książkę, wybierały także »

Tagi: Access

Unlock the secrets of this powerful database program and discover how to use your data in creative ways. With this book’s easy step-by-step process, you’ll quickly learn how to build and maintain a complete Access database, using Access 2013’s new, simpler user interface and templates. You also get practices and tips from the pros for good database design—ideal whether you’re using Access for school, business, or at home.

The important stuff you need to know:

Build a database with ease. Store information to track numbers, products, documents, and more.
Customize the interface. Build your own forms to make data entry a snap.
Find what you need fast. Search, sort, and summarize huge amounts of information.
Put your data to use. Turn raw info into printed reports with attractive formatting.
Share your data. Collaborate online with SharePoint and the Access web database.
Dive into Access programming. Get tricks and techniques to automate common tasks.
Create rich data connections. Build dynamic links with SQL Server, SharePoint, and other systems.

Osoby które kupowały "Access 2010: The Missing Manual", wybierały także:

Access 2013. Kurs video. Kwerendy baz danych 79,00 zł, (35,55 zł -55%)
Access 2019 PL. Biblia 149,00 zł, (74,50 zł -50%)
Access 2016 PL. Kurs 39,90 zł, (19,95 zł -50%)
Access 2016 PL. Ćwiczenia praktyczne 29,90 zł, (14,95 zł -50%)
Access 2016 PL w biurze i nie tylko 77,00 zł, (38,50 zł -50%)

Spis treści

Access 2010: The Missing Manual eBook -- spis treści

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