lynda.com » lynda.com library » Microsoft » Access 2007 Power Shortcuts

Access 2007 Power Shortcuts

with Alicia Katz Pollock

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

show more show less

author: Alicia Katz Pollock
subject: Business, Productivity
software: Access 2007, Office 2007
level: Intermediate

duration: 3h 25m
released: Feb 08, 2011

Share this course

Learn more about lynda.com

Ready to join? get started

Members who watched this also viewed

Access 2007 Essential Training

Access 2010 Essential Training

Excel 2010 Essential Training

Photoshop CS6 Essential Training

PHP with MySQL Essential Training (2007)

Dreamweaver CS5 Essential Training

WordPress Essential Training

Up and Running with VBA in Access

Excel 2007 Essential Training

Illustrator CS5 Essential Training

expand all | collapse all

viewed duration

Introduction 1m 11s

Welcome 46s

Using the exercise files 25s

1. Top Tips 24m 31s

Customizing the Navigation pane 2m 38s

Creating new fields with field templates 1m 18s

Toggling between Design and Data views 2m 30s

Understanding the "Cannot contain a Null value" error 1m 28s

Working with AutoNumbers as foreign keys 2m 28s

Using input masks 2m 30s

Four ways to add fields to a query 1m 37s

Four ways to filter data 2m 57s

Selecting multiple form and report controls 2m 32s

Aligning and distributing controls on forms and reports 4m 33s

2. File Management 4m 40s

Opening recent files 1m 49s

Opening your most recently used file automatically 49s

Selecting a startup form 54s

Changing the default saving location 1m 8s

3. Ribbon and Quick Access Toolbar Tips 4m 48s

Expanding and collapsing the Ribbon 49s

Three ways to customize the Quick Access toolbar 2m 46s

Selecting Ribbon buttons using KeyTips 1m 13s

4. Interface Shortcuts 8m 44s

Turning the Navigation pane into a switchboard 3m 22s

Right-clicking 2m 32s

Using keyboard shortcuts 2m 50s

5. Navigation Shortcuts 5m 36s

Navigating between records 1m 54s

Using Search, Go to, and Find 2m 19s

Selecting fields, rows, columns, and tables 1m 23s

6. Data Entry and Editing Shortcuts 27m 15s

Undo and Redo tips 2m 26s

Entering data across, not down 1m 6s

Repeating data from the record above 1m 54s

Inserting today's date 1m 15s

Removing automatic hyperlinks 1m 53s

Using AutoCorrect 1m 45s

Using concatenated fields 8m 56s

Linking Outlook contacts 2m 38s

Saving imports and exports for reuse 5m 22s

7. Table Techniques 29m 39s

Creating a table using table templates 1m 19s

Setting data types 2m 15s

Understanding number field sizes 3m 43s

Setting default field types 2m 30s

Using validation rules 2m 1s

Using flag fields 2m 6s

Using an index 1m 58s

Using a datasheet Totals row 1m 47s

Filtering by selection 1m 22s

Resizing columns and rows 1m 50s

Removing gridlines and shading from tables 1m 27s

Hiding and unhiding table fields 1m 16s

Freezing fields when scrolling 51s

Analyzing your table for redundant structure 5m 14s

8. Relationship Techniques 10m 29s

Setting a starting AutoNumber 3m 7s

Creating a multi-field primary key 3m 59s

Using subdatasheets 1m 31s

Using relationship reports 1m 52s

9. Query Techniques 28m 37s

Using wildcards 5m 33s

Using IN instead of OR 1m 34s

Hiding query fields 50s

Changing captions 1m 42s

Finding duplicate records 2m 17s

Moving records with append and delete queries 4m 32s

Using make-table queries 2m 23s

Creating an update query 2m 49s

Turning a query into a PivotTable 2m 22s

Turning a query into a PivotChart 2m 8s

Using SQL statements 2m 27s

10. Form Techniques 29m 53s

Using the property sheet to work with controls 2m 21s

Creating option groups 2m 36s

Using a ComboBox to select a record 2m 45s

Creating tabbed form layouts 4m 41s

Inserting charts 3m 39s

Creating your own smart tags 1m 25s

Using the CanGrow and CanShrink properties 1m 48s

Hiding fields in printouts 1m 32s

Setting tab stops 4m 46s

Clipping, stretching, and zooming images 1m 16s

Viewing single or continuous forms 58s

Changing a form's default view 2m 6s

11. Report Techniques 7m 54s

Inserting page breaks in reports and forms 2m 13s

Creating headers and footers 4m 50s

Hiding duplicates in reports 51s

12. Formatting Shortcuts 4m 29s

Using the Format Painter 2m 17s

Setting default appearance for new databases 2m 12s

13. Macro and Event Techniques 14m 11s

Using a Before Change macro to create a time stamp 4m 49s

Triggering a Before Delete warning message 2m 55s

Creating a user interface macro 4m 40s

Using AutoExec macros 1m 47s

14. Database Management Techniques 3m 9s

Exporting to PDF 1m 50s

Compacting and repairing a database 41s

Locking files 38s

Conclusion 42s

Goodbye 42s

Suggested courses to watch next:

Access 2007: Queries in Depth (2h 8m)
Adam Wilbert

Access 2010 New Features (36m 35s)
Alicia Katz Pollock

Access 2010 Essential Training (3h 30m)
Alicia Katz Pollock

Access 2010 Power Shortcuts (3h 43m)
Alicia Katz Pollock

You must be a lynda.com member to watch this video.

Every course in the lynda.com library contains free videos that let you assess the quality of our tutorials before you subscribe—just click on the blue links to watch them. Become a member to access all 104,069 instructional videos.

get started

learn more

If you are already an active lynda.com member, please log in to access the lynda.com library.

Get access to all lynda.com videos

You are currently signed into your admin account, which doesn't let you view lynda.com videos. For full access to the lynda.com library, log in through iplogin.lynda.com, or sign in through your organization's portal. You may also request a user account by calling 1 1 (888) 335-9632 or emailing us at cs@lynda.com.

Get access to all lynda.com videos

How to access this video.

If this course is one of your five classes, then your class currently isn't in session.

If you want to watch this video and it is not part of your class, upgrade your membership for unlimited access to the full library of 2,024 courses anytime, anywhere.

learn more upgrade

You can always watch the free content included in every course.

Questions? Call Customer Service at 1 1 (888) 335-9632 or email cs@lynda.com.

Access 2007 Power Shortcuts

with Alicia Katz Pollock

Share this course

table of contents

exercise files

transcript

author

preferences

FAQs

Suggested courses to watch next:

Bookmark this Tutorial

Name

Description

Tags

bookmark this course

Create new playlist

You must be a lynda.com member to watch this video.

Get access to all lynda.com videos

Get access to all lynda.com videos

Access to lynda.com videos

How to access this video.

You don't have access to this video.

Need help accessing this video?

Try our new course pages

name:
description:
	save cancel