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
ERP and Data Warehousing in Organizations: Issues and Challenges
The Second Wave ERP Market: An Australian Viewpoint
Enterprise Application Integration: New Solutions for a Solved Problem or a Challenging Research Field?
Data Mining for Business Process Reengineering
Intrinsic and Contextual Data Quality: The Effect of Media and Personal Involvement
Development of Interactive Web Sites to Enhance Police/Community Relations
Kanban Made Simple: Demystifying and Applying Toyotas Legendary Manufacturing Process
Size the Kanban
Initial Startup and Common Pitfalls
Appendix C Two-Bin Kanban Systems
Appendix F Implementation in Large Plants
Appendix H Case Study 1: Motor Plant Casting Kanban
Twisted Network Programming Essentials
Monitoring Download Progress
Downloading Mail from a POP3 Server
Downloading Messages from an IMAP Mailbox
Listing the Newsgroups on a Server
Downloading Usenet Articles
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
The Working Directory
Grouping and Summarizing
Extracting the Data
What Is the Product User Profile?
Section B.1. Formatting Numbers
.NET System Management Services
.NET Framework and Windows Management Instrumentation
Using the System.Management Namespace
Handling WMI Events
The WMI Schema
WMI Providers
Quartz Job Scheduling Framework: Building Open Source Enterprise Applications
The Quartz SchedulerFactory
Job Storage
Using Memory to Store Scheduler Information
Running Quartz with JobStoreTX
Why RMI with Quartz?
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