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 » Queries

	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:

Queries

Resolved · Low Priority · Version 2003

ReplyWed 20 May 2009, 14:06Delegate Ian said...

Queries

What Access course level is best to learn how to write my own queries for a system that is Access based using different tables?

For upcoming training course dates see: Pricing & availability

ReplyFri 22 May 2009, 09:14Trainer Rajeev said...

RE: Queries

Dear Ian

Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.

I would recommend you to look into SQL (Structured Query Language) as it is the most common language used for extracting certain records in various database applications.

We do cover basics of SQL but if you are looking into creating complicated queries using SQL I would request you to put that in one of the post or call our inquires to find out if we can cater your needs!!

If you want to learn about the SQL statements the best thing to do would be create the query you want and then simply choose the SQL view from the View Button.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Thu 28 May 2009: Automatically marked as resolved.

Access articles

· How To Create Your Own Access 2007/2010 Navigation Pane
· Access Corruption Avoidance Tip #3: Stay Connected
· How Does The Startup Work When Access 2010 Launches The Northwind Database
· Making Figures Talk For Themselves Thanks To Access
· How To Make Access 2010 Databases Compatible With Access 2007

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

Access tip:

Create own ribbon tab - Access 2010

a. In Access click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Access hints and tips

Avoiding Bad Word Processing Habits

In today's world of text messages and social networking sites, many contractions and abbreviations have crept into the language in order to save time and space. Caution should be taken that these time-savers do not become habit forming and crop up in your word processing.

» Article: Microsoft word course

How do I add another colum in my table

» Forum post: Tables Within Word

For people who use styles there is a quick way of checking which style has been used on text.

Press Shift-F1. The cursor turns to a question mark and pointer.

Click in the text you want to know about and Word opens the 'Reveal Formatting' task pane ...