Access

Macros search form

Today’s guest writer is Kerry Westphal—our resident macro expert. A common feature in well-designed applications is giving users the ability to quickly focus on the data they care about. A search or filter form allows users to specify criteria to limit the records returned. This also enhances performance because the entire recordset is not brought in. A typical filter form provides unbound text boxes, combo boxes, and other controls where…

PowerPoint

OneNote 2010 and PowerPoint 2010: Easy note-taking while reading presentations

Today’s post is a guest post from Alex Simmons, a Program Manager on the OneNote team. OneNote 2010 is included in every edition of Office 2010, so make sure to try it out! Hi everyone,  we’ve built a new feature in OneNote 2010 that allows you to take more meaningful notes while reading in other applications.  We call the feature Linked Note Taking, an automatic feature when OneNote is docked…

Access

Power Tip: Create an AutoNumber field that starts with a number greater than 1

Today’s guest blogger is Luke Chung, President and Founder of FMS, Inc. Luke has written and presented a wide range of topics related to Access over the years. In addition to their many Access related products, FMS offers a wealth of great Access papers, tips, and video on their site. In Microsoft Access tables, the AutoNumber field type allows you to assign a unique sequential number to each row in…

News

New for Excel 2010: Sparklines!

Guest blogger Sam Radakovitz, program manager for Excel, has a post today on a sparklines, a new feature in Excel 2010. For Excel 2010 we’ve implemented sparklines, “intense, simple, word-sized graphics”, as their inventor Edward Tufte describes them in his book Beautiful Evidence.  Sparklines help bring meaning and context to numbers being reported and, unlike a chart, are meant to be embedded into what they are describing.  As you can see, I’m really…