O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Updating Records in a Query

Suppose you create a query. You review the records and want to make some changes to the stored records in the underlying table(s). Will your editing be successful?

The dreaded answer is, “It depends.” Let's try entering records in a query under different conditions to see what works and what doesn't.

I'm using the Categories and Merchandise tables for this example. In the Database window, choose Tools, Relationships to open the Relationships window. As you've seen previously, the two tables have a one-to-many relationship through the CategoryID field. The Categories table is on the “one” side, and the Merchandise table is on the “many” side. Close the Relationships window.

Update Records in One Table

Let's first review ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required