×
×
×
×
×

Certificate in Access 2010 Essentials 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

     

    Today’s society is data driven. Keeping data organised and easily accessible is essential in order to be competitive in today’s markets.

    This Certificate in Access 2010 Essentials Online Short Course from Courses for Success provides you with the experience and expertise to take data from your business and use it to your advantage.

    The focus of this course is Microsoft’s database software, Access 2010. Throughout the course you will gain the knowledge necessary to effectively use Access 2010 within your business setting.

  • Ideal for

     

    This online short course is tailored for anyone who is looking to improve or gain knowledge of data collection and organisation using the Access 2010 platform. This course will assist members of any business in analysing and organising data to maximise productivity.

    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

     

    By completing this course you’ll be able to  open, close, create, and present data contained within Access 2010 files. This will lead to higher productivity and give you a greater awareness of data. In doing so, you’ll be able to contribute to a data driven workplace that is focused on matching data to strengths and areas of need within your business.

    Completion of this short course will see you awarded with a Courses For Success certificate of completion.

  • Course Content

     

    Getting started with Access

    • Common database terms
    • Opening Access
    • Understanding the Access new file screen
    • Creating a blank Access database
    • Creating a blank database from a template

    Using the Access interface

    • Understanding security warnings
    • Interface overview
    • Overview of the ribbon interface
    • Working with the backstage view
    • Using the navigation pane

    Working with database objects

    • Viewing database objects
    • Exporting an object
    • Renaming an object
    • Sorting and filtering your view
    • Understanding application parts

    Creating tables

    • Understanding data types
    • Creating a blank table in datasheet view
    • Understanding lookup columns
    • Creating a blank table using design view
    • Saving your table
    • Key table tools

    Working with tables

    • Adding information to a table
    • Editing records
    • Deleting records
    • Searching for records

    Creating forms

    • Types of controls
    • Creating a form with the wizard
    • Creating a form in layout view
    • Modifying your form in design view
    • Key features on the form tools tab
    • Creating a navigation form

    Working with forms

    • Common formatting tasks
    • Using themes
    • Adding controls
    • Moving controls
    • Deleting records

    Creating reports

    • Using the report wizard
    • Using design view
    • Adding a logo
    • Working with controls
    • Key features on the report tools

    Creating queries

    • Types of queries
    • Creating a query with the wizard
    • Executing a query
    • Viewing the query
    • Key features on the query tools tab

    Managing your database

    • Using alternate file formats
    • Printing an object
    • Backing up your database
    • Emailing database objects 

    Wrapping up

    • Store your data using Access tables.
    • Use forms to easily manage data collection tasks of adding, changing or deleting data one record at a time.
    • Create queries to see subsets of your data or to perform actions to your data.
    • Use reports to view table or query data in a polished format.
  • 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.

     

×