Update Query

The UK's most regular instructor-led training courses.
Training information: access course microsoft training · Courses in microsoft access · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Urgent Priority · Version 2007

8 posts

ReplyTue 26 May 2009, 15:43Delegate James said...

James has attended:
Access Intermediate course

Update Query

Afternoon,

I have a master table called Master Revenue sheet which breaks down all orders and charges by client.

Recently a client changed their name from "Adstream TV" to "Adstream" and I want to go in and change all previous entries of "Adstream TV" to "Adstream" in order to group them all together moving forward yet have forogtten how to do this. Can you please advise how to please

Thanks

James

Version	Date	Location	Places available	Book	Next place rate (£)
Access VBA 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Wed 24 + Thu 25 Mar 2010	Southwark	8		£445	£450
2003	Wed 5 + Thu 6 May 2010	Bloomsbury	10		£275	£280
2003	Mon 28 + Tue 29 Jun 2010	Bloomsbury	10		£275	£280
2003	Wed 4 + Thu 5 Aug 2010	Bloomsbury	10		£275	£280
2003	Thu 9 + Fri 10 Sep 2010	Bloomsbury	10		£275	£280
2003	Wed 27 + Thu 28 Oct 2010	Bloomsbury	10		£275	£280
Full Schedule: See all 7 Access VBA course dates. Bookings currently available until 6th December 2010.

755 posts

ReplyTue 26 May 2009, 16:05Trainer Stephen said...

RE: Update Query

Hi James

Thank you for your question

You need to create an update query to accomplish this.

Create a basic select query in the normal way that includes the field that you need to update. On the design ribbon select update query from the query type group. In the design table enter Adstream in the update to row and adstreamtv in the criteria row.

If the table you are updating is also linked to other tables and you have enabled referential integrity, you will also need to allow cascade updates. To do this open the relationships window, double click on the link and select the appropriate check box

I would also strongly advise that you back up the database before running this procedure

Regards

Stephen

· How Reorganising Your Data Can Take Your Business to the Next Level
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· A Brief Guide To Table Relationships In Access
· Taking Control Of Your Data - And Saving Money In The Process!
· Microsoft Access Mistakes to Avoid

Please browse our web site to find out more about
access course microsoft training and other Microsoft training courses.

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000

View all Access hints and tips