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.
Target Audience
Anyone wishing to become familiar with Microsoft Access 2007 at an advanced level; anyone seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; anyone seeking to obtain Microsoft Application Professional certification.
Prerequisites
The Skillsoft Microsoft Office 2007: Beginning Access learning path; Microsoft Office 2007: Advanced Access learning path; familiarity with a Windows user environment
Lesson Objectives
Introducing SharePoint and Access 2007
- determine how to move data to a SharePoint site
- specify how to publish data to a SharePoint site
Working with Access 2007 and SharePoint Lists
- create an Access view of a SharePoint list
- work with SharePoint lists
Working Offline and Tracking Access 2007 Data
- take SharePoint list data offline
- work offline and track data in Access 2007
Using SharePoint with Access 2007
Use Macros in Access 2007
- create and edit Access 2007 macros
- run Access 2007 macros
VBA in Access 2007
- use VBA to create an event handler in Access 2007
- work with event handlers in Access 2007
Creating Macros and Handling Events in Access 2007
|
Key Concepts:
|
|
Desktop Certifications, Microsoft, Microsoft Certified Application Specialist Certification, 77-605 Using Microsoft Office Access 2007, Desktop Curricula, Microsoft Office 2007, Microsoft Office 2007: Access for the Power User
|
|
|
Course Appears in these Categories:
|
• Desktop Certifications >> Microsoft >> Microsoft Certified Application Specialist Certification
• Desktop Skills >> Microsoft Office 2007 >> Microsoft Access 2007: Power User
• Continuing Professional Education >> National Association of State Boards of Accountancy (NASBA)
|
|
|
Courses you might be interested in:
|
• Programmability and Administration in Access 2007
• Database Administration in Access 2007
• Importing and Exporting Data and Data Presentation in Access 2007
• Advanced Data Management in Access 2007
• Advanced Formatting in Excel 2007
• Advanced Data Management in Excel 2007
• Advanced Customization in Excel 2007
• Customizing Outlook 2007 and Using the Journal
• Configuring Rules, Alerts, and Junk E-mail Settings in Outlook 2007
• Working with SharePoint, Calendars, and Forms in Outlook 2007
• Creating Custom Slide Shows in PowerPoint 2007
|