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

sql view

ResolvedVersion 2007

Gunaratnam has attended:
Access Introduction course
Access Intermediate course

SQL View

How to see the coding behind he query we created in SQL Format

RE: SQL View

Hello Gunaratnam,

Hope you enjoyed your Microsoft Access Introduction course with Best STL.

Thank you for your question regarding the SQL view.

First open a query, then from the Home ribbon click the drop-down arrow of the view button on the left-hand side and click SQL View.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Wed 30 Nov 2011: Automatically marked as resolved.

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

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.