New PCs have pre-installed often a free version of Office: Office-starter. These free versions of Word 2010 and Excel 2010 will give you many features and, hopefully, your appetite for more. Let me you Office-Starter:
Read more about Office starter at Office.com.
--Doug Thomas
We are almost there: on track for release in all language versions, Service Pack 1 for Office 2010 and SharePoint 2010 is end of June. Here are some of the features and improvements, the SP1 install Office 2010, according to today's announcement:
Integrated community content in the Web part Gallery access application. The Word Web app enhanced printing support "Edit mode". Internet Explorer 9 "native" support for the Office Web Apps and SharePoint.Office Web apps Support for Chrome.Inserting charts in Excel workbooks by Excel Web Access,Outlook Web Access attachment preview (with Exchange online only).When the time comes, we give the release and control to TechNet and help the Sustained Engineering Team Blog for the downloads and information.
-Holly Thomas
Today's power tip is provided by Juan Soto.
I love of form variables. It my code faster and easier to read, and they also offer a great way to remote control another form without is in this form or have it focus. Another advantage is that reading data record values from a form faster than using a Recordset much use a table from the hard disk. If you know that the data you are looking for is already loaded on a form, the read you a form variable can speed up your application.
For example, suppose I am coding in a form with the name of FrmOrders and I need called to controls on an open form (you can only a form variable to an open form map) FrmCustomers read. I would use the following code to my variable instantiate:
Dim frm as Form_frmCustomers
Dim LngCustomerID as long
If CurrentProject.AllForms("frmCustomers").IsLoaded, then
Set frm = forms! FrmCustomers
' Use the frm variable fields from the form read
LngCustomerID = Frm.CustomerID
Else
"To a different technique to CustomerID find using"
End if
The frm as Form_frmCustomers instead of the generic type form declare one of the advantages, that IntelliSense is opens so that you refer to controls on the form. You can do this with any shape, which is already loaded. So make sure that you followed by the name of the form "Form_" at the declare variable of this type use.
Subforms will lose as part of the main form and their own identity, as soon as they are loaded. A subform to reference, you must use the form property to associate the form variable contains the subform. We take on FrmOrders is the parent form and the name of the subform in FrmOrdersis FrmOrderItems_sub . If you need to reference the subform, this could do in the following thing:
Dim frm as Form_frmOrderItems_sub
Set frm = forms! frmCustomers. frmOrderItems_sub.Form
See the note on the .Form property at the end of the second statement, which is required to the variable frmsubform map.
Note 1: You can use only form variables in forms that have modules; Otherwise, the compiler will error out.
Note 2: Make sure that you reference the correct name of the subform to the main form or the code will not work. For example, if the subform control has a SourceObject is set to a form named "FrmOrderItems_sub", but a control name of "Order items" on the main form has code should look then like this:
Dim frm as Form_frmOrderItems_sub
Set frm = forms! frmCustomers.OrderItems.Form
I encourage you start in your code using form variables, if you need to reference a form from one other. It is another great tool in access, which facilitates sharing information about your application and may even accelerate it.
Juan Soto is senior Access developers at AccessExperts.net. His blog is at AccessExperts.net/blog. You can subscribe to it here. Juan is a frequent speaker at access and SQL Server user groups nationwide and is a contribution to the access blog.
Send your power tips to accpower@microsoft.com!
--Chris downs
If you're a small business owner, you're probably always on the lookout for resources to help you run your business more easily. Whether you're a Windows fan or a Mac lover, the following 10 tips and tricks from the Office team will help you get more done whether you're in the office or on the go.
1. Make your blog pop. Embed a PowerPoint slide show or an Excel calendar into a blog post with just a few easy steps. Share your wares, whether they're delicate earrings or custom bikes, via an embedded PowerPoint slide show in your blog. 
2. Manage multiple email accounts from Outlook. In a recent survey by MarketTools*, 67% of those polled said they are afraid of overlooking messages as they manage several inboxes. Microsoft Outlook lets you use multiple email accounts and address books and easily manage all your different folders from a single, centralized view.
3. Stay on top of your Inbox with Outlook 2010. Save time by using features like Conversation View, Clean-Up Conversation, and Ignore in Outlook 2010. You'll spend less time combing through email and more time doing the things that matter.
4. Bring the power of social media to your Inbox with the Outlook Social Connector. The Outlook Social Connector allows you to view your contacts' Facebook and LinkedIn feeds without ever leaving Outlook. This is a great way to know the latest from your customers and colleagues right from your Inbox. 
5. Broadcast your presentation to remote participants with PowerPoint 2010. With the Broadcast Slide Show feature in PowerPoint 2010, you can quickly share your presentation with anyone, anywhere, all directly from PowerPoint 2010. You can just send a link, and in one click everyone you invite will be watching a synchronized view of your slide show in their browser. They don't need to have Office to tune in.
6. Leverage multimedia with just a few clicks. Make quick edits to photos in Word, PowerPoint and Excel in Office. Also edit audio and trim videos from within PowerPoint.
7. Use OneNote 2010 to capture and organize all your ideas in one place. With Microsoft OneNote 2010, you can take notes, insert audio clips, videos, screen clippings, conversations and emails into your own digital notebook. You can also share your notebook with others, and you can view your notes on your desktop, on the web or from your phone.
8. Save time by making Office.com templates and Publisher your BFF. Balancing your business (and your family, and volunteering and chores, and...) can be exhausting. Don't want to create that budget from scratch, or that presentation with a blank slate? Need professional-looking business cards? The Office templates for small businesses have you covered. Consider Publisher for creating your own marketing materials and newsletters as well.
9. Become a budget maven in less than five minutes with Excel templates. There are some great Excel templates and videos available to show you how to turn your monthly budget spreadsheet into a work of art, all in under five minutes! When you're on the go, try Excel Mobile 2010 on your Windows Phone 7. 
10. Keep your documents at your fingertips with Office Web Apps. We know that your "office" can be a coffee shop or the bench at your kid's soccer practice. The free Office Web Apps give you the ability to access, edit and share Word, Excel, PowerPoint, and OneNote documents with colleagues and business partners from almost anywhere via a web browser.
Read about using Office Web Apps and much more with Microsoft Office 365 here: Why Small Businesses Will Love Office 365.
Hope you find these tips useful and happy National Small Business Week!
-- Celeste Murillo, Senior Product Manager, Microsoft Office
Read more about how two small businesses are putting these tips and tricks to use: aNb Media case study and Basic Black case study. Also, please note that features like Ignore and Clean Up in Outlook, the Outlook Social Connector and OneNote are available only in Office 2010.*MarketTools, Inc. study commissioned by Microsoft Office, May 2011; online survey of 1,268 professionals and students ages 18 and older.
If the work in the perfect e-Mail message to write that, it's nice to know that someone has you all, receive and read it. Outlook has a feature that, that can help, but it is not a one-way street: the receiver must be prepared, cross it with you.
I like it this way to think about: If you order a meal in a restaurant, you know that the Chief has received your "message", because your food arrives a short time later (provided you the chef by annoyed too many proposals not yet). When it comes to e-Mail, but not things so black and white. How can you be sure that someone has received and actually read your message? To put it bluntly, you can know just for them, so that you... but you can do it. Can know you it is for the recipient to inventory if they have read (or even receive) your note, but it really decide to them is whether or not know.
Oh, people play games...
First let's find out how to set up message tracking. Because if you do not first, you can use it.
You have sent a very important message to people. They may be a teacher who wants to know that your pupils and students their homework got you by to them e-Mail. Or perhaps you take a survey in your company and want to make sure that everyone received and read ask the e-Mail to respond to the survey. In Outlook, you can set up a message so that each recipient has the option, you informed that they have: (1) the message received and read (2) the message.
You can be notified on a particular message, or you can it set up so that you be notified of all messages. Find out more in a minute.
You have now done all that you can do. But just because you have taken these steps does not mean that there is a 100% is sure thing, you know, if your recipient read your message. And why is that? I'll say it again: because it up to the recipient to let you know... is or not. See, while you have read about setting up message tracking, to change automatic response to read receiptsread. Your recipients have the option to send a read receipt whenever this is required, to never send, or, on a case by case basis, decide whether a send.
I therefore recommend news important to tracking only single. If people get a number of tracked messages, they are more likely to get irritated and just say the hell with it and never send a receipt.
Now that you know how to set up a read receipt, there are a few other things you can do to try to, keep track of things:
Now, for what I mean about read receipts? Can the component you are set up so that the recipient knows it request one, but it is up to you to decide whether she want to know, that she know, that you want to know whether you got your message.
And perhaps want to know it not. Perhaps you two have on some mind game sick little to go. I have no idea; still I care. My only part in this is learn about your options and then set you free, and are the most professional e-Mail senders can, that you be.
Crabby Office Lady of searches of the week: students: buy a PC and get a free XBox
Must not to help you find out the different channels you have tried? Answers Microsoft , the answers to your nagging problem can have.
Office partner
Sometimes I wonder how it is to work in marketing. I know other times, what is it...
Today's Office comic was inspired by a previous comic I have cloud terminology.
Random tip: the thesaurus in Word rocks. Instead of drop a hat, try the thesaurus.
David Salaguinto
Today's post was written by Angela Chu-Hatoun, senior programmer author on our large Office team, much more technical than I am that, frankly, and to explore the deep down side of programming, how it works and how can you even do it well.
This can post 13, on the MSDN Office client developer content-blog originally appeared last Friday, (display name: dev docs) and I had to Angela simply questions whether I was able to publish it here. I figure that there is a good tandem piece on my post September 2010 what is a macro and why you should use it.
Developers and power users still no programming using the Excel object model take note: there is a new series of videos that show how to create, edit and run macros in Excel 2010: Save time by creating and running macros in Excel 2010.
This set of four videos ranges in length from three to five minutes. To learn an object model for our purposes, I would like to call the first two videos in the set:
The first video in the series shows how to record a macro that fills a number of cells in a workbook. The second video shows how to view and edit the Code Visual Basic for applications (VBA) for the recorded macro in the Visual Basic Editor (a MIcrosoft programming language tool).In General, is the application object model for Office client applications that support macro recording, use the Visual Basic Editor the code which is a convenient way to learn a recorded macro (Excel, Visio, Word) and write the code for a task, the set of actions in the application's user interface associated with. You can use the code as the basis for the recorded macro and extend the functionality by more code to achieve your purpose. Recently, I have to a similar approach to how to use the Word object model, learn to look for a string in an e-Mail message. I tried recording a Word macros in the search for a string in a Word document. Then, I have adapted the code and wrote the macro for the blog post look like to a string in an Outlook e-Mail message and automate a response that contains the string.
(Already lost a bit?) What read an string is in computer science. (This is all easier than you might think.)
If you are new to programming with the Excel object model or even Visio, or Word, watch the training videos and consider approaching the object models by recorded macros!
(Thanks Angela;) I guess really let you steal me this amazing information. People do like you is one and expand you: go to the Office Dev Docs Blog and learn some new tricks. (Well, I go this programming to explore me... abdomen)
Office partner
