Find your new direction

  • 1300 76 2221
  • Australian owned and operated since 2008

Microsoft Office – Access 2010

$199.00

Course Outline and Topics

Course Overview

Microsoft Office – Access 2010 is an online professional development course that will introduce you to database design and development concepts (including queries, forms and reports) using existing data.

In this online Microsoft Access course, you will learn the fundamentals of creating core objects of a database, data manipulation and extraction at an introductory level.

Throughout the course you will learn how to design databases to meet organisational and task requirements. You will also learn how to test and finalise databases and analyse the effectiveness of data relationships.

This course is ideal for those employed in a range of work environments who create databases to store and retrieve data using Microsoft Access 2010.

Course Structure

Unit 1 - Design Databases Using Access 2010

  • Design database
  • Scope and functionality
  • Normalisation
  • Data types
  • Develop database
  • Relational databases
  • Creating a database
  • Database tables
  • Creating tables
  • Design view
  • Data types
  • Input mask
  • Database tools tab
  • Compact and repair database
  • Primary key
  • Foreign keys
  • Query design
  • Develop forms and reports
  • Auto forms
  • Manually created forms
  • Sub-forms
  • Search forms
  • Macros
  • Design view
  • Test and finalise database

Unit 2 - Operate database applications Using Access 2010

  • Create database
  • Basic design principles
  • Saving databases
  • Database types
  • Access data types
  • Modify tables
  • Fields
  • Creating primary keys
  • Establish index
  • Table relationships
  • Customise basic settings
  • Adjusting page layouts
  • Toolbars
  • Format painter
  • Text formatting
  • Create tab
  • External Data tab
  • Database Tools tab
  • Create reports
  • Report Wizards
  • Create forms
  • Form Wizard
  • Rearrange objects
  • Retrieve information
  • Filter records

Assessment

Written assignments and exercises, including short-answer questions, reports/essays and projects. There are no examinations or due dates for assessment.
 

Payment Information

Certificate Course

,

Benefits

  • Recognised by employers as professional development;
  • Improve your employment opportunities;
  • Study online, anywhere via our elearning system;
  • Access to high-quality courses written by industry experts;
  • All course materials provided online – no textbooks to buy;
  • Unlimited tutor support;
  • Easy to understand course content;
  • Unlimited enrolment with no expiry;
  • Certificate of Attainment issued for your CV (hard copy provided); and
  • Course may be tax deductible; see your tax advisor.
SKU: C500117 Category:
ENROL TODAY
  • Includes unlimited access
  • Full up-front payment only
  •  

$199.00