Access 2007 Power Shortcuts

with Alicia Katz Pollock
please wait ...
Access 2007 Power Shortcuts
Video duration: 0s 3h 25m Intermediate


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 templates
  • Understanding errors
  • Filtering data
  • Aligning and distributing controls
  • Customizing the interface
  • Navigating quickly between records
  • Speeding up data entry
  • Analyzing a table for redundant data
  • Creating a multi-field primary key
  • Moving records with append and delete queries
  • Transforming a query into a PivotTable or PivotChart
  • Working with images, charts, and Smart Tags in forms
  • Hiding duplicates in reports
  • Formatting shortcuts
  • Using macros


- [Voiceover] Hi, I'm Alicia Katz Pollock, and I'd like to welcome you to Access 2007 power shortcuts. In this course I'll show you dozens of tips and tricks to deepen your Access expertise. I'll show you navigation shortcuts, from keyboard commands to hidden right-click options to speed up your database development. You'll learn how to customize the Ribbon and navigation pane, turning your database into a custom application. I'll demonstrate table techniques and special field properties to train you in database architecture. You'll learn a variety of tips for building effective forms and reports, and we'll build action queries and event macros to automate your database.

Whether you're new to Access or an experienced database designer, I'll show you hidden shortcuts and techniques to make you a pro, in Access 2007 power shortcuts.

please wait ...