Access 2010 transition from Access 2003

Learning Outcomes:

• Design a form layout and create a form.

• Differentiate between the appropriate application of the report design feature and the application of the Report Wizard.

• Compare and contrast ribbon tabs and contextual tabs.

During this Instructor led half-day course, the student will explore the new and enhanced features of Access 2010.

• Explore the Access User Interface

• Building Tables and Forms

• Creating Queries and Reports

• Working with External Data

• Building a database for the Web

Access 2010 transition from Access 2003

Explore the new user interface and work with the Ribbon and Contextual Tabs. Customize the Access environment for your use. Create a table; look at the field insertion feature and the multi-value fields. Create a form and design a form layout. Work with Macros. Query a database, generate reports and format a report. Explore the changes in the import data and export data features. Create Tables and Forms, Queries and Reports in a Web Database. Prepare to Publish a database to Access Services.

Class targeted to: This course is designed for the experienced Access users who have worked with earlier versions of Access and will be or have recently been upgraded.

Prerequisites: An understanding of Access preferably in Access 2002 or 2003 and some familiarity with the Internet. There are other more advanced new features that are not covered in depth in this half day class.