Microsoft Office Access 2007 Advanced
|
|
MS Office |
Language Course |
ILT Classroom |
Mentored Learning |
OnLine AnyTime |
OnLive Live |
|
Access 2007 |
Portuguese /
English |
Yes |
Yes |
Yes |
Yes |
40 HRS / 5 DAYS
Lesson 1: Structuring Existing Data
• Analyze Tables
• Create a Junction Table
• Improve Table Structure
Lesson 2: Writing Advanced Queries
• Create Subqueries
• Create Unmatched and Duplicate Queries
• Group and Summarize Records Using Criteria
• Summarize Data Using a Crosstab Query
• Create a PivotTable and a PivotChart
Lesson 3: Simplifying Tasks with Macros
• Create a Macro
• Attach a Macro
• Restrict Records Using a Condition
• Validate Data Using a Macro
• Automate Data Entry Using a Macro
Lesson 4: Making Effective Use of Forms
• Display a Calendar on a Form
• Organize Information with Tab Pages
• Display a Summary of Data in a Form
Lesson 5: Making Reports More Effective
• Include a Chart in a Report
• Print Data in Columns
• Cancel Printing of a Blank Report
• Create a Report Snapshot
Lesson 6: Maintaining an Access Database
• Link Tables to External Data Sources
• Manage a Database
• Determine Object Dependency
• Document a Database
• Analyze the Performance of a Database
Lesson 7: Integrating Access into Your Business
• Import XML Data into an Access Database
• Export Access Data to XML Format
• Export Data to the Outlook Address Book
• Collect Data Through Email Messages
Lesson 8: Automating a Business Process with VBA
• Create a Standard Module
• Develop Code
• Call a Procedure from a Form
• Run a Procedure
Lesson 9: Managing Switchboards
• Create a Database Switchboard
• Modify a Database Switchboard
• Set the Startup Options
Lesson 10: Distributing and Securing Databases
• Split a Database
• Implement Security
• Set Passwords
• Convert an Access Database to an ACCDE File
• Package a Database with a Digital Signature
Lesson 11: Sharing a Database Using a SharePoint Site
• Export a Table to a SharePoint List
• Import Data from a SharePoint List
• Publish a Database to a SharePoint Site
• Move a Database to a SharePoint Site
• Work Offline