Access New Features

Objective

Learn about the new features and enhancements in Access.

Prerequisites

Delegates must be familiar with previous versions of Access.

Workshop Length

90 minutes

Training formats

Scheduled course · Private course · tailored · 1 to 1 (all instructor led)

Manuals

A quick reference guide provides support throughout the course and upon your return to the office.

Calendar

Click here to see the Office 2010 Migration courses calendar

 

Download pdf

Course Description

In addition to the new user interface, Access 2010 offers several new features that make creating a new database and its objects easier, even for people with little knowledge of database design. This course is designed to help you get the most out of these new features.

Workshop profile

• Understand the Access 2010 startup screen.
• Open existing databases in Access 2010.
• Understand the new file formats for Access databases.
• Convert databases between versions.
• Create a new database using a template.
• Explore a sample database.
• Work with the Office button and Ribbon in Access.
• Understand and customize the Navigation Pane.
• Change the view.
• Understand the new "Attachment" data type for tables.
• Work with multivalued fields.
• Autofilter a field.
• Format tables automatically.
• Add a totals row to a table.
• Create a table using a table template.
• Work with forms in the new Layout view.
• Create a new form without using the Form Wizard.
• Group and sort a report.
• Add totals to a report.
• Understand new security options.