The Knowledge Network
1510 Central Avenue
Albany, NY 12205
Phone (518)452-2675
Fax: (518)452-2872
Office Hours:
Mon-Fri 9:00am-6:00pm
learn@knowledgenetwork.org

Microsoft^© Access - Level 3

Location: Colonie

• Creating a Switchboard and Setting the Startup Options
  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set the Startup Options
  • Modify the Startup Options
     
• Developing a Data Access Page and Including a PivotTable and PivotChart
  • Create a Data Access Page in Design View
  • Incorporate a ComboBox Control in the Data Access Page
  • View Data Access Pages with the Browser
  • Add Records to a Database Using the Data Access Page
  • Plan a PivotTable
  • Develop a PivotTable with the Office PivotTable Tool
  • Develop a PivotChart from a PivotTable
     
• Distributing and Securing the Database
  • Split a Database
  • Implement Security
  • Set Passwords
  • Encrypt and Decrypt a Database
  • Convert an Access Database to an MDE File
     
• Integrating Access into Your Business
  • Link Tables to External Data Sources
  • Import XML Data into an Access Database
  • Export Access Data to XML Format
  • Replicate an Access Database
     
• Automating a Business Process with VBA
  • Create a Standard Module
  • Create and Insert a Procedure
  • Develop Procedure Code
  • Call a Procedure from a Form
  • Run the Procedur