Flylib.com
Programming Microsoft Access 2000 (Microsoft Programming Series)
Programming Microsoft Access 2000 (Microsoft Programming Series)
ISBN: 0735605009
EAN: 2147483647
Year: 1998
Pages: 97
Authors:
Rick Dobson
BUY ON AMAZON
Cover
LOC Page
Dedication
Acknowledgments
Introduction
What s New with Access 2000?
Chapter 1 -- An Introduction to VBA
Collections, Objects, Properties, Methods, and Events
Procedures and Modules
The VBE Interface
Jet, Data Types, and Declarations
Conditional Logic and Looping Constructs
Built-In Functions
Debugging and Error Trapping
Macros
Chapter 2 -- Data Access Models
DAO Overview
ADO Overview
Chapter 3 -- Designing Tables
Relational Databases and Tables
Creating Tables with Wizards
Creating Tables Manually
Creating and Managing Tables Programmatically
Chapter 4 -- Manipulating Data Using Queries
A Review of Query Types
Designing Queries Manually
Special Select Queries
Action Queries
Programming Queries with SQL and ADO
Querying Remote Data Sources
Chapter 5 -- Building User Interfaces with Forms
Splash Screen Forms
Switchboard Forms
Linking Forms to Data
Looking Up and Displaying Data
Manipulating Forms with VBA
Using Form Classes
Chapter 6 -- Creating Reports
How to Create a Report
Case Study: A FrontPage Guestbook
Sorting, Grouping, and Calculating
Creating Multicolumn Reports
Distributing Reports Using Snapshots
Making a Report Dynamic
Dynamically Updating a Report
Manipulating Reports and Report Controls Programmatically
Chapter 7 -- Class, Form, and Report Modules
Module Types
Class Modules
Custom Properties and Methods
Case Study: Coding a Login Interface
Programming Events into Custom Classes
Using the All Collections
Programmatically Editing Modules
Chapter 8 -- Microsoft Office Objects
Using the Shared Office Objects
The FileSearch Object
The Assistant Object
The CommandBar Object
Chapter 9 -- Integrating Access with Other Office Applications
Linking Access to Other Office Applications
Working with Excel from Access
Working with Outlook from Access
Working with Word from Access
Chapter 10 -- Working with Multi-User Databases
Sharing Files
Sharing Forms
Sharing Recordsets
Security
Transactions
Chapter 11 -- Replicating Databases
How Replication Works
What s New in Access 2000 Replication
JRO Development Techniques
Chapter 12 -- Building Solutions with MSDE and Access Projects
The Microsoft Data Engine
Access Projects
Database Diagrams and Tables
Views and Stored Procedures
Reports and Forms
Programmatic Issues
Chapter 13 -- Access 2000 Does the Web
Traditional Approaches
Using Hyperlinks
Creating and Using Data Access Pages
Chapter 14 -- The Office 2000 Developer Edition
ODE Overview
The Code Librarian
Packaging and Deploying Solutions
Data Access in Non-Access Applications
Digitally Signing VBA Projects
Appendix -- Third-Party Sample Applications and Demos
Database Creations
FMS
Visio
About the Author
Programming Microsoft Access 2000 (Microsoft Programming Series)
ISBN: 0735605009
EAN: 2147483647
Year: 1998
Pages: 97
Authors:
Rick Dobson
BUY ON AMAZON
CompTIA Project+ Study Guide: Exam PK0-003
IT Project+ Study Guide
IT Project Management Overview
Project Closure
Appendix A Systems Development Life Cycle
Appendix B Standard IT Project Documents
Metrics and Models in Software Quality Engineering (2nd Edition)
The Prototyping Approach
Some Basic Measures
Criteria for Model Evaluation
In-Process Metrics and Quality Management
Process Improvement Economics
VBScript Programmers Reference
Error Handling and Debugging
Super-Charged Client-Side Scripting
HTML Applications
Appendix B Variable Naming Convention
Appendix D Visual Basic Constants Supported in VBScript
Kanban Made Simple: Demystifying and Applying Toyotas Legendary Manufacturing Process
Conduct Data Collection
Size the Kanban
Training
Appendix A MRP vs. Kanban
Appendix J Abbreviations and Acronyms
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Internet Protocol (IP) Basics
Windows Internet Name Service (WINS)
File and Printer Sharing
Internet Information Services (IIS) and the Internet Protocols
Virtual Private Networks (VPNs)
Service-Oriented Architecture (SOA): Concepts, Technology, and Design
Common characteristics of contemporary SOA
How service-orientation principles inter-relate
Native Web service support for service-orientation principles
SOA Delivery Strategies
A.3. The Oasis Car Wash
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies