queries
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Forum home » Delegate support and help forum » Microsoft Access Training and help » Queries

Queries

resolvedResolved · Low Priority · Version Standard

Fri 8 Feb 2008, 16:01 replyReply Delegate Sarah said...

Sarah has attended:
Access Intermediate course
Access Intermediate course
Access Advanced course
Project Management course

Queries

How can SQL help me to devise a query that will bring up a set of required data, and allow for changes to be made to the data that directly update the relative table(s).

For upcoming training course dates see: Pricing & availability

Fri 8 Feb 2008, 16:20 replyReply Trainer David said...

RE: Queries

Sarah,

SQL will not help you to devise a query. SQL stands for structured query language i.e it is the language that you use to build a query.
e.g. SELECT * FROM Table1

To run an update you just use SQL Update

Hope this helps
David

 

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

Access tip:

Undo Entries In Records

To Undo any entries or changes in records:

Hit the ESC key once for the current field

And ESC twice for current record

View all Access hints and tips



Access training London
Course rating:
4.8 stars - based on 4042 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom


Please tell us/web development about this error (copy and paste into an e-mail):
MySQL error: Duplicate entry '1' for key 'PRIMARY'
Line: 81
Actual SQL Query: insert into best_activevisitors (activevisitors_ID, activevisitors_IP, activevisitors_Time, activevisitors_Url) values (1, "54.82.0.87", now(), "/cms/forum.php")
Reported by: function sqlQueryBest()
When viewing (PHP_SELF): /cms/forum.php
Query string from URL: fpost_id=10279