Want an easy way to create new fields in Access 2007 or 2010? Gone are the days of painstakingly creating each new field, setting its data type, and then modifying the properties, especially for commonly used groups of fields like addresses. This time-saving shortcut from Alicia Katz Pollock shows how you can use field templates to do the job quickly and easily. You’ll find this tip along with lots more in Alicia’s courses on lynda.com, Access 2007 Power Shortcuts and Access 2010 Power Shortcuts.

Want to make Access 2007 or Access 2010 truly your own? This productivity shortcut from Alicia Katz Pollock shows how you can reorganize the Navigation Pane to streamline your workflow—or to create a customized navigation system for Access users who are not experts. You’ll find this tip along with lots more in Alicia’s courses on lynda.com, Access 2007 Power Shortcuts and Access 2010 Power Shortcuts.

Sure, you can use the View toggle button in the upper left corner of the ribbon to toggle between views in Access 2007 or Access 2010. But did you know there are actually half a dozen ways to make the switch, depending on where your cursor is? This time-saving shortcut from Alicia Katz Pollock shows all the ways you can toggle between the Design and Data views. You’ll find this tip along with lots more in Alicia’s courses on lynda.com, Access 2007 Power Shortcuts and Access 2010 Power Shortcuts.

Are you building a relational database with Access 2007 or Access 2010? This technique from Alicia Katz Pollock shows how to properly set up relationships between tables using AutoNumber fields and foreign keys. You’ll find this tip along with lots more in Alicia’s new courses, Access 2007 Power Shortcuts and Access 2010 Power Shortcuts.