Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shellieller
Starting Member
2 Posts |
 Posted - 2005-08-06 : 13:32:05
|
| Hello~I am wondering if anyone can recommend a basic, "How To" article, column or book for someone who has never worked with Access but is familiar with DB programming.I need to know how to submit queries, and print reports. Any help is appreciated.Thank you!Shelli |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2005-08-08 : 08:14:32
|
| The easiest thing is to set up linked tables to SQL or use an (.adp) Access project. Queries become views, can be used as views, graphically represented as tables in Access query designer, Forms/reports can use these results as datasources. Recordset navigation can be positional and iterative while in Access. It's about learning Access as an application, then getting a working model in your head that triggers. THIS in ACCESS is the SAME as THAT in DB. At the very basic start point. Graphically design a query in Access then hit the SQL view from query designer to see the Access SQL syntax. Go back to designer, make some changes go back to SQL view. Repeat a few thousand times, Then move on to report creation, then forms beginning with the wizard then from scratch then subfoms."I need to know how to submit queries, and print reports." this will kind of fall out of the initial investigation naturally just by clicking buttons.Submit queries = click on the query once built.Print reports. = At it's most basic set a report datasource-> go to toolbox -> click textbox - > mouse drop -> set control -> source -> print. I don't think you will find a specific interaction reference that is SQL centric but the gateway is probably .adphttp://techrepublic.com.com/5102-6329-5065669.htmlI wish someone would start an Official XML Rant Thread. |
 |
|
|
shellieller
Starting Member
2 Posts |
Posted - 2005-08-08 : 14:25:02
|
| Thank you so much! It is appreciated.Shelli |
|
|
|
|
|
|
Using SQL and writing Queries in Access