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

Check out more MS Access courses in Australia

Corporate Training Solutions Australia Logo

Visio Essentials

Microsoft Visio is a diagramming program that uses vector graphics to create diagrams which can display complex information at a glance. Visio is much more than a drawing package.

by Corporate Training Solutions Australia [Claim Listing ]
The Career Academy Logo

Certificate in Microsoft Excel

Gain knowledge and understanding of how to use the essentials of Excel. This practical course will set you up to use Excel with ease. You will gain a Certificate in Microsoft Excel, which you can share with prospective employers.

by The Career Academy [Claim Listing ]
The Pivot Institute Logo

Microsoft Word Essentials Training

This hands-on course aims to give the learner a sound grounding in the use of Microsoft Word to create everyday documents required either at work or at home. Particular emphasis is placed on developing accurate and well designed documents.

by The Pivot Institute [Claim Listing ]
Sydney Community College Logo

Microsoft Word Course (Level 1)

On this Microsoft Word course in Sydney, you will learn to produce and share professional documents, confidently layout publications, tables, pictures and other graphics, or create indexes and mail merges.

by Sydney Community College [Claim Listing ]
Applied Education Sydney Training & Assessment Centre Logo

Microsoft Excel 2016 Intermediate

The skills and knowledge acquired in Microsoft Excel 2016 Intermediate - Level 2 (with Challenge Exercises) enable users to expand their knowledge and learn how to create more productive workbooks.

by Applied Education Sydney Training & Assessment Centre [Claim Listing ]

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