Accessibility Shortcuts

Several resources are available to help increase speed and effectiveness for keyboard users. Here are keyboard shortcuts for leading Microsoft products that help save time and effort and provide an essential tool for some people with mobility impairments.

• Internet Explorer 7/6/5/4
  
• Office (2007/2003/XP/2002/2000/97)
  
• PhotoDraw
  
• PowerPoint
  
• Producer
  
• Publisher
  
• Windows (Vista/2003/XP/2000/98/ME/NT)
  
• Windows Media Player
  
• Windows Movie Maker
  
• Windows XP Media Center Edition 2005

Labels: Shortcuts

Create a sorting function

"Chris Weber develops a solution that allows users to sort the data in their forms (or subforms) that you can add to your application easily.

• The sorting interface should be generic to any form in any database.
  
  
• It should also work with subforms.
  
  
• It needs to be implemented as expediently as possible to fulfill the bid, and be easily maintained in the future.
  
  
• It should be intuitive or reminiscent of other interfaces in Access and Windows.

Labels: Forms, Macros, Tips, Tutorials, VBA

Remember it the way you want to

"Most communities in the fifties had small town print shops that doubled as printers of local news and advertising papers. These printers could not afford graphic artists so they used stock clipart supplied by large companies who distributed common graphics for use in advertising sections of the papers. They were provided for the printer in lots of categories to meet any advertiser's needs."

Labels: Graphics

"In general, a key field should have these characteristics:

Should be One Field

It is possible to define multiple fields as the key fields of a table, but a single field is preferable. ...Far better to have a CustomerID number than a combination of other fields to define a customer.

Should be Numeric

Access offers an AutoNumber field that is a Long Integer which is ideal for key fields. These values are automatically unique for each record and supports multi-user data entry as well.

Should Not Change Over Time

A key field should not change over time. Once identified, like a social security number, it should never change.

Should be Meaningless

To ensure a key field doesn’t change over time, it should have no meaning and therefore no reason to change over time.

• What Data Do You Need?
  
• What Are You Going to Do with the Data?
  
• How Is Your Data Related to Each Other?
  
• What Is Going to Happen to the Data Over Time?
  
• Learn How to Use Queries

Labels: General, Tables

Sprinkle carefully

• Display clip-related toolbars
  
• Customizing your clip art
  
• Cropping
  
• Sizing
  
• Adding text wrapping
  
• Blurring
  
• Rotating and flipping
  
• Adding a drop shadow

Labels: Graphics