New listings

The Database window is the place where you can find everything you'll need in Access: data, forms, reports, and other objects. In this sample book chapter, you'll learn how to navigate in this window and to start customizing objects for your own use.

If you want to create a corporate intranet or Internet, or if you want to use Web pages in your business solutions, data access pages will help you get the job done quickly and easily. Think of a data access page as a form that your users might be viewing on a Web site or in email. By adding text, graphics, and controls, you can define a rich interface for your end users.

By using macros and creating Visual Basic for Applications (VBA) code, you can take more control of Access capabilities. This chapter shows how VBA code can overcome the limitations of using macros in Access and illustrates some of the useful things you can do with VBA code.

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.

The important concept in this sample chapter from Sams Teach Yourself Access 2002 in 21 Days is to understand that wizards can save you a lot of time and that you can study the generated database applications for ideas that you can use in your own database.

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.

The advances in Access mean more choices for you. Here's some information to help you decide which technology to use for your application's back end, your database container, and the best method of accessing your data while working in VBA.

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.

I doubt you could go through life as a developer without ever having to write code that retrieves data from a database. Database access is prevalent throughout the software community. This lesson will introduce you to the radical design changes within ADO.NET that facilitates the change from the connected to the disconnected client paradigm.

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.