Microsoft Office

From the Microsoft Access Blog: Interested in a sneak peak at our next version of Access? We are holding a developer kitchen on the Redmond Campus, November 10-13, 2008. This conference will focus on building Access 14 applications using our latest builds. We are looking for Access developers to share with us early feedback on the product before the Beta release.

What is a dev kitchen?
This conference is designed for a small number of invited guests to spend four days with our Redmond team. On Day 1, Program Management will reveal the product vision, demonstrate new functionality and answer questions. Days 2 - 4, participants will be hands-on with the product. Feedback will be collected throughout the conference.

What is in it for me?
All participants will get the chance to impact the next version of Access through early access to the latest bits of the product, the ability to connect 1:1 with members of the product team, and to network with other members of the Access community.

Who is invited?
Space is limited, so priority will be given to companies and individuals with the following:

Develop simple apps that are sold to small businesses and people that organize communities.
Enterprise IT managers looking for ways to manage Access development in your environment.
Existing book authors with plans to update a book.
Respected members of the Access community (newsgroup, web sites, conference speakers, etc).
Details
The conference is FREE. Participants are responsible to cover their own travel and expenses. For more information or to secure your invitation, please send us mail. Space is limited, so please tell us why you are the ideal developer kitchen participant.

Microsoft works collaboratively with educators across Higher Education and K-12 to provide software plus services aimed at enhancing the learning environment and streamlining the operations of institutions.

This site is your resource for webcasts, podcasts, and other valuable information to gain insights into how Microsoft and Microsoft Partner solutions can help enable learning in the 21st century.

What’s coming up:

Are you up to date on US Education Market Trends and Microsofts EDU Priorities and Vision?

Live Oct 3 10:00AM-11:00AM Pacific Time

Education is the foundation for success and the link between employability and economic output. Public education is under much pressure for change in order to deliver a 21st Century Workforce able to flourish in the global economy. These trends are driving Microsofts education focus and business opportunities in key areas. This webcast launches our Partner Webinar Series and sets the stage for all future webcasts. In this session, we will scratch the surface on trends Microsoft is seeing and that research groups (e.g., Center for Digital Education) have confirmed. These trends represent the drivers behind substantial business opportunities we see for Microsoft-based solutions and they have played a role in the development of Microsofts education marketing campaigns that will help support the business.

Speakers:
Mary Cullinane—Director, Innovation and Business Development
Anthony Salcito—General Manager

Live@edu Overview
Live Oct 6 9:00AM-10:00AM Pacific Time
Looking for innovative solutions for keeping your students and alumni connected? Learn about Live@edu, Microsoft’s newest platform for delivering student and alumni email, communication and collaboration services. Join us for this one hour presentation on Microsoft’s Live @ EDU offering that offers:

The Apps students want

A co-branded email inbox students can use as their primary account, with additional services like Office Live Workspace, Windows Live SkyDrive, and more of things that encourage collaboration.

Integration with what you have in place

Live@edu works with the devices your students already use, and integrates with the infrastructure you already have.

Reliable Infrastructure

Outsource the time and cost of spam-filtering, server uptime and ongoing maintenance to Microsofts enterprise-class infrastructure.

Safety and Privacy

Keep your students data private and help keep them safer online. All for free to your institution!

Speakers:
Jonny Chambers—Senior Solution Specialist - Live@Edu

Applies to: Microsoft Office Access 2007, Excel 2007, InfoPath 2007, OneNote 2007, Outlook 2007, PowerPoint 2007, Project 2007, Publisher 2007, SharePoint Designer 2007, Visio 2007, Word 2007

ScreenTips are small windows that display descriptive text when you rest the pointer on a command or control.

Enhanced ScreenTips are larger windows that display more descriptive text than a ScreenTip and can have a link to a Help topic. Enhanced ScreenTips are available in the following 2007 Microsoft Office system programs: Access, Excel, PowerPoint, and Word.

In the following 2007 Microsoft Office system programs: Access, Excel, PowerPoint, or Word

Click the Microsoft Office Button, and then click Access Options, Excel Options, PowerPoint Options, or Word Options.

Click Popular.

Under Top options for working with Access, Top options for working with Excel, Top options for working with PowerPoint, or Top options for working with Word in the ScreenTip style list, click the option that you want:

Show feature descriptions in ScreenTips

This option turns on ScreenTips and Enhanced ScreenTips. This is the default setting.

Don’t show feature descriptions in ScreenTips This option turns off Enhanced ScreenTips. You still see ScreenTips.

