×
×
×
×
×

Certificate in Access 2010 Advanced Online Short Course

$199.00
AT A GLANCE
Provider Courses for Success
Course Outcome Certificate of Completion
Study Mode Online
Duration 6-8 hours
Start Date Anytime – start today!
Cost $199.00
  • What you'll learn

     

    Learning how to master industry-standard programs like Microsoft Access 2010 is crucial to your career success, particularly within the world of business.

    So complete this Certificate in Access 2010 Advanced Online Short Course from Courses for Success to make sure you keep up with company standards and remain at the industry’s forefront. While most people will have a basic knowledge of the program, this course will give you an advanced understanding of Access 2010. You will learn the concepts of the program and be trained to utilise program tools to get the results you need.

    After purchasing this course, you will be provided with unlimited, lifetime access to its materials                                          

  • Ideal for

     

    This short course is perfect for anyone who has a basic understanding of Microsoft Access 2010, learns with a hands on approach and wants to have a more in depth understanding of this program.

    There are no formal entry requirements for this short course, however students must have basic literacy and numeracy skills and be able to access a computer and the internet.

  • Career Outcomes

     

    At the end of this course you will be awarded with a Courses for Success Certificate of Completion. You will also gain a proficient understanding of Microsoft Access 2010, allowing you to handle basic data management as well as advanced concepts.

  • Course Content

     

    Getting started

    • Use the quick start group, property sheet, table macros, report sections, conditional formatting, expression builder and logical functions.
    • Add, move, remove and format both regular and calculated controls
    • Set the primary key
    • Create a subform, Web form, split form, modal dialog, pivot chart, pivot table and mailing labels
    • Group and sort data
    • Understand, view and edit relationships
    • Understand and establish referential integrity
    • Sort and filter a query
    • Add calculated fields
    • Understand what SQL is, what SQL statements are, basic SQL syntax and the uses for SQL within Access 2010
    • Link to, import and export an Excel spreadsheet, Access database, Sharepoint list, text or XML file and other types of links, imports and exports
    • Use the database documenter, analyse table and database performance and repair and compact a database

    Advanced table tasks

    • Using the quick start group
    • Using the property sheet
    • Adding, moving, and removing controls
    • Formatting controls
    • Setting the primary key
    • Using table macros

    Advanced form tasks

    • Creating a sub Form
    • Creating a web Form
    • Creating a split form

    Advanced reporting tasks 

    • Using report sections
    • Using conditional formatting
    • Grouping and sorting Data
    • Adding calculated controls
    • Creating labels

    Understanding relationships

    • Types of relationships
    • Viewing relationships
    • Editing relationships
    • About referential integrity
    • Establishing referential integrity

    Advanced query tasks

    • Sorting and filtering a query
    • Adding calculated fields
    • Using the expression builder

    Working with SQL

    • What is SQL?
    • Basic SQL syntax

    Linking data

    • Linking to an Excel spreadsheet
    • Linking to an Access database
    • Linking to a Sharepoint List

    Importing data

    • Importing from an Excel spreadsheet
    • Importing from an Access database
    • Importing from a Sharepoint List

    Exporting data

    • Saving an object as a PDF
    • Exporting to an Excel spreadsheet
    • Exporting to a Sharepoint List

    Advanced database tools

    • Using the database documenter
    • Analysing table performance
    • Analysing database performance
    • Repairing a database
    • Compacting a database

    Wrapping up

    • “Conditional formatting now supports data bars and you can now manage your conditional formatting rules from a single intuitive view."
    • "The addition of Office themes in Access 2010 gives you the ability to coordinate numerous database objects."
    • "Build your databases with new modular components using new application parts and add prebuilt Access components for common tasks to your database."
    • "The backstage view replaces the traditional file menu in all Office 2010 applications to provide a centralised, organised space to manage your database and customise your Access experience."
    • "Expression builder simplifies your formulas and expressions with intellisense."

     

  • Payment Information

     

    Ready to get started straight away?

    Pay and enrol for this course through our quick and secure checkout system. MasterCard, Visa and PayPal accepted.

  • Why Courses for Success?

     
    Courses for Success

    Boasting one of the most extensive and diverse course lists on offer, Courses for Success have hundreds of online courses. With everything from accounting to art, wedding planning to web design, they are a great option for anyone with specific professional development needs or with a particular hobby to pursue – there really is a course to suit everyone.

    Courses for Success has developed its own online courses and utilises the latest technology to deliver them at affordable prices across ten countries. They have also partnered with some of Australia’s leading training providers to offer a range of accredited courses, with accessibility their main aim.

    As a student of Courses for Success, you’ll benefit from 24/7 access to your online course materials, enabling you to study whenever and wherever you want.

    You will also receive ongoing support from a tutor who is available to answer your questions and help keep you motivated as you may your way through the course material.

     

×