|
-----------------
<< MS EXCEL
-----------------
Excel 2016 All-in-One For Dummies
Greg Harvey
(c) 2016
John Wiley & Sons
- Chp.1-1 > The Excel 2016 User Experience
- Chp.1-2 > Customizing Excel 2016
- Chp.2-1 > Building Worksheets
- Chp.2-2 > Formatting Worksheets
- Chp.2-3 > Editing and Proofing Worksheets
- Chp.2-4 > Managing Worksheets
- Chp.2-5 > Printing Worksheets
- Chp.3-1 > Building Basic Formulas
- Chp.3-2 > Logical Functions and Error Trapping
- Chp.3-3 > Date and Time Formulas
- Chp.3-4 > Financial Formulas
- Chp.3-5 > Math and Statistical Formulas
- Chp.3-6 > Lookup, Information, and Text Formulas
- Chp.4-1 > Protecting Workbooks and Worksheet Data
- Chp.4-2 > Using Hyperlinks
- Chp.4-3 > Sending Workbooks Out for Review
- Chp.4-4 > Sharing Workbooks and Worksheet Data
- Chp.5-1 > Charting Worksheet Data
- Chp.5-2 > Adding Graphic Objects
- Chp.6-1 > Building and Maintaining Data Lists
- Chp.6-2 > Filtering and Querying a Data List
- Chp.7-1 > Performing What-If Scenarios
- Chp.7-2 > Performing Large-Scale Data Analysis
- Chp.8-1 > Recording and Running Macros
- Chp.8-2 > VBA Programming
------------------
<< MS ACCESS
------------------
Access 2013 All-in-One For Dummies
Alison Barrows, Joseph C. Stockman, Allen G. Taylor
(c) 2013
John Wiley & Sons
- Chp.1-1 > Introducing Access 2013
- Chp.1-2 > Getting Started, Getting Around
- Chp.1-3 > Designing Your Database the Relational Way
- Chp.2-1 > Creating and Modifying Tables
- Chp.2-2 > Refining Your Table in Design View
- Chp.2-3 > Sorting, Finding, and Filtering Data in a Datasheet
- Chp.2-4 > Importing and Exporting Data
- Chp.2-5 > Avoiding "Garbage In, Garbage Out"
- Chp.2-6 > Relating Your Tables and Protecting Your Data
- Chp.3-1 > Creating Select Queries
- Chp.3-2 > Letting Queries Do the Math
- Chp.3-3 > Doing Neat Things with Action Queries and Query Wizards
- Chp.3-4 > Viewing Your Data from All Angles Using Crosstabs
- Chp.4-1 > Designing Custom Forms (and Reports)
- Chp.4-2 > Jazzing Up Your Forms (and Reports)
- Chp.4-3 > Creating Smarter Forms
- Chp.4-4 > Doing Calculations in Forms and Subforms (and Reports)
- Chp.5-1 > Creating and Spiffing Up Reports
- Chp.5-2 > Printing Beautiful Reports
- Chp.5-3 > Creating Charts and Graphs from Your Data
- Chp.6-1 > Making Macros Do the Work
- Chp.6-2 > Making Macros Smarter
- Chp.7-1 > Database Housekeeping
- Chp.7-2 > Sharing the Fun: Managing Multiuser Access
- Chp.7-3 > Securing Your Data
- Chp.8-1 > What the Heck Is VBA?
- Chp.8-2 > Writing Code
- Chp.8-3 > Writing Smarter Code
- Chp.8-4 > Controlling Forms with VBA
- Chp.8-5 > Using SQL and Recordsets
- Chp.8-6 > Debugging Your Code
- Chp.9-1 > Automation with Other Office Programs
- Chp.9-2 > Using Access As a Front End to SQL Server
- Chp.9-3 > Using Access with SharePoint
------------
<< VBA
------------
VBA For Dummies
John Paul Mueller
5th Edition
(c) 2007
Wiley Publishing
- Chp.01 > Getting to Know VBA
- Chp.02 > Your First VBA Program
- Chp.03 > Writing Structured VBA Programs
- Chp.04 > Storing and Modifying Information
- Chp.05 > Creating Structured Programs
- Chp.06 > Trapping Errors and Squashing Bugs
- Chp.07 > Interacting with the User
- Chp.08 > Object-Oriented Programming
- Chp.09 > Working with Arrays and Collections
- Chp.10 > Working with Disk Files
- Chp.11 > VBA Programming with XML
- Chp.12 > VBA Programming in Office
- Chp.13 > VBA Programming in Word
- Chp.14 > VBA Programming in Excel
- Chp.15 > VBA Programming in Access
- Chp.16 > Applications that Work Together
- Chp.17 > Ten Kinds of VBA Resources
- Chp.18 > Ten Ways to Update Your Old VBA Code Quickly
- (+)Chp.1 > VBA Programming in FrontPage
- (+)Chp.2 > VBA Programming in Visio
- (+)Chp.3 > Ten Really Cool Things You Can Do with VBA
Excel VBA Programming For Dummies
John Walkenbach
3rd Edition
(c) 2013
John Wiley & Sons
- Chp.01 > What Is VBA?
- Chp.02 > Jumping Right In
- Chp.03 > Working in the Visual Basic Editor
- Chp.04 > Introducing the Excel Object Model
- Chp.05 > VBA Sub and Function Procedures
- Chp.06 > Using the Excel Macro Recorder
- Chp.07 > Essential VBA Language Elements
- Chp.08 > Working with Range Objects
- Chp.09 > Using VBA and Worksheet Functions
- Chp.10 > Controlling Program Flow and Making Decisions
- Chp.11 > Automatic Procedures and Events
- Chp.12 > Error-Handling Techniques
- Chp.13 > Bug Extermination Techniques
- Chp.14 > VBA Programming Examples
- Chp.15 > Simple Dialog Boxes
- Chp.16 > UserForm Basics
- Chp.17 > Using UserForm Controls
- Chp.18 > UserForm Techniques and Tricks
- Chp.19 > Accessing Your Macros through the User Interface
- Chp.20 > Creating Worksheet Functions - and Living to Tell about It
- Chp.21 > Creating Excel Add-Ins
- Chp.22 > Ten VBA Questions (and Answers)
- Chp.23 > (Almost) Ten Excel Resources
- Chp.24 > Ten VBA Do's and Don'ts
Access 2007 VBA Programming For Dummies
Joseph C. Stockman, Alan Simpson
(c) 2007
Wiley Publishing
- Chp.01 > Where VBA Fits In
- Chp.02 > Your VBA Toolkit
- Chp.03 > Jumpstart: Creating a Simple VBA Program
- Chp.04 > Understanding Your VBA Building Blocks
- Chp.05 > Controlling Access through VBA
- Chp.06 > Programming Access Forms
- Chp.07 > The Scoop on SQL and Recordsets
- Chp.08 > Putting Recordsets to Work
- Chp.09 > Creating Your Own Dialog Boxes
- Chp.10 > Customizing Combo Boxes and List Boxes
- Chp.11 > Creating Your Own Functions
- Chp.12 > Testing and Debugging Your Code
- Chp.13 > Using VBA with Multiple Databases
- Chp.14 > Integrating with Other Office Applications
- Chp.15 > Ten Commandments of Writing VBA
- Chp.16 > Top Ten Nerdy VBA Tricks
| 
