Logo
HOW TO
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
 
 
Windows 7

Microsoft Access 2010 : Creating Queries - Writing Query Results to a New Table, Creating an Update Query

7/16/2012 3:53:24 PM

1. Writing Query Results to a New Table

When you run a query, Access writes the records the query finds into a dynaset, or dynamic record set. While Access remembers the results of queries you run, the results aren’t actually written to a table, limiting what you can do with the data. You can, however, modify a select query so the results are written to a new table.

1.1. Create a Make-Table Query

  1. Open a query in Design view.

  2. Click Make Table.

  3. Type a name for the new table.

  4. Click OK.

  5. Click Run.

  6. Click Yes to create a new table that contains the selected records.


Note:

You can write the results of your query to a table in another database by selecting the Another Database option in the Make Table dialog box, clicking the Browse button, and using the file navigation dialog box to identify the database to receive the table.

2. Creating an Update Query

One exciting aspect of business is how quickly things change—of course, it can be difficult to keep track of all those changes! One useful task you can perform with an update query is to modify values in a table to reflect changes in your business environment. For example, if a supplier increases prices by 5 percent, you can create an update query that moves through your Products table and updates the records for that supplier’s products.

2.1. Update Table Values with a Query

  1. Open a query in Design view.

  2. Click Update.

  3. In the Criteria cell of the column you’ll use to select the records to update, type the expression used to select which values should be updated.

  4. In the Update To cell of the column that contains the value to be updated, type the expression used to update the values.

  5. Click Run.


Other -----------------
- Microsoft Excel 2010 : Defining Multiple Alternative Data Sets
- Microsoft Excel 2010 : Defining an Alternative Data Set
- Tools for Troubleshooting (part 9) - TCPView, Telnet Client
- Tools for Troubleshooting (part 8) - Route & Task Manager
- Tools for Troubleshooting (part 7) - Resource Monitor, Ping & PortQry
- Tools for Troubleshooting (part 6) - Performance Monitor & Data Collector Sets
- Tools for Troubleshooting (part 5) - PathPing
- Tools for Troubleshooting (part 4) - Nslookup
- Tools for Troubleshooting (part 3) - Netstat & Network Monitor
- Tools for Troubleshooting (part 2) - Nblookup, Nbtstat
 
 
REVIEW
- First look: Apple Watch

- 10 Amazing Tools You Should Be Using with Dropbox

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
 
VIDEO TUTORIAL
- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 1)

- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 2)

- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 3)
 
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 Adobe Indesign Adobe Flash Professional Dreamweaver Adobe Illustrator Adobe After Effects Adobe Photoshop Adobe Fireworks Adobe Flash Catalyst Corel Painter X CorelDRAW X5 CorelDraw 10 QuarkXPress 8 windows Phone 7 windows Phone 8 BlackBerry Android Ipad Iphone iOS
Popular keywords
HOW TO Swimlane in Visio Visio sort key Pen and Touch Creating groups in Windows Server Raid in Windows Server Exchange 2010 maintenance Exchange server mail enabled groups Debugging Tools Collaborating
Top 10
- Microsoft Excel : How to Use the VLookUp Function
- Fix and Tweak Graphics and Video (part 3) : How to Fix : My Screen Is Sluggish - Adjust Hardware Acceleration
- Fix and Tweak Graphics and Video (part 2) : How to Fix : Text on My Screen Is Too Small
- Fix and Tweak Graphics and Video (part 1) : How to Fix : Adjust the Resolution
- Windows Phone 8 Apps : Camera (part 4) - Adjusting Video Settings, Using the Video Light
- Windows Phone 8 Apps : Camera (part 3) - Using the Front Camera, Activating Video Mode
- Windows Phone 8 Apps : Camera (part 2) - Controlling the Camera’s Flash, Changing the Camera’s Behavior with Lenses
- Windows Phone 8 Apps : Camera (part 1) - Adjusting Photo Settings
- MDT's Client Wizard : Package Properties
- MDT's Client Wizard : Driver Properties
 
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
2015 Camaro