98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Microsoft Access 2003 Queries
Microsoft Access 2003 Queries
Resolved · Low Priority · Version 2003
Pete has attended:
Access Intermediate course
Microsoft Access 2003 Queries
Hi there, I'd like to get even better at queries than my current Intermediate level, and I would like to be good at making graphs (which was not included in the course material). How can I gain these 2 specific skills?
RE: Microsoft Access 2003 Queries
Dear Pete
Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.
It would be interesting to know what type of queries are you planning to create. When you mention that you want to get better at queries is it the existing queries that we cover in intermediate course?
Creating Charts is quite straightforward in Access compared to Excel.
To create charts you have to be in Forms.
Click on the New Button
Choose Chart Wizard from the list and then choose the Table or Query which contains the data for chart
Press OK
Choose (Double-click) the fields that need to be displayed in the chart
Press Next
Choose the type of chart suitable for the fields you selected.
Press Next
Drag and drop the fields to the relevant places in the chart
Press Next
Type a suitable name for the Chart form
Press Finish
In the Form if the Chart seems to be too small then go to teh design view and adjust the size to your requirement.
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
RE: Microsoft Access 2003 Queries
Hi there Rajeev, thank you for your answers
re: Chart design
Most of that I can now do ok. More specifically:
Where can I find more info about which are the "relevant places" to "drop in fields"?
re: Queries
I have some days next week when I can really blitz some Access practice.
My team's booking me on an Advanced Course with you some time in February, now together with another collegue. Still, I need to be good at Queries yesterday. Do you have any good examples I can work through to pick up as many skills as possible, including the Intermediate's content, and definitely beyond. You did an amazing job of covering so much so well during the course, but I really need to expand my skill-base in this area.
With many thanks,
Pete
RE: Microsoft Access 2003 Queries
Dear Pete
Thank you for your kind response!!
Please refer to this link that should cover all the topics and many more topics that will help you to master MS Access:
http://www.kayodeok.btinternet.co.uk/favorites/kbofficeaccess.htm
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
Thu 25 Dec 2008: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Remove spaces in a tableIf you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks |