MS Access (2010 Advanced)

by InterSkill Australia Claim Listing

For experienced Access 2010 users who are ready to use the more advanced features of Access 2010.

$500

Contact the Institutes

Fill this form

Advertisement

InterSkill Australia Logo

img Duration

1 Day

Course Details

Course Description:

After completing this 1-day Access 2010 Advanced training course, students will know how to:

  • Use SQL statements in Access
  • Create aliases for fields
  • Write SQL statements to create queries
  • Attach SQL statements to command buttons
  • Create crosstab queries to summarize grouped data
  • Create parameter queries to view results based on specified criteria
  • Create action queries to add, delete, and modify data in tables and to make new tables
  • Create and run macros to automate tasks
  • Attach macros to the events of database objects
  • Create data validation and data entry macros
  • Create macros that run parameter queries
  • Create AutoKeys and AutoExec macros
  • Create macros to import and export database objects
  • Import Access objects from another Access database, from Excel, and from a CSV file
  • Export objects from one database to another
  • Export and import XML documents
  • Save objects as XPS files
  • Link Access objects between databases and to Excel workbooks
  • Create hyperlink fields
  • Save databases in file formats for previous versions of Access
  • Use the Performance Analyzer
  • Split, compact, repair, and back up databases
  • Encrypt and password-protect database files
  • Configure Access Options
  • Populate database file properties
  • Perth Branch

    32/145 Stirling Hwy, Perth

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy