Lynda.COM Access 2010 Power Shortcuts

Author:
Alicia Katz Pollock

Duration:
03h 43m

Released on:
2/8/2011

Exercise files:
Yes

Software works on:
Windows only


In Access 2010 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 2010. 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



Introduction
Welcome           00m 47s
Using the exercise files           00m 28s

1. Top Tips
Customizing the Navigation pane           02m 23s
Toggling between Design and Data views           02m 40s
Creating new fields with field templates           02m 09s
Understanding the "Cannot contain a Null value" error           01m 29s
Working with AutoNumbers as foreign keys           02m 24s
Using input masks           02m 39s
Four ways to add fields to a query           01m 41s
Four ways to filter data           02m 56s
Selecting multiple form and report controls           02m 13s
Aligning and distributing controls on forms and reports           05m 15s

2. File Management
Opening recent files           02m 33s
Opening your most recently used file automatically           00m 56s
Selecting a startup form           01m 00s
Changing the default saving location           01m 19s

3. Ribbon and Quick Access Toolbar Tips
Expanding and collapsing the Ribbon           01m 13s
Three ways to customize the Quick Access toolbar           03m 14s
Selecting Ribbon buttons using KeyTips           01m 47s
Creating your own ribbons           02m 08s

4. Interface Shortcuts
Turning the Navigation pane into a switchboard           03m 48s
Right-clicking           02m 48s
Using keyboard shortcuts           02m 50s

5. Navigation Shortcuts
Navigating between records           02m 08s
Using Search, Go to, and Find           02m 20s
Selecting fields, rows, columns, and tables           01m 28s

6. Data Entry and Editing Shortcuts
Undo and Redo tips           02m 18s
Entering data across, not down           00m 59s
Repeating data from the record above           01m 39s
Copying and pasting content           02m 44s
Inserting today's date           01m 10s
Removing automatic hyperlinks           01m 54s
Using AutoCorrect           01m 36s
Using concatenated fields           02m 16s
Linking Outlook contacts           02m 23s
Saving imports and exports for reuse           04m 47s

7. Table Techniques
Creating a table using application parts           02m 18s
Creating Quick Start fields           01m 49s
Saving application parts           02m 43s
Understanding number field sizes           03m 02s
Setting default field types           02m 55s
Using validation rules           04m 00s
Using flag fields           02m 01s
Using an index           02m 04s
Using a datasheet Totals row           02m 00s
Filtering by selection           01m 26s
Resizing columns and rows           02m 07s
Removing gridlines and shading from tables           01m 29s
Hiding and unhiding table fields           01m 13s
Freezing fields when scrolling           00m 59s
Analyzing your table for redundant structure           05m 50s

8. Relationship Techniques
Setting a starting AutoNumber           03m 14s
Creating a multi-field primary key           04m 17s
Using subdatasheets           01m 27s
Using relationship reports           01m 55s

9. Query Techniques
Using wildcards           05m 40s
Using IN instead of OR           01m 29s
Hiding query fields           00m 54s
Changing captions           01m 31s
Finding duplicate records           02m 13s
Moving records with append and delete queries           04m 31s
Using make-table queries           02m 12s
Creating an update query           02m 55s
Turning a query into a PivotTable           02m 30s
Turning a query into a PivotChart           02m 06s
Using SQL statements           02m 31s

10. Form Techniques
Using the property sheet to work with controls           02m 16s
Creating option groups           02m 43s
Using a ComboBox to select a record           02m 55s
Creating tabbed form layouts           04m 45s
Inserting charts           03m 42s
Creating your own smart tags           01m 24s
Using the CanGrow and CanShrink properties           01m 46s
Hiding fields in printouts           01m 26s
Setting tab stops           03m 41s
Clipping, stretching, and zooming images           01m 17s
Viewing single or continuous forms           01m 01s
Changing a form's default view           01m 52s

11. Report Techniques
Inserting page breaks in reports and forms           02m 15s
Creating headers and footers           05m 49s
Hiding duplicates in reports           01m 03s

12. Formatting Shortcuts
Using themes to customize the look of the database           04m 12s
Using the Format Painter           02m 25s
Grouping controls on forms and reports           01m 35s
Setting default appearance for new databases           02m 05s

13. Macro and Event Techniques
Using a Before Change macro to create a time stamp           06m 51s
Triggering a Before Delete warning message           02m 49s
Creating an After Update macro to email a customer           02m 11s
Creating a user interface macro           04m 12s
Using AutoExec macros           01m 53s

14. Database Management Techniques
Saving templates           02m 10s
Locking files           00m 43s

Conclusion
Goodbye           00m 44s