Hi FullName,

This message brings you good news from ProgrammingMSAccess.com.  You'll get a general reminder about our three upcoming seminar webcast series along with a special focus on the things that seminar attendees receive.  In addition, we are offering two chances to win a free copy of my most recent book on SQL Server Express, Visual Basic Express, and Visual Web Developer Express.   Finally, there's a review of our code sample section.  This section is one of the most popular reasons for visiting our site.

This message covers three distinct points.  Follow the links below to jump to the headings in the message that especially appeal to you.

Train to use Express suite packages from seminar presentations

Those of you who have been visiting my site over the past several years know that a major event each year is our annual seminar presentations.  This year we are offering three presentations of a 21-hour training seminar on SQL Server Express, Visual Basic Express, and Visual Web Developer Express.  Seminars provide a richer form of interaction that can efficiently complement the resources available in a book.

We offer the 21 hours of training during daytime or evening hours.  The daytime presentations are available during either Eastern Time (New York City) or Pacific Time (San Francisco).  The evening presentation is available during Central Time (Chicago).  While the times are obviously suitable for US and Canadian participants from coast to coast, the presentation times are also convenient for participants from other countries.  For example, our evening presentation hours on Central Time occur during normal business hours for those from either England or Australia.

Class sizes are limited to make sure that we have time to address your questions.  All the seminar presentations already have registrants, but just five more open slots are available for the first session starting on March 6 at 9 AM Eastern time.  We have also added to the seminar web site new count-down indicators showing the number of days to the start of each of the three rounds of seminar presentations.

Besides our great training, seminar recipients receive three benefits.

You can learn all the details about the seminar including our web-based access with toll-free telephone support, what topics are covered, how participants responded to prior seminars, how little it cost to attend, and how to register from the seminar web site.

 

We are giving away two books

I believe that SQL Server Express along with Visual Basic Express and Visual Web Developer Express offer a major opportunity for experienced Access developers to migrate to .NET.  Microsoft desperately wants you to use this software because they are literally giving away all three packages.  Furthermore, the Express editions of SQL Server 2005, Visual Basic 2005, and Visual Web Developer are easier to learn and use than other SQL Server 2005 and Visual Studio 2005 editions.

I believe so much in this software that I wrote a book on the topic.  I believe the book will be suitable for anyone who wants to learn about using .NET for database solutions.  Although I did not write the book as a migration book for moving Access databases to SQL Server, any Access developer should be able to understand the content in the book if they really want to learn .NET.

Between now and the end of March, our site is giving away two FREE copies of the book.  To qualify to win a copy please visit our site in the Free Stuff section

 

Our Code Samples section

Initially, the Code Samples section at ProgrammingMSAccess.com featured VBA excerpts from the Webmaster's Programming Microsoft Access 2000 book.  The early samples highlighted how to use VBA with Access 2000.  As the Webmaster extended his scope of interests, the site added additional code samples on using VBA with ADO for SQL Server and Web applications, T-SQL programming, and VB.NET procedures.  Many of these samples are excerpts from his seven prior books and three DVDs.  I want to remind you that our Book and DVD section includes additional code samples with commentary that you may find helpful.

In early November 2005, we made two changes to the Code Samples section.  First, we re-organized it.  Previously, we had VBA samples in the SQL Section if they queried a SQL Server database or used an .adp project to manage a SQL Server instance.  Now, all VBA samples whether or not they relate to SQL Server or Access appear in the new General and SQL Server VBA Scripts sub-section.  We complement our VBA code samples with another selection of code samples.  VB and VBA developers wishing to migrate to .NET may enjoy perusing the samples in our VB.NET Scripts sub-section.  Second, we vastly expanded the T-SQL sample scripts; these can be found in a new T-SQL scripts sub-section.  At the start of November, we added about thirty scripts to the sub-section.  Whether you want to query or create a database with T-SQL, you are likely to find some helpful samples in this section.  The selection of samples on joins is an example of the kind of valuable content that you can find.  If you have ever been stumped about how to write a join between two or more tables or even about how to join a table with itself, these samples can help.

 

I hope that you found reading this message worthwhile.  There's lots more that I wanted to tell you, but I purposely tried to keep it short.  In particular, I remind you that our SPAM Blocker from ProgrammingMSAccess.com has freshly updated spam filters.  Our SPAM Blocker section includes a relatively new section on the truth and myths about blocking spam.   Also, I remind you to browse our Newsletter section.  If there is a prior issue you want to lookup or an issue that you missed, this section makes it easy to find the message.  Please take a moment to forward copies of this message to your friends who can benefit from the topics presented in this message.  After receiving this message, your friends can arrange to get their own copy of our newsletter by signing the site's Guest Book.

 

As usual, I close by reminding you that if you no longer wish to receive messages from ProgrammingMSAccess.com, just reply with Remove in Subject field.

 

Rick

www.programmingmsaccess.com