Agentic demo automation is here.
Meet Lily
This interactive demo was created free with Storylane in 2 minutes. Create your own demo
This interactive demo was created free with Storylane in 2 minutes. Create your own demo
Start free

How to Create Update Query MS Access

‍

‍

Creating an update query in Microsoft Access allows you to modify existing data in one or more records in a table. Here’s how to create an update query in MS Access:

‍

  1. Click on the 'Create' tab.
  2. Click 'Query Design'.
  3. Select the table and click 'Add Selected Tables'.
  4. In the 'Query Design' tab of the Query Design window, click on 'Update' in the Query Type group.
  5. Drag the field(s) you want to update into the grid below, or double-click the field(s) from the table to add them.
  6. In the 'Update To' row of each field, enter the value or expression you want to use to update the field.
  7. Click the 'Run' button on the ribbon.
  8. MS Access will prompt you to confirm the update. Click 'OK' to proceed.
Similar Articles

How to Integrate a Microsoft Excel Database with Excel

How to Integrate Google Calendar with an MS Access Database

How to Integrate Google Sheets with an MS Access Database

Build Killer Demos in 2 Minutes
Build Killer Demos in 2 Minutes
Build Killer Demos in 2 Minutes
Build Killer Demos in 2 Minutes
Build Killer Demos in 2 Minutes
Build Killer Demos in 2 Minutes
Build Killer Demos in 2 Minutes
Chrome Extension Icon
Try our Chrome extension
DOWNLOAD

Desktop app for macOS
DOWNLOAD
Backed by
Y combinator
AICPA SOC
GDPR
Products
Guided DemosSandbox DemosDemo Hub
Featured
Account RevealPersonalizationIntegrations
Solutions
EnterpriseGrowth & Demand
MarketingProduct MarketingSalesPresales
Resources
BlogTutorialsHelp DocsWhat’s NewDemo DundiesPlaybooks
Company
CareersPricingPartnersContactTrust CenterDemo Abuse
Customers
Demo ShowcaseCase Studies
Built in San Francisco Bay Area - ©2025 Storylane
Backed by
Y combinator
AICPA SOC
GDPR
Privacy PolicyTerms & Conditions
X Corp (formerly Twitter)LinkedIn
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it