Access 2007 Power Shortcuts

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

Viewers:

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
Subject:
Business
Software:
Access
Author:

Welcome

Hi, I am Alicia Katz Pollock, and I would like to welcome you to Access 2007 Power Shortcuts. In this course, I will 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 will learn how to customize the ribbon in 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 will build action queries and event macros to automate your database. Whether you're new to Access, or an experienced database designer, I will show you hidden shortcuts and techniques to make you a pro in Access 2007 Power Shortcuts.

There are currently no FAQs about Access 2007 Power Shortcuts.

please wait ...