Don’t show ScreenTips This option turns off ScreenTips and Enhanced ScreenTips.

In the following 2007 Microsoft Office system programs: Visio, InfoPath, OneNote, Publisher, SharePoint Designer, or Outlook

On the Tools menu, click Customize.

Click the Options tab.

Under Other, select or clear the Show ScreenTips on toolbars check box.

In Microsoft Office Project 2007

On the Tools menu, point to Customize, and click Toolbars.

On the Options tab, under Other, select or clear the Show ScreenTips on toolbars check box.

If you love suduko, check out this Microsoft Excel blog, courtesy of Joseph Chirilov

Today’s author, Charlie Ellis, a Program Manager on the Excel team, shares a spreadsheet he built in Excel for solving Sudoku puzzles. The spreadsheet can be found in the attachments at the bottom of this post.

For those of you who don’t already know, Sudoku is a type of logic puzzle (that I was completely addicted to about three years ago) that requires you to place the numbers 1-9 into a grid obeying certain rules (lots more information on Sudoku is available on the web).

A while back, a fellow PM on the Excel team, Dan Cory, wrote a spreadsheet for solving Sudoku puzzles using Excel formulas and made it available on Office Online (here). Dan’s spreadsheet was great in that, unlike many of the Sudoku solving spreadsheets out there, it didn’t use any VBA or other scripting to do the work of solving the puzzles, and relied instead on the iterative calculation feature of Excel. It’s quite cool and has been a popular download, but one thing about the spreadsheet that I wanted to see if I couldn’t improve upon was just how complicated it is. In fact, Dan made every single cell its own different formula, and he ended up having to use VBA to create the formulas because maintaining and debugging it without VBA to write all those different formulas in an automated way was impossible.

As soon as I saw Dan’s spreadsheet, I wanted to make my own version of a Sudoku solver that not only used only formulas, but also one where the formulas were relatively understandable and there were a small number of distinct formulas. It turned out to not be that tough to build, but I think I learned a fair amount trying different approaches to the problems of making an iterative model like this one perform well and at the same time be reasonably maintainable and understandable. I think it might even have turned up a reasonably useful way at looking at abstraction within formulas given the Excel formula language. I’ve always wanted to blog about the process of creating this spreadsheet and about how iterative formulas work to show the power of Excel’s formula language, because it illustrates the usefulness of circular references and iterative calculation, and because I just think it’s an incredible amount of fun so here goes. Lots of people have created more powerful solvers, many as spreadsheets, some using just formulas, but I wanted to try to explain how you can go about creating a solver and hopefully share some formula tricks that people find useful.

From the Office blog: a great way to avoid a security breach is to click the Office Button (the orb in the upper left hand corner of Word 2007), click Prepare, click Encrypt Document, and enter your password.

The nitty-gritty details from David LeBlanc’s Web Log:

Let’s start with the worst of it – XOR. You may note that I consistently refused to ever say “XOR encryption”, preferring the more accurate “XOR obfuscation”. Not only is it the worst way to protect a document, but it was horrible to try and explain. We did all sorts of silly things to make this hard to figure out, it did nearly nothing to actually protect the data, but it sure was no fun to try and document in a normative style. I believe this obfuscation dates back to around 1994. Here’s some pseudo-code to show you the sheer horror of it all – this is from one of the two password verifier approaches:

FUNCTION CreatePasswordVerifier_Method1
PARAMETERS Password
RETURNS 16-bit unsigned integer
DECLARE Verifier AS 16-bit unsigned integer
DECLARE PasswordArray AS array of 8-bit unsigned integers

SET Verifier TO 0×0000 SET PasswordArray TO (empty array of bytes)
SET PasswordArray[0] TO Password.Length

APPEND Password TO PasswordArray
FOR EACH PasswordByte IN PasswordArray IN REVERSE ORDER
IF (Verifier BITWISE AND 0×4000) is 0×0000
SET Intermediate1 TO 0
ELSE
SET Intermediate1 TO 1
ENDIF

SET Intermediate2 TO Verifier MULTIPLED BY 2
SET most significant bit of Intermediate2 TO 0
SET Intermediate3 TO Intermediate1 BITWISE OR Intermediate2
SET Verifier TO Intermediate3 BITWISE XOR PasswordByte

ENDFOR
RETURN Verifier BITWISE XOR 0xCE4B
END FUNCTION

If this makes sense to you, and you want to know kre, click either of the links above.

