Born To Learn

Blog Post: CASTING CALL: STUDENT FOR CERTIFICATION TESTIMONIAL VIDEOS

Regine Smith (Microsoft) — Wed, 08 Sep 2010 22:33:00 GMT

1. STEM student who is certified or getting certified.

2. Wants a career in IT and knows the value of certification to getting a job – “it will give me an advantage against others vying for the same jobs”

3. Is inspirational and influential and fun personality – a leader mentality who is smart and mature

CASTING DETAILS:

Microsoft Learning needs student testimonials for image of certification product.

If you, or someone you know, are a STEM (Science, Technology, Engineering, and Mathematics) student who is gearing up for a career in IT, we want to hear from you!

We are casting students who can speak to the value of certification to getting a job in IT for for testimonial-style videos for Microsoft Learning. The videos will appear on YouTube, Facebook and on Microsoft websites. We are seeking students with fun personalities, are inspirational & influential and people other students can relate to.

All ethnicities, any gender, 18 to 25 yrs old, in the Seattle, WA area are welcomed to apply

Languages spoken: English

Location: on a college campus in the greater Seattle, WA area

Payment details: no pay

Timeframe: shooting will take place in September

Applications to this casting call require:

A profile photo
Short video of themselves talking about certification

Blog Post: Snacking in the Cloud

Ken Rosen (Microsoft) — Wed, 08 Sep 2010 22:11:00 GMT

Last month, we published a few learning snacks for those of you venturing (or considering venturing) into the realm of cloud computing. Enjoy!

Cloud Computing and Microsoft Offerings

Customer Success Stories with Microsoft Cloud Offerings

Windows Azure Platform and Interoperability

Blog Post: Author news: Training by David Solomon coming up

Devon Musgrave — Wed, 08 Sep 2010 19:52:00 GMT

David Solomon, coauthor of Windows Internals, Fifth Edition, has a couple of training opportunities coming up. The first is next week!

Windows Internals with Sysinternals Webinar
(September 13 & 15, 2010 – two-day webinar/virtual class)

Explore the internals of key Windows kernel components and mechanisms with the Sysinternals tools in this two-day webinar. Topics include kernel architecture, memory management, thread scheduling, interrupt processing, time accounting, and crash dump analysis. This knowledge will help you help you troubleshoot difficult system problems as well as understand the true meaning behind key system performance counters. Register today.

Windows OS Internals and Sysinternals Training
(London October 18-22, San Francisco November 8-12)

David Solomon Expert Seminars provides Windows OS Internals classes featuring the Sysinternals tools. Topics include kernel architecture, memory management, thread scheduling, interrupt processing, time accounting, and crash dump analysis. This knowledge will help you help you troubleshoot difficult system problems as well as understand the true meaning behind key system performance counters.

Blog Post: Lab exam demo for developers: tell us what you think

Susan Filkins (Microsoft) — Wed, 08 Sep 2010 19:43:00 GMT

Exciting things are in the works for developer exams at Microsoft! In Beyond Multiple Choice: Lab Exam Demonstration for Developers, Developer Certification Product Planner Gerry O'Brien demonstrates a proof of concept for a lab that tests your hands-on development skills in the Visual Studio environment. The tasks prototyped in the lab are based on content from exam 70-515: TS: Web Applications Development with Microsoft .NET Framework 4.

Watch the demo, then follow this to complete a short survey and let us know what you think. (For best viewing results, hover your cursor over the black bar in the lower right corner of the video and select Watch on YouTube. You can expand to full screen from there if you like.) We're exploring the technologies and methodologies that will allow us to make labs a reality for developer exams, so we welcome your honest feedback about possible issues, improvements, and the like.

The Frequently Asked Questions (FAQ) document at the end of post answers common questions about the lab.

Thanks for checking it out!

