Programmability and Administration in Access 2007

Microsoft Office Access 2007 makes it easy for you to share and manage data using the collaborative environment of a Microsoft Windows SharePoint site along with the many data management features available within Access 2007. This course explains how SharePoint sites can be used with Access and demonstrates options such as moving data to a SharePoint site, publishing data to a SharePoint site, importing from or linking to a SharePoint list, creating an Access view of a SharePoint list, working offline with SharePoint lists, as well as tracking data versioning in SharePoint. Another feature of Access 2007 is its programmability. Using Access macros and Visual Basic for Applications (VBA) code you can easily add functionality to a database to suit your business needs. In addition to SharePoint integration, this course provides an introduction to programming in Access and explores when to use macros or VBA code to automate processes. It also demonstrates how to create, launch, and modify macros and explains the use of the Visual Basic Editor to create event handlers and set control property values.

Learning Objectives

• Determine how to move data to a SharePoint site
• Specify how to publish data to a SharePoint site
• Create an Access view of a SharePoint list
• Work with SharePoint lists
• Take SharePoint list data offline
• Work offline and track data in Access 2007
• Move data to SharePoint using the Move to Sharepoint Site wizard
• Publish a database to a Sharepoint site |w
• Import a SharePoint list to Access 2007
• View different versions of a SharePoint list item
• Create and edit Access 2007 macros
• Run Access 2007 macros
• Use VBA to create an event handler in Access 2007
• Work with event handlers in Access 2007
• Create an Access 2007 macro
• Run an Access 2007 macro
• Edit an Access 2007 macro
• Create an event handler in Access 2007