Wednesday, November 24, 2010

Microsoft Office mac2011

Finally here! And finally closer related to the Windows version. I can now offer training on either or without much of a fuss. Still not as seamless between the platforms as the Adobe products, but this new version is a huge step in the right direction.

If you're wondering, UNL's Microsoft license allows for UNL office to upgrade the Mac as well as the Windows versions for free. If your department is still using Mac Office 2008, it is worth your time to upgrade.

Monday, November 1, 2010

Access 2007: Print Access report summaries without redesigning the report

Your supervisor or director would like a printout of the summary data in all of the reports in your database for her end-of-fiscal year department report. You need to print out all 10 reports without the detail data, and you need to have it ready within the hour. Fortunately, you don't need to create new reports -- you can hide the detail section so the detailed data does not appear in the printout. Here's how...
  1. In the Database window, click Reports under Objects.
  2. Click the name of the report, and then click the Design button.
  3. Right-click within a blank area of the Detail section.
  4. Select Properties.
  5. Under the Format tab, click in the Visible property box and select No.
When you print the reports, all sections but the detail sections will print. You can use the Visible property to hide any section of the report.