Access 2007: Shortcuts

In Access 2007 Power Shortcuts, Access expert Alicia Katz Pollock shares hundreds of tips and shortcuts to vastly increase efficiency and get the full power out of Access 2007. The course includes tips for working with the Ribbon and Quick Access toolbar, managing files, customizing and automating Access, rapid data entry and editing, working with tables, queries, forms, and reports, managing your database, and much more. Exercise files accompany the course.

Topics include:
Creating new field with field templatesUnderstanding errorsFiltering dataAligning and distributing controlsCustomizing the interfaceNavigating quickly between recordsSpeeding up data entryAnalyzing a table for redundant dataCreating a multi-field primary keyMoving records with append and delete queriesTransforming a query into a PivotTable or PivotChartWorking with images, charts, and Smart Tags in formsHiding duplicates in reportsFormatting shortcutsUsing macros