Microsoft Office Access 2003 Advanced
|
|
MS Office |
Language Course |
ILT Classroom |
Mentored Learning |
OnLine AnyTime |
OnLive Live |
|
Access 2003 |
Portuguese /
English |
Yes |
Yes |
Yes |
Yes |
40 HRS / 5 DAYS
Lesson 1: Structuring Existing Data
• Import Data
• Analyze Tables
• Create a Junction Table
• Improve Table Structure
Lesson 2: Writing Advanced Queries
• Create Unmatched and Duplicates Queries
• Group and Summarize Records Using the Criteria Field
• Summarize Data with a Crosstab Query
• Create a PivotTable and a PivotChart
• Display a Graphical Summary on a Form
Lesson 3: Simplifying Tasks with Macros
• Create a Macro
• Attach a Macro to a Command Button
• Restrict Records Using a Where Condition
Lesson 4: Adding Interaction and Automation with Macros
• Require Data Entry with a Macro
• Display a Message Box with a Macro
• Automate Data Entry
Lesson 5: Making Forms more Effective
• Change the Display of Data Conditionally
• Display a Calendar on a Form
• Organize Information with Tab Pages
Lesson 6: Making Reports More Effective
• Cancel Printing of a Blank Report
• Include a Chart in a Report
• Arrange Data in Columns
• Create a Report Snapshot
Lesson 7: Maintaining an Access Database
• Link Tables to External Data Sources
• Back Up a Database
• Compact and Repair a Database
• Protect a Database with a Password
• Determine Object Dependency
• Document a Database
• Analyze the Performance of a Database
Lesson 8: Making Your Data Available on the Web
• Create a Data Access Page by Using the Wizard
• Improve the Presentation of the Data Access Page
• Viewing Data Access Pages with the Browser
• Edit Data Using the Data Access Page
• Group Records in the Data Access Page
Lesson 9: Developing a Data Access Page in Design View
• Create a Data Access Page in Design View
• Incorporate a ComboBox in the Data Access Page
• Test the New Record Function of the Data Access Page
• Develop a PivotTable with the Office PivotTable Tool
• Develop a PivotChart
Lesson 10: Integrating Access into Your Business
• Import XML Data into an Access Database
• Export Access Data to XML Format
• Share Data with Other Office Applications
Lesson 11: Automating a Business Process with VBA
• Create a Standard Module
• Develop Code
• Call a Procedure from a Form
• Run the Procedure
Lesson 12: Creating a Switchboard and Setting the Startup Options
• Create a Database Switchboard
• Modify a Database Switchboard
• Set the Startup Options
• Modify the Startup Options
Lesson 13: Distributing and Securing the Database
• Split a Database
• Implement Security
• Set Passwords
• Encode and Decode a Database
• Convert an Access Database to an MDE File