Home > Articles > Data > Access

Access

29 Items

Sort by Date | Title

Overcoming High-Latency Database Access with Java Stored Procedures
May 13, 2004
Java Stored Procedures: a way to put slow Java code in your otherwise fast database or a quick solution for certain database performance problems? They can be both, as it turns out. Tim Stevens takes a look at a situation in which the adoption of Java Stored Procedures quickly and effectively solved some serious performance issues in a database-driven system, all without a complete rewrite of existing database code.
Relationships: Your Key to Data Integrity
May 21, 2007
Relationships: Your Key to Data Integrity in Access
Mar 29, 2002
This sample chapter introduces relational database design. It explains how to establish relationships in Access and how to build referential integrity. The benefits of relationships are analyzed, and relationships and indexes are examined.
Relationships: Your Key to Data Integrity in Access 2007
Jun 15, 2007
Storing Your Access Data
Feb 8, 2002
Learn how to store data temporarily in RAM, using the essential data-declaration statements, Popup Hints, the Locals and Watches windows, the Immediate window, and the call stack.
Taking More Control of Access
May 11, 2001
Using macros and creating Visual Basic for Applications code, you can take more control of Access capabilities. This chapter shows how VBA code can overcome limitations of macros and illustrates some other useful things you can do with VBA code.
Utilities for Microsoft Access
Oct 13, 2006
Microsoft Access can be a powerful tool for database development and management. But it's not trivial to learn, and if you want more than the built-in functionality it offers, you may need to look around for some assistance. Rick Cook discusses some of the available resources for helping you to get the most out of Access.
VoiceXML Database Access
Jun 21, 2002
One primary reason that developers use server-side programming is to extract information from a database and format it in HTML for viewing in a browser. Learn to develop and modify server-side programs for voice applications.
Working with Multiple-Table Queries in Access
Sep 10, 2004
Most database applications store their information in multiple tables. Being able to query and work with data from multiple tables requires some front-end planning to set up the tables correctly, and this chapter from Paul McFedries helps you to design databases to make such queries possible.

< Prev Page 1 2