Sunday, October 26, 2008

What's new in Powerpoint 2007

Here's a good list at Echo's Voice with tutorials as well.

Disabling Legacy Keys

Most requests from clients and participants in training so far have been about revealing or allowing legacy menu items or keystrokes from Office "classic" to Office 2007. Ron (a veteran Excel guru) has come up with the opposite idea for Excel developers who want to lock down Excel. Disable Excel 2003 Menu Accelerators keys in Excel 2007

Ken Puls has also been at it - he has written a RibbonX book and writes how to use Sendkeys to flip a Tab on the Ribbon.

Wednesday, October 22, 2008

Presentation Tips

SAN FRANCISCO, CA - JANUARY 9:  Apple CEO Stev...Image by Getty Images via DaylifeI'm slated to facilitate a Powerpoint 2007 class soon. Without presentation aids, here's Steve Jobs, circa 1991 using just a wyteboard, emphatic speaking, pushing points across.

Reblog this post [with Zemanta]

Access File Recovery

From time to time, we encounter Microsoft Access corruption problems (well, our clients do). There are several expert Access Recovery services. Everything Access is one of them. There is a good article there on DIY self recovery tutorial as well as setting the Encryption Type.

Reblog this post [with Zemanta]

Tuesday, October 21, 2008

Access 2007 Control Layouts

Microsoft Office Access ScreenshotImage via WikipediaDeveloping in Access 2007 is a welcome change. Yes, there are gotchas and unfixed legacy annoyances from Access "classic" but there are also some warm hearted changes. The new Access Control Layouts in the Form and Report Designers are nice. We've wanted a release from the drudgery of fixing Tab Order in Controls once we reorganise our Forms and we've wanted easier alignments and sizing of Controls for a long time. Finally it's here. Not perfect but nice anyway. Read the Office writeup and see the brief video.

Reblog this post [with Zemanta]

Thursday, October 9, 2008

Powerpoint Tips

I was just working with Teresa on Powerpoint 2007. It was a nice session. Coming back home, I notice from Presentation Zen that Seth Godin has some non technical tips for content

Monday, October 6, 2008

Access 2007: Go to a Record Combo Box Wizard

In Access classic I've run the Control Wizard during Form Design, to generate a combo box record navigator. That is, the Combo Box displays a list of record identifiers and after selection, the Form displays the relevant record. The Control Wizard that makes this always worked in class and when working.

In a recent Access 2007 class, this no longer worked. Fine, I thought, they have removed the feature - maybe they haven't translated the VBA coding to Access 2007 macro coding. But wait, let's go check Google Groups.

It appears that is the record source of the Access 2007 Form is not simply a table, but an SQL string, that third option doesn't present itself. Maybe in classic Access, that was the same deal but it never hid itself from me.

Reblog this post [with Zemanta]

Don't forget the Excel MVPs

Excel has dedicated and well presented bunch of Most Valued Professionals. Here's a list of them:

Reblog this post [with Zemanta]

Thursday, October 2, 2008

Access 2007 How-Tos and Resources

Book cover of Book cover via AmazonI just came across some more Access 2007 Resources

I normally use classic Northwind 2000 (available from Microsoft or in Access 2003, should be installed on your machine already) to demonstrate Access features and techniques. Just came across Matthew MacDonald's Adventureworks database from his Missing Manual (direct zip file download) which I guess he got from SQL Server's sample data.

You Tube video demo of how to use collect responses via Access 2007 and Outlook 2007.

You Tube video demo on the new Control Layouts on Forms and Reports

You Tube video demo on the Navigation Pane

You Tube video demo on the Quick Access Toolbar

You Tube video demo on how to anchor textboxes and allow stretch to screen size

Reblog this post [with Zemanta]