Lynda.com Access 2010 New Features

Author: Alicia Katz Pollock
Duration (hr:min): 00:36
Released on: 5/12/2010
Exercise files: Yes
Software works on: Windows only

In Access 2010 New Features, author Alicia Katz Pollock explains each new and enhanced feature in Microsoft Access 2010. This course covers the Backstage view that replaces the File menu in Office 2010, shortcuts for building tables, new layout tools and navigation controls, the macro designer featuring IntelliSense, as well as exporting to and collaborating in SharePoint. Exercise files accompany the course.

Topics include:

• Working with Application Parts
• Implementing the Table Tools ribbon
• Using Quick Start and calculated fields
• Designing with Layout View formatting tools
• Taking advantage of enhancements to the Conditional Formatting feature
• Automating with macros
• Working with external data
• Integrating SharePoint publishing

Content:

Introduction - 03:22

    Welcome - 0:52 - 4.1 MB
    Using the exercise files - 0:31 - 0.5 MB
    Comparing Access 2007 and Access 2010 - 1:59 - 6.8 MB

1. The New Interface - 07:52

    Exploring Backstage view - 2:00 - 2.9 MB
    Enabling Trusted Documents - 1:08 - 1.2 MB
    Using the improved ribbons - 2:24 - 2.7 MB
    Working with Application Parts - 2:20 - 3.1 MB

2. The New Table Features - 07:41

    Improving structure with the table tools - 4:21 - 4.9 MB
    Using QuickStart fields - 1:55 - 2.2 MB
    Creating calculated fields - 1:25 - 1.4 MB

3. The New Form and Report Features - 07:09

    Exploring Layout view - 2:38 - 2.9 MB
    Understanding navigation forms - 2:00 - 2.7 MB
    Using conditional formatting - 2:31 - 3.4 MB

4. Macros - 05:24

    Developing macros with Macro Designer - 2:31 - 3.2 MB
    Triggering data macros - 2:53 - 3.1 MB

5. The New Importing and Exporting Options - 03:02

    Working with external data - 3:02 - 4.5 MB

6. SharePoint Server - 01:52

    Integrating SharePoint publishing - 1:52 - 2.2 MB

Conclusion - 00:13

    Goodbye - 0:13 - 0.2 MB