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

JMD Training Logo

Microsoft Visio Training

Your Introductory/Intermediate Visio 2013 training will enable you to create professional diagrams to simplify complex information with shapes, collaboration tools and data-linked diagrams

by JMD Training [Claim Listing ]
  • Price
  • Start Date
  • Duration
The Office Expert Logo

Microsoft Excel Training (Intro)

You have some experience with Word, however you have little or no experience with Excel. At this this level you will learn basic formatting, navigation and fulfilling basic table tasks and reformatting of existing documents.

by The Office Expert [Claim Listing ]
AIM WA Logo

Excel - Advanced

The Advanced Excel course shows you how to work with databases in Microsoft Excel using filtering, sorting and subtotals. This training course introduces participants to PivotTables, Macros and Hyperlinks and teaches logical, lookup, reference, and statistical functions.

by AIM WA [Claim Listing ]
Logitrain Logo

Microsoft Outlook (Advanced Course)

Microsoft Outlook advanced course will help you to further your skills in using Microsoft Outlook and use all its feature in a productive way to fetch concise results. 

by Logitrain
The Fourth R Logo

PowerPoint

PowerPoint Training Courses are offered by The Fourth R.

by The Fourth R [Claim Listing ]

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