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

Forrest Computer Training Logo

Microsoft Outlook Training

This course is aimed at those new to Outlook and self-taught users wanting to enhance their knowledge.

by Forrest Computer Training [Claim Listing ]
Easy PC Traning Logo

Microsoft Excel Analysing Data

 Those who want to effectively analyse their data and create professional reports in Excel.

by Easy PC Traning [Claim Listing ]
Nicole Accounting Logo

Excel Practical Elite Class

The biggest feature of this class is that our students can confidently handle interviews with agencies and employers, and help students quickly find and adapt to a large number of practical applications of Excel in accounting work

by Nicole Accounting [Claim Listing ]
T7 Training Logo

Microsoft Excel

Microsoft Excel course is offered by T7 Training for all skill level. Courses can be personalised to perfectly suit the requirements of your staff and organisation, as well as the course books for the training session.

by T7 Training [Claim Listing ]
Prog360 Logo

Excel Data Analysis

Excel Data Analysis Training focuses on the advance features of working with spreadsheets, using advance tabular functions, pivot analysis and dealing with Macros.

by Prog360

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