The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access-database-training - Create action query

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

access-database-training - Create action query

Resolved · Low Priority · Version Standard

ReplySat 16 Dec 2006, 11:27Delegate Janice said...

Create action query

How do you create an action query?

For upcoming training course dates see: Pricing & availability

ReplyMon 18 Dec 2006, 15:29Trainer Andrew said...

RE: Create action query

Hi Janice

Thanks for your question - one way to create an action query is to first build your query as a regular Select Query. Once you are happy that the query is returning the correct records you can then change it to the Action Query type you require.

To do this switch to design view and select the appropriate action query (such as update, append or delete) from the Query menu.

Hope this helps - do let us know if you have any further questions.

Thanks

Andrew

Access articles

· So You Want To Create Forms In Access 2007?
· One To Many Relationships In Access
· Microsoft Access 2007: New Features
· How To Use Concatenation In Access To Create A Custom Lookup
· Understanding The Components Of Access

Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

View all Access hints and tips

Microsoft Outlook - Always Looking Out For Your Valuable Time

Whatever line of business you're in, whether large or small, local, national or multinational, it pays to make the best use of your time. Managing your diary can play a key role in ensuring that you work as efficiently and effectively as possible – and Microsoft Outlook has a wide range of flexible and easy-to-use tools to look after your time.

» Article: Outlook 2002 training

I am having difficulty getting my head around naming a cell and how that is used later. Do I name the cell in the top bar at the left hand side?

» Forum post: Excel 2003 cell naming

Selecting in word has improved with CTRL being added in XP for individual ranges, like in excel. If you want to select a range such as an column which has been created using tabs you could use the CTRL key and select one word at a time, but if you hold do...