From Olya Veselova’s blog: If you are not familiar with creating Outlook tasks flags from OneNote notes and synchronizing them, you can read about the basic here: OneNote and Outlook task syncing.

This post is about using OneNote and Outlook task sync for in team shared notebook. (What’s a shared notebook?)

Summary: If you create a list of team tasks in a OneNote shared notebook, you can make them into Outlook tasks and assign them to team members. The nice thing in OneNote 2007 B2TR is that these tasks will keep synching with the OneNote shared notebook for any of the team members who have the task in their Outlook (assigner, or assignee) and the notebook open.

When is this useful?

Your team may want to keep track of particular project tasks in one place - on a page in in the shared notebook with the rest of project materials (ideas, reference materials, drafts, comments, etc.). This is often done for a list of action items from meeting notes (e.g. recurring status meeting), or just a list of work items for the team. Each team member responsible for a particular task can still have the task in their own Outlook and manage it in whatever way they like managing their Outlook tasks. But the task will also sync with the shared notebook if they have it open. So the other team members can see that the task has been done when they review the shared notebook page.

Ho to do it:

Let’s say there is a list of team tasks for next week. I have already created an Outlook task for myself, and now I want to create the task for Dave:

put the cursor on the task note for Dave and select Task > Custom:

In the Outlook task inspector that comes up I click Assign Task:

The task now appears in my Outlook, but it is also sent to Dave.

When Dave marks the task complete, I also get a message. And the task disappears from my To-Do Bar, because it is complete.

Since my OneNote is syncing with Outlook, this fact is also reflected in the OneNote shared notebook for the whole team to see:

Note that I can even delete the task that I created for Dave from my Outlook. As long as Dave has the task in his Outlook and has this shared notebook open, his OneNote will sync with the task status and the whole team will be able to see that the task is complete.

From Microsoft Outlook Team Blog: You’ve seen several posts on the Outlook Team Blog focused on ways to help you more effectively manage your incoming e-mails and appointments in Outlook. Office Labs has also been exploring some innovative methods to help people manage the vast amounts of information they receive on a daily basis.

To help alleviate this information overload, Microsoft Office Labs released Email Prioritizer last week on www.officelabs.com. The prototype – inspired by Microsoft Research’s “Priorities” project – is an add-in for Microsoft Office Outlook 2007 that was built by the Office Labs development team here in Redmond. Email Prioritizer provides a “do not disturb” button that temporarily pauses new email arrival from ten minutes up to four hours. Email Prioritizer will also assign priority ratings of 0 to 3 stars to incoming mail to help users focus their attention on the most important email messages.

While we encourage you to test out our prototypes, they are unsupported concepts with no plans for inclusion in any products. Please direct any feedback you have on Email Prioritizer to Office Labs at emailpfb@microsoft.com.

Thanks!

* Email Prioritizer is a plug-in for Microsoft Office Outlook 2007 (running on Exchange Server) that helps you manage email overload. This concept test provides a “do not disturb” button that temporarily pauses new email arrival, and prioritizes email with a 0-3 star rating system. We hope this prototype helps you focus on the emails that are most important to you.

Low-cost and no-cost survival tactics require a “business-as-usual mindset.”

