Baixe Microsoft Access e Excel: Guia de Aplicação e Automação e outras Notas de estudo em PDF para Engenharia Elétrica, somente na Docsity!
“ARQUIVO EM .PDF” - 753 PÁGINAS (INGLES)
Microsoft® Office
Access 2003: The Complete Reference
Virginia Andersen
McGraw-Hill /Osborne New York Chicago San Francisco Lisbon London Madrid Mexico City Milan New Delhi San Juan Seoul Singapore Sydney Toronto
“ARQUIVO EM .PDF” - 1250 PÁGINAS (INGLES)
PUBLISHED BY Microsoft Press A Division of Microsoft Corporation One Microsoft Way Redmond, Washington 98052- Copyright © 2004 by John L. Viescas
Designing Forms in an Access Project............. 685 Chapter 20 Building Reports in an Access Project............. 701 Part 5
Automating an Access
Application
Chapter 21 Understanding Event Processing................. 713 Chapter 22 Understanding Visual Basic Fundamentals.......... 757 Chapter 23 Automating Your Application with Visual Basic............ 857 Chapter 24 The Finishing Touches........ 927 Part 6
Linking Access and
the Web
Chapter 25 Publishing Data on the Web.... 961 Chapter 26 Creating Static and Dynamic Web Pages.......... 985 Chapter 27 Building Data Access Pages... 1015 Chapter 28 Working with XML and SharePoint............. 1095 Part 7
After Completing Your
Application
Chapter 29 Upsizing a Desktop Application to a Project...... 1133 Chapter 30 Securing Your Database...... 1163 Chapter 31 Distributing Your Application.. 1203 Part 8
Appendix
Appendix Installing Microsoft Office.... 1223 Part 9
Articles
Article 1 Understanding SQL........... A Article 2 Exporting Data............. A Article 3 Visual Basic Function Reference................. A Article 4 Internet Explorer Web Page Color Names............... A
Table of Contents Acknowledgments............................................ xxiii We’d Like to Hear from You!..................................... xxv About the CD.............................................. .xxvii What’s on the CD......................................... xxvii Sample Applications...................................... .xxviii Using the CD............................................ xxixi System Requirements..................................... xxix Support Information....................................... xxix Conventions and Features Used in This Book........................ xxxi Text Conventions......................................... xxxi Design Conventions....................................... xxxi Syntax Conventions...................................... .xxxiii Introduction............................................... .xxxv Microsoft Access Today.................................... xxxvi About This Book......................................... xxxvii Part 1
Understanding Microsoft Access
Chapter 1
What Is Microsoft Access? 3
What Is a Database?........................................ 3 Relational Databases.................................... 4 Database Capabilities................................... 5 Microsoft Access as an RDBMS................................ 6 Data Definition and Storage............................... 6 Data Manipulation...................................... 8 Data Control......................................... 11 Microsoft Access as an Application Development System............. 11 Deciding to Move to Database Software.......................... 13 Chapter 2
The Many Faces of Microsoft Access 17
The Architecture of Microsoft Access............................ 17 Exploring a Desktop Database—Housing Reservations............... 19 Tables.............................................. 23 Queries............................................. 27 Forms.............................................. 29 Reports............................................. 34 Data Access Pages.................................... 38 Macros............................................. 43 Table of Contents viii Modules............................................ 44 Organizing Your Objects................................. 46 Exploring a Project File—LawTrack Contacts....................... 48 Tables.............................................. 48 Views, Functions, and Stored Procedures..................... 50 The Many Faces of Microsoft Access............................ 51 Chapter 3
Designing Your Database Application 53
Application Design Fundamentals.............................. 53 Step 1: Identifying Tasks................................. 54 Step 2: Charting Task Flow............................... 54 Step 3: Identifying Data Elements.......................... 55 Step 4: Organizing the Data.............................. 55 Step 5: Designing a Prototype and a User Interface............. 55 Step 6: Constructing the Application........................ 55 Step 7: Testing, Reviewing, and Refining..................... 56 An Application Design Strategy................................ 56 Analyzing the Tasks.................................... 58
Visual Basic Function Reference A
Article 4
Internet Explorer Web Page Color Names A
Index of Troubleshooting Topics................................. 1247 Index.................................................... 1249
“ARQUIVO EM .PDF” - 914 PÁGINAS (INGLES)
Excel® 2007 Bible John Walkenbach Excel® 2007 Bible Published by Wiley Publishing, Inc. 10475 Crosspoint Boulevard
www.wiley.com
Copyright © 2007 by Wiley Publishing, Inc., Indianapolis, Indiana
Part I: Getting Started with Excel.........................
Part II: Working with Formulas and Functions............. Part III: Creating Charts and Graphics................... Part IV: Using Advanced Excel Features.................. Part V: Analyzing Data with Excel....................... Part VI: Programming Excel with VBA....................
- Selecting the Data
- Organizing Tasks
- Data Analysis.
- Choosing the Database Subjects.
- Mapping Subjects to Your Database
- Database Design Concepts.
- Waste Is the Problem
- Normalization Is the Solution
- Efficient Relationships Are the Result
- When to Break the Rules
- Improving Performance of Critical Tasks
- Capturing Point-In-Time Data
- Creating Report Snapshot Data
- Part
- Chapter
- Creating Your Database and Tables
- Creating a New Database
- Using a Database Template to Create a Database
- Creating a New Empty Database
- Creating Your First Simple Table by Entering Data
- Creating a Table Using the Table Wizard
- Creating a Table in Design View.
- Defining Fields
- Understanding Field Data Types.
- Setting Field Properties
- Completing the Fields in the Companies Table
- Defining Simple Field Validation Rules
- Defining Input Masks
- Defining a Primary Key
- Defining a Table Validation Rule.
- Understanding Other Table Properties
- Defining Relationships
- Defining Your First Relationship
- Creating a Relationship on Multiple Fields
- Adding Indexes
- Single Field Indexes
- Multiple-Field Indexes
- Setting Table Design Options
- Printing a Table Definition
- Database Limitations
- Chapter
- Modifying Your Table Design
- Before You Get Started
- Making a Backup Copy
- Checking Object Dependencies
- Deleting Tables
- Renaming Tables
- Changing Field Names
- Moving Fields.
- Inserting Fields
- Copying Fields
- Deleting Fields
- Changing Data Attributes
- Changing Data Types
- Changing Data Lengths.
- Dealing with Conversion Errors
- Changing Other Field Properties
- Reversing Changes.
- Using the Table Analyzer Wizard.
- Taking a Look at Lookup Properties
- Changing the Primary Key
- Compacting Your Database
- Chapter
- Importing and Linking Data
- A Word About Open Database Connectivity (ODBC)
- Importing vs. Linking Database Files
- Importing Data and Databases
- Importing dBASE Files
- Importing Paradox Files
- Importing SQL Tables
- Importing Access Objects
- Importing Spreadsheet Data
- Preparing a Spreadsheet
- Importing a Spreadsheet
- Fixing Errors.
- Importing Text Files
- Preparing a Text File
- Importing a Text File
- Fixing Errors.
- Modifying Imported Tables
- Linking Files
- Security Considerations
- Performance Considerations
- Linking Access Tables.
- Linking dBASE and Paradox Files
- Linking Text and Spreadsheet Files
- Linking SQL Tables
- Modifying Linked Tables
- Unlinking Linked Tables
- Using the Linked Table Manager
- Chapter
- Creating and Working with Simple Queries
- Selecting Data from a Single Table
- Specifying Fields
- Setting Field Properties
- Entering Selection Criteria.
- Using Expressions
- Using the Expression Builder.
- Specifying Field Names.
- Sorting Data
- Testing Validation Rule Changes
- Checking a New Field Validation Rule.
- Checking a New Table Validation Rule
- Working in Query Datasheet View
- Moving Around and Using Keyboard Shortcuts
- Working with Subdatasheets
- Changing Data
- Working with Hyperlinks
- Sorting and Searching for Data
- Chapter
- Building Complex Queries
- Selecting Data from Multiple Tables.
- Creating Inner Joins
- Building a Query on a Query
- Using Outer Joins
- Using a Query Wizard
- Summarizing Information with Totals Queries
- Totals Within Groups.
- Selecting Records to Form Groups.
- Selecting Specific Groups
- Building Crosstab Queries.
- Partitioning Data in a Crosstab Query
- Using Query Parameters
- Customizing Query Properties
- Controlling Query Output.
- Working with Unique Records and Values
- Defining a Subdatasheet
- Other Query Properties
- Editing and Creating Queries in SQL View.
- Limitations on Using Select Queries to Update Data
- Creating PivotTables and PivotCharts from Queries
- Building a Query for a PivotTable
- Designing a PivotTable
- Designing a PivotChart
- Chapter
- Modifying Data with Action Queries
- Updating Groups of Rows
- Testing with a Select Query
- Converting a Select Query to an Update Query
- Running an Update Query
- Updating Multiple Fields
- Creating a New Table with a Make-Table Query
- Creating a Make-Table Query
- Running a Make-Table Query
- Inserting Data from Another Table
- Creating an Append Query.
- Running an Append Query.
- Deleting Groups of Rows.
- Testing with a Select Query
- Using a Delete Query
- Deleting Inactive Data
- Troubleshooting Action Queries
- Solving Common Action Query Errors and Problems
- Looking at an Error Example
- Part
- Chapter Creating Forms and Reports in a Desktop Application
- Using Forms
- Uses of Forms
- A Tour of Forms
- Headers, Detail Sections, and Footers.
- Multiple-Page Forms
- Continuous Forms
- Subforms
- Pop-Up Forms.
- Modal Forms
- Special Controls.
- PivotTables and PivotCharts
- Moving Around on Forms and Working with Data
- Viewing Data
- Adding Records and Changing Data
- Searching for and Sorting Data
- Performing a Simple Search
- Performing a Quick Sort on a Form Field
- Adding a Filter to a Form.
- Printing Forms
- Chapter
- Building a Form
- Forms and Object-Oriented Programming
- Starting from Scratch—A Simple Input Form.
- Building a New Form with Design Tools
- Building a Simple Input Form for the tblCompanies Table.
- Customizing Colors and Checking Your Design Results
- Working with Form Wizards
- Creating the Basic Products Form with a Form Wizard
- Modifying the Products Form.
- Simplifying Data Input with a Form.
- Taking Advantage of Combo Boxes and List Boxes
- Using Toggle Buttons, Check Boxes, and Option Buttons
- Chapter
- Customizing a Form
- Aligning and Sizing Controls
- Sizing Controls to Fit Content
- Adjusting Control Layout
- “Snapping” Controls to the Grid
- Lining Up Controls
- Enhancing the Look of a Form.
- Lines and Rectangles
- Colors and Special Effects
- Fonts.
- Setting Control Properties
- Formatting Properties
- Adding a Scroll Bar
- Enabling and Locking Controls.
- Setting the Tab Order
- Adding a Smart Tag
- Understanding Other Control Properties
- Setting Form Properties
- Allowing Different Views
- Setting Navigation Options
- Defining a Pop-Up and/or Modal Form
- Controlling Edits, Deletions, Additions, and Filtering
- Defining Window Controls
- Setting the Border Style
- Understanding Other Form Properties
- Setting Form and Control Defaults
- Changing Control Defaults
- Working with AutoFormat.
- Defining a Template Form
- Chapter
- Advanced Form Design
- Basing a Form on a Multiple-Table Query
- Creating a Many-to-One Form.
- Creating and Embedding Subforms
- Specifying the Subform Source
- Designing the Innermost Subform
- Designing the First Level Subform
- Embedding a Subform
- Specifying the Main Form Source.
- Creating the Main Form
- Creating a Subdatasheet Subform.
- Displaying Values in an Option Group.
- Using Conditional Formatting.
- Working with the Tab Control
- Creating Multiple-Page Forms
- Introducing ActiveX Controls—The Calendar Control
- Working with PivotChart Forms
- Building a PivotChart Form
- Embedding a Linked PivotChart
- Chapter
- Using Reports
- Uses of Reports.
- A Tour of Reports
- Print Preview—A First Look
- Headers, Detail Sections, Footers, and Groups
- Subreports
- Objects in Reports
- Printing Reports
- Print Setup
- Chapter
- Constructing a Report
- Starting from Scratch—A Simple Report
- Building the Report Query
- Designing the Report
- Sorting and Grouping Information
- Completing the Report
- Using a Report Wizard
- Selecting a Report Type
- Specifying Wizard Options
- Viewing the Result
- Chapter
- Advanced Report Design
- Building a Query for a Complex Report.
- Creating the Basic Facility Occupancy by Date Report
- Defining the Sorting and Grouping Criteria
- Setting Section and Report Properties
- Section Properties
- Report Properties.
- Using Calculated Values
- Adding the Print Date and Page Numbers
- Performing Calculations
- Hiding Redundant Values and Concatenating Text Strings
- Calculating Percentages
- Using Running Sum
- Taking Advantage of Conditional Formatting
- Creating and Embedding a Subreport.
- Understanding Subreport Challenges.
- Building a Report with a Subreport
- Adding a PivotChart to a Report.
- Designing the PivotChart Form
- Embedding a PivotChart in a Report
- Part
- Chapter Designing an Access Project
- Building Tables in an Access Project
- Creating a New Project File
- Building a New SQL Server Database.
- Connecting to an Existing SQL Server Database
- Creating a Table in Design View.
- Defining Columns.
- Column Data Types.
- Completing the Columns in the Companies Table
- Understanding Column Properties
- Defining a Primary Key
- Adding Indexes
- Creating Additional Tables in Contact Tracking
- Defining Check Constraints
- Creating Additional Constraint Expressions
- Defining Relationships
- Defining Relationships in Table Design View.
- Defining Relationships Using Database Diagrams.
- Setting Table Design Options
- Chapter
- Building Queries in an Access Project
- Building Queries Using the Query Designer.
- Understanding the Query Designer
- Working with Views.
- Working with In-Line Functions.
- Working with Stored Procedures
- Building Queries Using a Text Editor.
- Building a Text Stored Procedure
- Building a Text Scalar Function
- Building a Text Table-Valued Function
- Chapter
- Designing Forms in an Access Project
- Understanding Form Differences in an Access Project
- Choosing Option Settings
- Setting Project Form Properties
- Setting Recordset Type
- Understanding Max Records
- Working with Server Filters
- Setting Input Parameters
- Chapter
- Building Reports in an Access Project
- Understanding Report Differences in an Access Project.
- Setting Project Report Properties.
- Working with Server Filters
- Working with Input Parameters
- Part
- Chapter Automating an Access Application
- Understanding Event Processing
- Access as a Windows Event-Driven Application
- Understanding Events in Windows
- Leveraging Access Events to Build an Application
- Summary of Form and Report Events.
- Opening and Closing Forms and Reports
- Changing Data
- Detecting Focus Changes
- Detecting Filters Applied to Forms
- Trapping Keyboard and Mouse Events
- Detecting Changes in PivotTables and PivotCharts
- Printing
- Trapping Errors.
- Detecting Timer Expiration
- Understanding Event Sequence and Form Editing
- Summary of Macro Actions
- Opening and Closing Access Objects
- Printing Data
- Executing a Query
- Testing Conditions and Controlling Action Flow
- Setting Values
- Searching for Data
- Building a Custom Menu and Executing Menu Commands.
- Controlling Display and Focus
- Informing the User of Actions
- Exporting Objects Renaming, Copying, Deleting, Saving, Importing, and
- Running Another Application
- The Macro Design Facility—An Overview.
- Working with the Macro Design Window
- Defining Multiple Actions
- Grouping Macros
- Conditional Expressions
- Converting Your Macros to Visual Basic
- Chapter
- Understanding Visual Basic Fundamentals
- The Visual Basic Development Environment
- Modules
- The Visual Basic Editor Window.
- Working with Visual Basic Debugging Tools.
- Variables and Constants
- Data Types.
- Variable and Constant Scope
- Declaring Constants and Variables
- Const Statement
- Dim Statement.
- Enum Statement
- Event Statement
- Private Statement
- Public Statement
- ReDim Statement.
- Static Statement
- Type Statement
- Collections, Objects, Properties, and Methods
- The Access Application Architecture.
- The Data Access Objects (DAO) Architecture.
- The ActiveX Data Objects (ADO) Architecture
- Referencing Collections, Objects, and Properties
- Assigning an Object Variable—Set Statement.
- Object Methods
- Functions and Subroutines
- Function Statement
- Sub Statement.
- Understanding Class Modules.
- Property Get
- Property Let
- Property Set.
- Controlling the Flow of Statements
- Call Statement.
- Do…Loop Statement
- For…Next Statement
- For Each…Next Statement
- GoTo Statement
- If…Then…Else Statement
- RaiseEvent Statement
- Select Case Statement.
- Stop Statement
- While…Wend Statement
- With…End With Statement
- Running Macro Actions and Menu Commands
- DoCmd Object
- Executing a Menu Command.
- Actions with Visual Basic Equivalents
- Trapping Errors.
- On Error Statement
- Some Complex Visual Basic Examples.
- A Procedure to Randomly Load Data
- A Procedure to Examine All Error Codes
- Chapter
- Automating Your Application with Visual Basic
- Why Aren’t We Using Macros?
- When to Use Macros
- When to Use Visual Basic
- Assisting Data Entry
- Filling In Related Data
- Handling the NotInList Event
- Fixing an E-Mail Hyperlink
- Providing a Graphical Calendar
- Working with Linked Photos.
- Validating Complex Data
- Checking for Possible Duplicate Names
- Testing for Related Records When Deleting a Record
- Verifying a Prerequisite
- Maintaining a Special Unique Value
- Checking for Overlapping Data
- Controlling Tabbing on a Multiple-Page Form.
- Automating Data Selection
- Working with a Multiple-Selection List Box
- Providing a Custom Query By Form
- Selecting from a Summary List
- Filtering One List with Another.
- Linking to Related Data in Another Form or Report
- Linking Forms Using a Filter
- Linking to a Report Using a Filter.
- Synchronizing Two Forms Using a Class Event
- Automating Complex Tasks
- Triggering a Data Task from a Related Form
- Linking to a Related Task
- Calculating a Stored Value
- Automating Reports
- Allowing for Used Mailing Labels
- Drawing on a Report
- Dynamically Filtering a Report When It Opens
- Chapter
- The Finishing Touches
- Creating Custom Menus and Toolbars
- Understanding the Customize Toolbar Facility
- Creating a Custom Form Toolbar
- Creating a Custom Form Menu Bar
- Creating Custom Shortcut Menus
- Toolbar Properties Setting Form, Form Control, and Report Menu and
- Fine-Tuning with the Performance Analyzer Wizard
- Disabling Form Design View
- Defining Switchboard Forms
- Designing a Switchboard Form from Scratch.
- Using the Switchboard Manager to Design Switchboard Forms.
- Controlling How Your Application Starts and Runs
- Setting Startup Properties for Your Database
- Starting and Stopping Your Application.
- Creating an AutoKeys Macro
- Performing a Final Visual Basic Compile.
- Part
- Chapter Linking Access and the Web
- Publishing Data on the Web
- Working with the Web
- Understanding HTML
- Introducing XML
- Maintaining Static Web Pages
- Creating Dynamic Web Pages
- Delivering Dynamic Query Results
- Processing Live Data with HTML Forms
- Sharing Your Data with SharePoint.
- Introducing SharePoint
- Office and SharePoint
- Discovering the Possibilities
- Viewing Static HTML Pages
- Exploring Active Server Pages
- Looking at Data Access Pages
- Chapter
- Creating Static and Dynamic Web Pages
- Creating a Static HTML Document
- Improving the Look of Exported Data in HTML.
- Generating an HTML Page from an Access Report
- Writing HTML from Visual Basic.
- Creating a Dynamic Active Server Page
- Defining a System Data Source
- Exporting Access Data to an Active Server Page
- Programming Active Server Pages
- Chapter
- Building Data Access Pages
- Introducing Data Access Pages
- Underlying Structure of a Data Access Page
- Usefulness and Limitations
- Types of Pages You Can Create
- Designing Data Access Pages
- Setting Options for Data Access Pages
- Creating Pages Using the Wizards
- Understanding the Data Access Page Design Facility.
- Modifying a Wizard-Generated Data Access Page
- Generating Data Access Pages from Forms and Reports
- Creating a Data Access Page in Design View
- Automating Data Access Pages
- Using the Microsoft Script Editor with Data Access Pages
- Creating Scripts for Data Access Pages
- Updating Data Access Page Links and Connections
- Updating Links from Access to Data Access Pages
- Updating Connections.
- Updating Links and Connections from Within Visual Basic
- Uploading Your Pages to a Web Server.
- Copying Pages Using the Windows XP My Web Sites
- Publishing Pages Using FTP.
- Chapter
- Working with XML and SharePoint
- Exploring XML
- Well-Formed XML
- Understanding XML File Types
- Using XML in Microsoft Access
- Exporting and Importing XML from the User Interface
- Importing and Exporting XML in Visual Basic
- Working with SharePoint
- Using SharePoint from Access.
- Using Access from SharePoint.
- Part
- Chapter After Completing Your Application
- Upsizing a Desktop Application to a Project
- Benefits of the Client/Server Architecture
- Deciding When to Upsize
- Deciding on a Strategy
- Upsizing Using the Import Facility
- Using the Upsizing Wizard
- Preparing Your Desktop Database
- General Upsizing Considerations
- Preparing Your Tables
- Modifying Queries
- Changing Forms and Reports
- Modifying Your Code
- Using the Upsizing Wizard
- Ensuring That Your Server Is Started
- Running the Wizard
- Starting Over If the Wizard Fails.
- Correcting the Upsize Result
- Adding Relationships and Constraints and Fixing Indexes
- Correcting Query Problems
- Fixing Parameters in Forms and Reports
- a Large Row Source Fixing Combo Boxes and List Boxes That Use
- Chapter
- Securing Your Database
- Securing a Desktop Database
- Access Security Architecture
- Users, Groups, and Permissions
- Using the Security Wizard
- Setting Up Your Secured Database
- Security Considerations in a Project File.
- Understanding Macro Security.
- Chapter
- Distributing Your Application
- Using Linked Tables in a Desktop Database
- Taking Advantage of the Database Splitter Utility
- Linked Table Connections Creating Startup Code to Verify and Correct
- Verifying Server Connection in a Project File
- Understanding Runtime Mode
- Creating an Execute-Only Database
- Creating an Application Shortcut
- Office System Understanding the Visual Studio Tools for the Microsoft
- Part
- Installing Microsoft Office Appendix
- Installing Microsoft Office
- Choosing Options When You Have No Previous Version of Office
- Choosing Options to Upgrade a Previous Version of Office
- Installing the Microsoft SQL Server Data Engine (MSDE)
- Managing ODBC Connections
- for Microsoft Access. Creating an ODBC System Data Source Name
- Using ODBC for Connecting to Microsoft SQL Server
- Converting from a Previous Release of Microsoft Access.
- Conversion Issues
- Creating an Office Toolbar in Windows XP.
- Part
- Article Articles
- Understanding SQL A
- Article
- Exporting Data A
- Article
- Indianapolis, IN
- Chapter 1: Introducing Excel ..................................................................................................................
- Chapter 2: What’s New in Excel 2007? ..................................................................................................
- Chapter 3: Entering and Editing Worksheet Data ..................................................................................
- Chapter 4: Essential Worksheet Operations ..........................................................................................
- Chapter 5: Working with Cells and Ranges............................................................................................
- Chapter 6: Introducing Tables ..............................................................................................................
- Chapter 7: Worksheet Formatting........................................................................................................
- Chapter 8: Understanding Excel’s Files ................................................................................................
- Chapter 9: Using and Creating Templates ............................................................................................
- Chapter 10: Printing Your Work ..........................................................................................................
- Chapter 11: Introducing Formulas and Functions ..............................................................................
- Chapter 12: Creating Formulas That Manipulate Text..........................................................................
- Chapter 13: Working with Dates and Times ........................................................................................
- Chapter 14: Creating Formulas That Count and Sum ..........................................................................
- Chapter 15: Creating Formulas That Look Up Values ..........................................................................
- Chapter 16: Creating Formulas for Financial Applications ..................................................................
- Chapter 17: Introducing Array Formulas ............................................................................................
- Chapter 18: Performing Magic with Array Formulas............................................................................
- Chapter 19: Getting Started Making Charts ........................................................................................
- Chapter 20: Learning Advanced Charting............................................................................................
- Chapter 21: Visualizing Data Using Conditional Formatting................................................................
- Chapter 22: Enhancing Your Work with Pictures and Drawings ..........................................................
- Chapter 23: Customizing the Quick Access Toolbar ............................................................................
- Chapter 24: Using Custom Number Formats ......................................................................................
- Chapter 25: Using Data Validation ......................................................................................................
- Chapter 26: Creating and Using Worksheet Outlines ..........................................................................
- Chapter 27: Linking and Consolidating Worksheets ............................................................................
- Chapter 28: Excel and the Internet ......................................................................................................
- Chapter 29: Sharing Data with Other Applications ..............................................................................
- Chapter 30: Using Excel in a Workgroup ............................................................................................
- Chapter 31: Protecting Your Work ......................................................................................................
- Chapter 32: Making Your Worksheets Error-Free ................................................................................
- Chapter 33: Using Microsoft Query with External Database Files ........................................................
- Chapter 34: Introducing Pivot Tables ..................................................................................................
- Chapter 35: Analyzing Data with Pivot Tables ....................................................................................
- Chapter 36: Performing Spreadsheet What-If Analysis ........................................................................
- Chapter 37: Analyzing Data Using Goal Seek and Solver ....................................................................
- Chapter 38: Analyzing Data with the Analysis ToolPak ........................................................................
- Chapter 39: Introducing Visual Basic for Applications ........................................................................
- Chapter 40: Creating Custom Worksheet Functions ............................................................................
- Chapter 41: Creating UserForms ........................................................................................................
- Chapter 42: Using UserForm Controls in a Worksheet ........................................................................
- Chapter 43: Working with Excel Events ..............................................................................................
- Chapter 44: VBA Examples..................................................................................................................
OUTROS ARQUIVOS
• Access Hacks - Tips & Tools For
Wrangling Your Data
• Access 2007 - The Missing Manual
• Access 2007 For Starters - The Missing
Manual
• Access 2003 Personal Trainer
• Programming Excel With VBA And .NET
• Access VBA Programming
