Lynda.COM Migrating from Access 2003 to Access 2010

Author:
David Rivers

Duration:
57m 29s

Released on:
8/18/2010

Exercise files:
Yes

Software works on:
Windows only


In Migrating from Access 2003 to Access 2010, author David Rivers walks through the switch to Access 2010 from Access 2003. The course covers key differences in Access 2010 and shows how to perform common Access 2003 tasks in Access 2010, such as filtering data and designing forms and reports. Exercise files accompany the course.
Topics include:

    Comparing the Access 2003 and 2010 interfaces
    Exploring the Ribbon and Backstage view
    Dealing with file compatibility issues
    Converting older databases to the 2010 format
    Creating navigation forms
    Adding field-level attachments
    Formatting rich text in memo fields
    Using keyboard shortcuts



Introduction
Welcome           01m 06s
Using the exercise files           00m 52s

1. Getting Started
Understanding the reasons to switch           02m 56s
Exploring the new Ribbon and Backstage view           07m 03s
Controlling Access 2010 with keyboard shortcuts           04m 21s
Understanding the new file formats           04m 41s

2. Using Access 2003 and Access 2010 in a Mixed Environment
Converting older databases to Access 2010           02m 42s
Changing the default file format in Access 2010           01m 45s
Best practices for managing files in a mixed environment           01m 51s

3. Performing Common Access 2003 Tasks in Access 2010
Using the File tab and customizing the Quick Access toolbar           05m 10s
Designing forms and reports in Layout view           03m 29s
Filtering data in Report view           03m 47s
Creating navigation forms           03m 42s
Adding attachments to a field           03m 45s
Formatting rich text in memo fields           05m 28s
Inserting dates and times with the date picker           04m 26s

Conclusion
Goodbye           00m 25s