Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

queries

ResolvedVersion Standard

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).

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

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.