1. Australia
  2. Professional
  3. IT Training
  4. MS Office
  5. MS Access

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

InterSkill is a Western Australian company. We specialise in the delivery of live, instructor-led IT training for a wide range of software platforms, products, applications, techniques and related skills.

We offer over 50+ technical courses to help you achieve your technical and business demands. We are located in Chelsea Village at 145 Stirling Highway, Nedlands, Western Australia.

At InterSkill, we choose our instructors with a great deal of care. A key requirement for any instructor is that they have field-based experience in the areas in which they teach, together with a substantial knowledge of related issues.

Many of our instructors have spent 20 or more years working in their industry. Their valuable knowledge and experience is then made available to the participants in InterSkill’s training programmes.

View Detailed Profile

  • Perth Branch

    32/145 Stirling Hwy, Perth

Check out more MS Access courses in Australia

Keystroke Learning Logo

Microsoft Outlook Introduction

You will be given a solid foundation of skills upon which to build

by Keystroke Learning [Claim Listing ]
read more course details
Trainers Direct Logo

PowerPoint Training

We offer professional PowerPoint training for teams and individuals from beginner to advanced level. Our trainers help users to create consistent presentations taking advantage of masters and colour schemes, no more formatting woes, our techniques will help you save you time.

by Trainers Direct [Claim Listing ]
read more course details
T7 Training Logo

Microsoft Word

Microsoft Word 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 ]
read more course details
Seed Training & Seed Career Logo

Microsoft Excel 3 Levels

Offered in Beginner, Intermediate and Advanced levels. Learn how to analyse, share and manage information to make more informed decisions with the world’s premier spreadsheet application. This course uses Microsoft Excel 2013.

by Seed Training & Seed Career [Claim Listing ]
read more course details
Newcastle Computer Training Logo

Word Course

Learn the essentials of word processing to create professional, stylish documents

by Newcastle Computer Training [Claim Listing ]
read more course details
Show Me All Similar Courses

About Coursetakers.com

Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the UAE, UK, USA, India and South Africa, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.

  • Instagram
  • Facebook
  • Twitter

Courses

Quick Links

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

Ask Us?