Upgrading to Microsoft Office Access 2010 Complete

Request more details:

Description:
Access 2010 is Microsoft’s popular and powerful database application. This new version of Access incorporates a variety of streamlining tools to help users better store and sort their data. This Upgrading course is intended to help experienced users of Access 2007 and earlier get up to speed with new features and functionality. This manual will also help users of Access 2003 and earlier who have little to no experience with Access 2007 and the ribbon interface. Highlights of the course include a complete overview of the ribbon interface, an introduction to new macro features, information on new formatting and data management tools, how to get started with SharePoint server, information on navigation forms, and details on how to use Web databases.
Prerequisites:
This course is designed for experienced users who have worked with earlier versions of Access, and who have, or about to upgrade to Microsoft Office Access 2010. This course covers the commonly used new features for a typical user.
Starting Out:
What is Microsoft Office Access 2010?
What’s New in Microsoft Office Access 2010?
Basic Database Terminology
Opening Access
Closing Access
Interface Basics:
Understanding Backstage View
Using Backstage View
Interface Overview
Using Standard Tabs
Using Contextual Tabs
Minimizing the Ribbon
Using the Quick Access Toolbar:
The Default QAT Commands
Adding Commands
Removing Commands
Customizing the Toolbar
Importing and Exporting Customizations
Resetting the Quick Access Toolbar
Customizing the Ribbon:
Getting Started
Adding or Removing Tabs
Arranging Tabs and Groups
Creating New Tabs and Groups
Customizing Group Commands
Importing and Exporting Customizations
Resetting All Customizations
First Steps:
Database Basics
Planning a Database
Creating a Blank Database
Creating a Database from a Template
Warnings You May See when Opening a Database
Navigating in Access:
Understanding the Navigation Pane
Managing Database Objects
Setting Navigation Options
Exporting an Object to PDF or XPS
Customizing Tables:
Using Pre-Designed Fields
About Application Parts
Adding Application Parts to a Database
Using the Attachment Data Type
Using Themes:
Applying Themes
Modifying Theme Fonts
Modifying Theme Colors
Saving Customized Themes
Browsing for Themes
Using Conditional Formatting with Reports:
Understanding Conditional Formatting
Creating Conditional Formatting Rules
Editing Conditional Formatting Rules
Changing the Order of Conditional Formatting Rules
Deleting Conditional Formatting Rules
Creating a Navigation Form:
Creating a Navigation Form
Adding Tabs to a Navigation Form
Creating a Tab Hierarchy
Modifying a Navigation Form
Displaying the Navigation Form When the Database Opens
Understanding SharePoint Server:
Understanding SharePoint Server
System Requirements
Important Terminology
Understanding SharePoint Users
Using Access 2010 with SharePoint Server:
Linking Tables and Lists
Moving a Database to SharePoint
Saving a Database to SharePoint
Access 2010 and Web Databases:
Creating a Web Database
Creating Tables and Fields in Web Databases
Creating Forms for Web Databases
Creating Navigation Forms for Web Databases
Using Web Database Templates
Checking Compatibility
Publishing a Web Database
Macro Basics:
Understanding Macros
Creating Macros
Macros as Event Procedures
Program Control with If-Then-Else Statements
More about Macros:
About Embedded Macros
Adding Comments to Macros
Creating a Submacro
Grouping Submacros
Handling Macro Errors
Using Table (Data) Macros:
Understanding Table Macros
Creating a Table Macro
Managing Table Macros
Advanced Macro Topics:
Exporting a Macro to XML
Converting a Macro to Visual Basic
Creating an E-Mail Alert