Microsoft Office Access 2007 Upgrade - 1 day

Please contact us for one-to-one or group bookings these can also be arranged on dates to suit you and customised to your specific requirements. Please give us a call on 01483 688488.

Description:

This course introduces the new features and functionality in the latest version of Microsoft Office Access. There have been substantial changes to the user interface in this database application, and this course can help you get up-to-speed quickly.

This course covers the new features that enable you to create, populate, and analyze data in an Office Access database. In addition, you will be shown how to collaborate with others by sharing your database using Windows SharePoint Services.

Pre-requisites:

This course assumes you have a working knowledge of an existing version Microsoft Access.

Course Topics

Exploring the New Interface

• The Getting Started with Microsoft Office Access page.
• Access Fundamentals

Creating Database Solutions

• Pre-Defined Database Solutions
• How to Work with Tables and Relationships

Populating Database Solutions

• Form Design
• How to Import Data from Office Excel
• How to Import Contacts from Office Outlook
• How to Collect Updates Using Office Outlook

Analyzing Data

• Enhanced Filtering and Sorting Feature
• Report Design

Sharing Databases Using Windows SharePoint Services

• Benefits of Upsizing Databases to Windows SharePoint Services
• Publishing Versus Upsizing Databases to Windows SharePoint Services
• How to Work with SharePoint Lists Offline
• SharePoint List Management

Back to Courses