According to Rieva Lesonsky, former editor of Entrepreneur and blogger for Microsoft Office Live Small Business (http://smallbusiness.officelive.com), entrepreneurs can use this time to cut back in certain areas and strategically invest in other areas, such as marketing. “It may seem counterintuitive, but increased marketing and sales activity can be an effective way to bolster your business and weather economic storms,” Lesonsky said. “In fact, marketing is a key component to your small business’ survival.”

So what should current and aspiring entrepreneurs do during these tough times? Lesonsky offers the following advice:

• Keep overhead low. Entrepreneurs should take a hard look at their expenses and scale back on nonessentials. Some big cost-cutting areas include business travel, labor and rent. For example: Entrepreneurs can try videoconferencing instead of traveling to a meeting; consider forgoing pricey office space and work from home instead; and re-examine their staffing plan to ensure they have the right amount of coverage for their current level of business, keeping overtime costs to a minimum.

• Make noise. In this economy, competitors are likely cutting back on marketing spending too. This provides an opportunity for entrepreneurs to get their marketing message out in a potentially less cluttered environment, and possibly at a better rate too. In addition to traditional forms of advertising, entrepreneurs can take advantage of low-cost digital marketing tactics, such as creating a blog, building an audience with Twitter, staying on top of their ratings through online review sites such as Yelp, and creating company pages on social networking sites such as Facebook and LinkedIn.

• Have a strong online presence. Increasingly, consumers are using the Web to find businesses of all sizes, so it’s really crucial that small businesses be visible online in order to compete. Today, there are a number of low- or no-cost options to help entrepreneurs establish a professional Web presence without the expense of hiring a designer or Web master. Microsoft Office Live Small Business (http://smallbusiness.officelive.com) provides entrepreneurs with a free Web site and hosting, a custom domain name and business e-mail free for the first year, low-cost e-commerce and online marketing tools, and free business management tools.

• “Hire” customers. Entrepreneurs can turn satisfied customers into a word-of-mouth referral engine for their business. They can consider offering referral fees or free services to encourage customers to refer new clients. Entrepreneurs can also ask customers to provide testimonials that can be showcased on the company Web site and marketing materials.

• Always negotiate. Entrepreneurs should keep in mind that everything is negotiable. When other businesses are cutting back, entrepreneurs are in a better position to negotiate for lower rates, better ad placements, lower telephone rate plans or other discounts such as on office supplies.

These and other small-business tips from Lesonsky can be found on the Office Live Small Business blog at http://www.myofficelivecommunity.com.

hot fixes the Accesscommunity might find useful. Hot fixes are now available for the following Microsoft Office Access issues:

Access 2003

An Access 2003 project (.adp) stops responding when in table Datasheet view, you delete all child rows from a parent row and then delete the parent row. This issue applies only to an Access 2003 project.
A database in .mdb format in Access 2003 SP3 stops responding when you try to delete a parent record from a table in Datasheet view and the Datasheet view uses a sub-datasheet that is expanded to show the related child records.
The hot fix for these Access 2003 issues can be obtained through the following article:

http://support.microsoft.com/kb/956722

Access 2007

In Access 2007, you create a query that does not contain a parameter. When you export the query to a Microsoft Office Excel Worksheet, the Enter Parameter Value dialog box opens.
When you open a chart object in Access 2007 on a computer that is running Windows Vista or Windows Server 2008, you see a blank chart.
After you upgrade Access 2003 to Access 2007, operations on existing forms have slow performance.
You cannot use the SetValue macro in the click events of a Button control to set the Locked property of a Check Box control in Access 2007.
You have a printer that has a staple feature. When you print an object in multiple copies in Access 2007, all the copies are stapled as one unit. However, you expect that each copy is stapled individually.
The hot fix for these Access 2007 issues can be obtained through the following article:

http://support.microsoft.com/kb/956054

How can I use it?
There are dozens of ways to use Microsoft Office Live Workspace beta for work, school, and home projects.

For Work:

Access documents when away from your desk
Save documents and access them from any computer
Stay productive at home, an Internet café, library, airport, etc.
Share documents with others

Gather feedback on a document, report, or presentation
Share with people who can’t access your corporate network
Prepare for a meeting
Share the agenda, minutes, and action items
Post meeting handouts or presentations

For School:

Organize a study group
Work together on assignments and share notes from class
Keep a shared schedule and task list for your group
Keep track of important school information
Manage schedules from sports to registration deadlines

Track your GPA and progress toward degree requirements
Coordinate with club or team members
Post and manage schedules (for sports, clubs, etc.)
Share lists of who brings what (no more e-mails back and forth)

For Home:

Organize an event
Use for a party, camping trip, even a wedding
Share to-do lists, timelines, budgets, directions
Save your information and keep track of favorite things
Access important passwords, frequent flyer numbers, etc.
Create Top 10 lists of your favorite films, restaurants, books, etc.—and keep them private or share with friends and family

Prepare for a trip
Plan for the trip with travel budget and packing list templates
Share your itinerary, contact info, and important documents with colleagues or family

What is a workspace?
A workspace is an online place where you can save, access, and share documents and files. Use it to group related information for work, school, or personal projects. Sharing is easy – all you need is a person’s e-mail address and you can invite them to your workspace. You decide if they can edit or simply review. You can access your workspace from any computer with an Internet connection and a Web browser. Who is it for?
Anyone who uses Microsoft Office can benefit from this service. If you answer ‘yes’ to any of the following questions, this service is for you:

Do you save information on a flash drive or send yourself documents via e-mail to work on later?
Do you need to access work files when away from your office?
Do you need to access school documents when away from your desk (at the library, home on break, etc.)?
Do you share documents via e-mail and then manually merge all the comments later?
Do you use e-mail to coordinate and share information with your sports clubs, PTA, study group, etc?
Are you planning an event and coordinating with multiple people or vendors?