[View:http://www.youtube.com/watch?v=7BL2mW7XEBs]

[View:http://www.youtube.com/watch?v=IjzVMmZI1nc]

[View:http://www.youtube.com/watch?v=1CuMJo7tOHo]

Blog: Microsoft Press

Devon Musgrave — Wed, 08 Sep 2010 18:45:00 GMT

Publishing books & ebooks to help you understand & use current and next-generation tools, technologies, & applications. Read the blog and the full posts at http://blogs.msdn.com/b/microsoft_press/

Blog: The Master Blog

Erwin Chan (Microsoft) — Wed, 08 Sep 2010 18:33:00 GMT

Thoughts, info, and updates from the Microsoft Certified Master team. Read the blog and the full posts here: http://blogs.technet.com/b/themasterblog/

Blog Post: Author news: Charles Petzold presenting on Windows Phone 7

Devon Musgrave — Wed, 08 Sep 2010 13:53:00 GMT

Greetings. Charles Petzold, whose upcoming Programming Windows Phone 7 will be available as a free download at the end of October, will be presenting in New York in October. The presentation’s title is “Multitasking on Windows Phone 7.”

You must register at https://www.clicktoattend.com/invitation.aspx?code=150256 to be admitted to the building and attend.

Subject:
“Multitasking on Windows Phone 7”
They say that Windows Phone 7 can't multitask. They're wrong. Join Charles Petzold for a programmer's perspective on the multitasking features of Windows Phone 7, including tombstoning, asynchronous operations, and push notifications.

Charles says this on his blog:

“’Multitasking on Windows Phone 7’: That's the (somewhat provocative) title of a presentation I'll be delivering at the NYC .NET Developers Group on October 21, 2010…. This is the only public presentation on Windows Phone 7 currently on my schedule, and I plan to make the most of it.”

Speaker:
Charles Petzold is a New York City based freelance writer who has been writing about Microsoft operating systems since 1984. His latest book, Programming Windows Phone 7, will be available in October.

Date:
Thursday, October 21, 2010

Time:
Reception 6:00 PM , Program 6:15 PM

Location:
Microsoft , 1290 Avenue of the Americas (the AXA building - bet. 51st/52nd Sts.) , 6th floor

Directions:
B/D/F/V to 47th-50th Sts./Rockefeller Ctr
1 to 50th St./Bway
N/R/W to 49th St./7th Ave.

In the meantime, make sure to download the preview version of Charles’s upcoming book. It contains 11 chapters in DRAFT form.

Blog Post: Microsoft Server Technologies Learning Plan for IT Managers

Deborah Grauer (Microsoft) — Wed, 08 Sep 2010 01:19:00 GMT

One of the best things about a Learning Plan is that Microsoft has done the hard work of finding and organizing relevant resources for you. If you're one of those busy types, what could be better?

This is a great Learning Plan to help IT managers, CIOs, IT generalists and other IT decision makers learn about the latest line of Microsoft server technologies, including Windows 7, Windows Server 2008 R2, Microsoft Exchange 2010, Microsoft Forefront, Microsoft System Center, Microsoft SQL Server, and Microsoft SharePoint 2010. Check it out and see what you can learn today.

Blog Post: Windows Azure Platform one month pass (US only)

Tjeerd Veninga (Microsoft) — Tue, 07 Sep 2010 20:42:00 GMT

We're offering a Windows Azure Platform One Month Pass, so you can put Windows Azure and SQL Azure through their paces. Get a pass to use the platform for a month and enjoy the learning and developer tools. It's a great way to get into Azure, for now the offer is valid in the US only and we will of course let you know of any other offers as soon as we hear about them.

Blog Post: From the Department of “What were they thinking?”

Regine Smith (Microsoft) — Tue, 07 Sep 2010 20:31:00 GMT

You accidentally dial the wrong number, calling an old boyfriend by mistake. You compose an e-mail complaining about your boss, and somehow send it to your boss.

It’s never pretty when these things happen; and, when we make mistakes like this we usually feel like idiots. Fortunately, there’s always someone just a little worst to make us all feel just a wee bit better about our own mistakes.

Each quarter, Microsoft Learning will feature several case studies based on a compilation of recent issues. Certain facts will be changed for illustrative purposes and to conceal the identities of the parties involved. The actions described below represent Microsoft’s efforts to curb cheating, fraud & piracy to maintain the value of Microsoft Certifications.

Protecting Microsoft’s IP: Disclosing Microsoft intellectual property (IP)

Chris Preston, who worked at a test center in Dublin, Ireland, was engaged to be married soon. The closer the wedding date arrived, the more he realized he needed extra funds to cover his wedding expenses. Thinking of no better way to make a few extra Euros, Chris chose to sell Microsoft Certification exam content on a popular English tech blog. Chris knew better than to use his real name on the blog; he used an alias: IT GENIOUS (of course!). Every day for a week Chris (a.k.a IT GENIOUS) signed-into the blog using his corporate email address and posted Microsoft Certification exam content. When Microsoft discovered these leaks, we investigated. A few clicks and a few IP addresses revealed the source of the posting: Chris@litwareinc.com. Microsoft requested that the authorities bring criminal charges against him.

Microsoft takes the protection and management of our Intellectual Property seriously. Unauthorized disclosure of confidential information has a profound business impact, and may lead to civil liability or criminal prosecution. Confidential information leaks can devalue Microsoft Certifications, and breach the trust of customers, business partners, governments and communities. Abuses of this nature are not tolerated.

All Microsoft Certification exams, including the content and wording of exam questions, are Microsoft confidential information and protected by intellectual property laws. Microsoft’s Exam Security and Integrity policy states:

Examples of misconduct and/or misuse of the Exam include, but are not limited to, the following: Copying, publishing, disclosing, transmitting, selling, offering to sell, posting, downloading, distributing in any way, or otherwise transferring, modifying, making derivative works of, reverse engineering, decompiling, disassembling or translating any Exam in whole or in part, in any form or by any means, verbal or written, electronic or mechanical, for any purpose

For general questions regarding security issues and questions, contact the Microsoft Learning - Security Team (mlsecure@microsoft.com).

If you have any information regarding piracy, exam fraud, violations or abuse, you are asked to contact Training & Certification Tips (tctips@microsoft.com)

________________________________________________________________________________________________________________________________________________________________

Theft

Here's a remarkable example of theft.

During a customer event, Microsoft Learning distributed Microsoft Certification exam vouchers to event attendees who participated in a customer survey. The fine print clearly stated that vouchers were available to survey respondents, limit one voucher per customer, and vouchers had no resale value.

Bonnie Kearney, who attended the event, returned to the survey booth multiple times over the 5-day event. She made sure different people were managing the booth and proceeded to answer the same survey over and over again. She walked away from the event with 17 vouchers. The assessed retail value of each voucher was approximately US$150.

One week later, Microsoft Learning Security was informed that Microsoft Certification exam vouchers were being sold on Proseware.com (a popular online auction website). Working with Proseware’s compliance team, Microsoft Learning Security was able to track the seller’s account.

The details of the theft were uncovered as part of a Microsoft Learning Security investigation. Bonnie admitted to fraudulently obtaining and selling “maybe 10” vouchers to out of state individuals who paid US$100 for each stolen voucher. Bonnie Kearney admitted to using the proceeds to pay for her own Desktop Support – Enterprise exam and training resources.

Bonnie was permanently banned from the Microsoft Certification Program. The matter has been referred to law enforcement.

For general questions regarding security issues and questions, contact the Microsoft Learning - Security Team (mlsecure@microsoft.com).

If you have any information regarding piracy, exam fraud, violations or abuse, you are asked to contact Training & Certification Tips (tctips@microsoft.com)

__________________________________________________________________________________________________________________________________________________________________

Not So Sharp!

If you’re ever arrested for smuggling, an excuse that almost never works is “Idunno.”

Last March, Shuh San Chan (曾澍山) walked into a testing facility in China to take Exam 70-668: PRO: Microsoft SharePoint 2010, Administrator. Before walking into the examination room, per the proctor’s instructions, Shuh San = placed his belonging in a locker… all but one…

45 minutes into the exam, the proctor noticed Shuh San pushing himself away from the desk and holding his hand towards the computer screen. Upon further observation the proctor realized that Shuh San was bold enough to sneak a cell phone into the examination room. The cell phone was examined fully and it was confirmed that Shuh San had taken screen-shots of the exam. Shuh San’s response when approached by the proctor: “Idunno”.

This is completely against Microsoft Certification Exam policy. Shuh San’s exam was immediately stopped, the screen shots were purged from his cell phone and he was escorted out of the testing center. But it didn’t end there. Shuh San was permanently banned from the Microsoft Certification Program and is no longer eligible to participate in the program. Worst yet, Shuh San worked for A. Datum Corporation, when his employer requested validation of Microsoft Certification; Shuh San could not provide it and had to reveal that he did not receive his MCITP Certification and was no longer a Microsoft Certified Professional; a requirement of his employment.

Although this particular candidate was blatantly involved in content theft, any type of cheating is not tolerated. It erodes the value of Microsoft Certifications. “Idunno” is not an excuse. Candidates should familiarize themselves with all Microsoft Certification exam policies and procedures prior to taking a Microsoft Certification exam.

If a candidate is caught cheating, violating testing rules, or diminishing the security and integrity of the Microsoft Certification exams in any way, the candidate may be prohibited from taking any Microsoft Certification exams and/or may be decertified from the Microsoft Certification Program. Such fraud includes, but is not limited to, the following:

Modifying and/or altering the original results/score report for this Exam or any other exam records
Violation of the current exam retake policy
Fraudulently impersonating another to gain access to the Exam
Submission of any work that is not completely your own
Providing or accepting improper assistance
Using unauthorized materials in an attempt to satisfy Exam requirements (this includes using brain-dump material and/or unauthorized publication of Exam questions with or without answers)
Disseminating actual Exam content
Possession of non-authorized items at the testing center during an Exam
Misconduct as determined by statistical analysis
Copying, publishing, disclosing, transmitting, selling, offering to sell, posting, downloading, distributing in any way, or otherwise transferring, modifying, making derivative works of, reverse engineering, decompiling, disassembling or translating any Exam in whole or in part, in any form or by any means, verbal or written, electronic or mechanical, for any purpose

For general questions regarding security issues and questions, contact the Microsoft Learning - Security Team (mlsecure@microsoft.com).

If you have any information regarding piracy, exam fraud, violations or abuse, you are asked to contact Training & Certification Tips (tctips@microsoft.com)

___________________________________________________________________________________________________________________________________________________________________

The names of companies, products, people, characters, and/or data mentioned herein are fictitious and are in no way intended to represent any real individual, company, product, or event, unless otherwise noted. Complying with all applicable copyright laws is the responsibility of the user. No part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Blog Post: Wanted: Your Microsoft Office Story

Krista Wall (Microsoft) — Tue, 07 Sep 2010 19:52:00 GMT

The folks at Microsoft Office are looking for a small group of U.S.-based families, students, technology influencers, small businesses, and home-based businesses (1-4 PCs) to participate in Microsoft’s Office 2010 Real Life Stories program.

This program provides a select number of people with a copy of Microsoft Office Professional 2010 on a loaner laptop PC along with dedicated technical support and web-based training in exchange for sharing their feedback and usage with Microsoft and potentially participating in Microsoft’s marketing efforts. At the end, you’ll receive a free copy of Microsoft Office Professional 2010 for your school, work or home use.

So what's the catch? Oh, you'll need to share your experience through videos, interviews, and/or quotes. I bet you know someone who would LOVE to be featured in something like this.

For information about the program and a link to the application, go to: http://connect.microsoft.com/officecustomerstories

Blog Post: New Microsoft Technology Associate certification launched

Devon Musgrave — Tue, 07 Sep 2010 15:07:00 GMT

On July 7, 2010 at the Education Leaders Forum Microsoft announced a new certification program for fundamental Information Technology and development skills called the Microsoft Technology Associate (MTA). Unlike more advanced Microsoft certifications, the MTA targets students with no prior IT or development experience or employment. It is available exclusively in educational settings and is designed to easily integrate into the curricula of existing computer classes. The MTA will eventually be available in thousands of high schools, vocational programs, and colleges in the U.S. and other countries. Testing will be conducted by Certiport, a commercial testing service, at participating schools.

Visit the MTA website (and click here to view the Microsoft PressPass feature). The program’s FAQs are here.

Here are the exams offered through the MTA program:

Developer exams

Software Development Fundamentals

Exam 98-361

Windows Development Fundamentals

Exam 98-362

Web Development Fundamentals

Exam 98-363

Database Administration Fundamentals

Exam 98-364

IT professional exams

Networking Fundamentals

Exam 98-366

Security Fundamentals

Exam 98-367

Windows Server Administration Fundamentals

Exam 98-365

And here are the MTA exam certification paths:

Some benefits for participating students:

Empowers students with a credential that validates fundamental knowledge and provides an essential foundation to build a career in technology
Allows students to explore a variety of technology career options prior to choosing a specialized career path—with minimal investment of time and money
Provides the first step towards becoming a Microsoft Certified Technology Specialist (MCTS) with MTA
Proves your commitment to technology and connects students to a community of more than five million Microsoft Certified Professionals
Builds confidence and helps students succeed with continued studies, compete on admissions, and prepare for a successful career in technology
Compliments business and other related courses and degrees with an industry-recognized technology credential

Blog Post: Author news: Mike Snyder on integration between Microsoft Word and Microsoft Dynamics CRM

Devon Musgrave — Mon, 06 Sep 2010 15:36:00 GMT

Mike here. We recently released a very cool two-way integration between Microsoft Word and Microsoft Dynamics CRM, and I thought you might be interested to check it out! In summary, our proprietary Word-to-CRM integration allows users to:

Build Word document templates that can load data from Microsoft Dynamics CRM
Once the data is loaded, users can edit their data in Microsoft Word and then save their changes back to Microsoft Dynamics CRM

This Word-to-CRM integration allows users to take advantage of the full word processing capabilities of Word, but still allow them to store and save the data back into CRM. We use this tool internally for our project charter, specifications, etc. but we also have clients using it for documents like leases, approval letters, quotes, legal notifications, etc. This tool fits in perfectly with many different XRM development stories, and it can support both on-premise AND Microsoft Dynamics CRM Online deployments (of course J).

To help show you how the Word-to-CRM integration works, we put together a short 3-minute screen cast demo:

Please check it out when you have a few minutes and let me know if you have any questions or want to learn more.

Thanks,

Mike Snyder

P.S. from Devon: Mike is a coauthor of the Microsoft Press titles Working with Microsoft Dynamics CRM 4.0 and Programming Microsoft Dynamics CRM 4.0.

Blog Post: Windows Phone 7: Almost There! How To Get Ready

Bob Caswell (Microsoft) — Fri, 03 Sep 2010 23:03:00 GMT

In case you missed the news, Windows Phone 7 cleared its last big milestone and has been released to manufacturing. Not only that, but the final version of the Windows Phone 7 developer tools will be available on September 16.

In the meantime, check out local boot camp training events (free!) or watch on demand 12 hours of comprehensive app training via the Windows Phone 7 Jump Start videos (with free course materials here). And last but not least, stay tuned to this blog for some exciting news coming in the next few weeks. I don't want to spill the beans too early (we're still finalizing the details), but we're working to bring you more live virtual training (meaning, anyone can attend regardless of location) on some pretty sweet Windows Phone 7 application development topics.

Oh, and let's not forget what's available for our iPhone developer friends: The iPhone To Windows Phone 7 Tutorial Series. It's not every day you get a chance to be part of such a massive Microsoft launch, so here's hoping we've made it a little easier for you through one or more of the above offerings. In the words of ZDNet, "Welcome back into the smartphone arena Microsoft, it looks like you have a serious challenger entering the ring..."

Blog Post: Steve Marx Reads The Azure Tea Leaves on Connected Show #36

Tjeerd Veninga (Microsoft) — Fri, 03 Sep 2010 22:04:00 GMT

Peter Laudati & Dmitry Lyalin host the edu-taining Connected Show developer podcast on cloud computing and interoperability. Check out episode #36, “Steve Marx on Azure”. In this episode, the one and only Windows Azure Tactical Strategist, Steve Marx, joins Dmitry and Peter to give us an update on the Windows Azure platform.

Steve talks about common real world Windows Azure use patterns, including storage and compute instance configurations. Steve uses some strategic tactics to tell us what’s in the tea leaves for the future of Azure.

CLICK HERE TO LISTEN!

If you like what you hear, check out previous episodes of the Connected Show at www.connectedshow.com. You can subscribe on iTunes or Zune. New episodes approximately every two weeks!

Blog Post: Out now: Microsoft Access 2010 Inside Out

Tjeerd Veninga (Microsoft) — Fri, 03 Sep 2010 21:32:00 GMT

Jeff Conrad and John Viescas’s Microsoft Access 2010 Inside Out (ISBN: 9780735626850; 1488 pages) is out now!

You can find the book’s chapter-level table of contents and an introduction to this in-depth guide to Microsoft Access in this previous post.

The book includes a companion disc that includes sample database applications, bonus chapters and technical articles, and a complete ebook.

In today’s post, please enjoy a deeper look at Chapter 11, “Modifying Data with Action Queries.”

Blog Post: The ArcTouchMouse - Meet the designer

Tjeerd Veninga (Microsoft) — Fri, 03 Sep 2010 20:41:00 GMT

A little off topic perhaps, but I just had to share this (after I added it to my wish list). Happy Friday!

Blog Post: New book: Microsoft Access 2010 Inside Out

Devon Musgrave — Fri, 03 Sep 2010 18:49:00 GMT

Hello. This is Kenyon again. We’re excited to announce that Jeff Conrad and John Viescas’s Microsoft Access 2010 Inside Out (ISBN: 9780735626850; 1488 pages) is now available for purchase!

You can find the book’s chapter-level table of contents and an introduction to this in-depth guide to Microsoft Access in this previous post.

The book includes a companion disc that includes sample database applications, bonus chapters and technical articles, and a compete ebook.

In today’s post, please enjoy a deeper look at Chapter 11, “Modifying Data with Action Queries.”

Chapter 11

Modifying Data with Action Queries

In Chapter 9, “Creating and Working with Simple Queries,” you learned how to insert,
update, and delete single rows of data within a datasheet. In Chapter 10, “Building Complex
Queries,” you discovered that you can use queries to select the data you want—
even from multiple tables. You also learned under what conditions you cannot update a
field in a query. Now, you can take the concept of queries one step further and use action
queries to change, insert, create, or delete sets of data in your database quickly.

The four types of queries you’ll study in this chapter are

Update query Allows you to update the fields in one or more rows.
Make-table query Allows you to create a new table by selecting rows from one or
more existing tables.
Append query Allows you to copy rows from one or more tables into another table.
Delete query Allows you to remove one or more rows from a table.

Note The examples in this chapter are based on the tables and data in HousingDataCopy.accdb
and ContactsDataCopy.accdb on the companion CD included with this book. These
databases are copies of the data from the Housing Reservations and Conrad Systems
Contacts sample applications, respectively, and they contain the sample queries used in
this chapter. The query results you see from the sample queries that you build in this
chapter might not exactly match what you see in this book if you have changed the
sample data in the files.

Updating Groups of Rows

It’s easy enough to use a table or a query in Datasheet view to find a single record in your
database and change one value. But what if you want to make the same change to many
records? Changing each record one at a time could be very tedious.

Remember that in Chapter 9, you learned how to construct queries to test proposed new
validation rules. In the HousingDataCopy.accdb database, there’s a table-level validation
rule defined in tblFacilityRooms that doesn’t let you enter a WeeklyRate value that
is greater than seven times the DailyRate value. If you want to change this rule to ensure
that the WeeklyRate value is no more than six times the DailyRate value (thereby ensuring
that the weekly rate is a true discount), you must first update the values in the table to
comply with the new rule.

\You could open tblFacilityRooms in Datasheet view and go through the individual rows
one by one to set all the WeeklyRate values by hand. But why not let Microsoft Access
2010 do the work for you with a single query?

Testing with a Select Query

Before you create and run a query to update many records in your database, it’s a good
idea to first create a select query using criteria that select the records you want to update.
You’ll see in the next section that it’s easy to convert this select query to an update query
or other type of action query after you’re sure that Access will process the right records.

You could certainly update all the rows in tblFacilityRooms, but what about rows where
the WeeklyRate value is already less than or equal to six times the DailyRate value? You
don’t want to update rows that already meet the proposed validation rule change—you
might actually increase the WeeklyRate value in those rows. For example, a room might
exist that has a DailyRate value of $50 and a WeeklyRate value of $275. If you blanket
update all rows to set the WeeklyRate field to six times the DailyRate field, you’ll change the
WeeklyRate value in this row to $300. So, you should first build a query on tblFacilityRooms
to find only those rows that need to be changed.

Open HousingDataCopy.accdb and start a new query on tblFacilityRooms. Include the
FacilityID, RoomNumber, DailyRate, and WeeklyRate fields. Enter the criterion >[DailyRate]*6
under the WeeklyRate field. Your query should look like Figure 11-1.

When you run the query, you’ll see 276 records that you want to change, as shown in Figure
11-2. (There are 306 records in the table.)

Converting a Select Query to an Update Query

Now you’re ready to change the query so that it will update the table. When you first create
a query, Access builds a select query by default. You can find commands for the four
types of action queries—make-table, update, append, and delete—in the Query Type
group of the Design contextual tab below Query Tools, as shown in Figure 11-3. (Switch
back to Design view if you haven’t already done so.) Click Update to convert the select
query to an update query.

When you convert a select query to an update query, Access highlights the Update button
in the Query Type group when the query is in Design view and adds a row labeled Update
To to the design grid, as shown in Figure 11-4. You use this row to specify how you want
your data changed for those rows that meet the query’s criteria. In this case, you want to
change the WeeklyRate value to [DailyRate]*6 for all rows where the rate is currently too
high.

Blog Post: Deploying Windows 7, but still running Web applications based on Internet Explorer 6?

Tjeerd Veninga (Microsoft) — Fri, 03 Sep 2010 18:31:00 GMT

Join us live at 9:00 AM Pacific Time on Thursday, September 30, 2010 for a virtual, interactive roundtable discussion on migration strategies, standards, and support for organizations moving from Internet Explorer 6 to Internet Explorer 8.

As organizations deploy Windows 7, many still depend on web applications that were designed for Internet Explorer 6. Will they still work, and what can you do when they don’t? Join a panel of IT Professionals, Microsoft specialists and technical experts to discuss best practices to simplify and accelerate the migration to Internet Explorer 8. Topics will include an explanation of the causes of and solutions for application compatibility issues (including policy, code, and virtualization solutions), an introduction to tools, and a review of best practices. (Check out our latest blog post with the latest resources around working with IE 6 in Windows 7).

Ask your questions live during the event with our online tool - or submit your questions in advance to vrtable@microsoft.com.

By the way, more Springboard Series Virtual Roundtables can be found here: Watch them on demand.

Blog Post: Even I Would Love to Learn how to Build Apps on WP7 for Free

janapbutler — Fri, 03 Sep 2010 00:29:00 GMT

Windows Phone 7 gives you the power to build complex, robust applications using consistent hardware specs, a comprehensive development toolkit, and the all-new, full-service Marketplace for selling your apps. To celebrate, we’re launching two days of fast-paced learning that will help you stake your claim in this exciting new frontier. The first day takes you inside the all-new Metro interface paradigm with basic fundamentals of Windows Phone 7 application development. The next day is a hands-on app building workshop. Bring your best ideas, work at your own pace, or join a proctored group lab and create that app you’ve been dreaming about. Check out the agenda and choose one or both action-packed days. Whatever you can imagine, you’ll be ready to build awesome new apps with Windows Phone 7. Register today, before space runs out.