Course Description | Course Objectives | Pre-requisites | Course Duration | Course Outline

Microsoft Access


Course Description

This class is intended for individuals who deal with large amounts of data. MS Access will allow students to manage this data and provide sorts, queries and reports to manage various aspects of the business.

The focus of this class is to explore and exercise the purpose and functions within a database and use the data to maximize business operations. Learn how to create a database, input information using several methods and generate queries.

Go to Top   


Course Objectives
  • View and locate records
  • Add, edit and delete records.
  • Create a new database using most field types.
  • Create and execute searches on single and multiple databases.
  • Calculate within database reports.
  • Design and modify forms and reports.
  • Print reports.
  • Create mailing labels.
  • Work with multiple databases.
  • More..

Go to Top   


Pre-requisites

Ms Windows

Go to Top   


Course Duration

Recommended Hour - 8 Hours

Go to Top   


Course Outline
  • Getting started
  • Creating Tables
  • Datasheet Records
  • Table Relationships
  • Sorting and Filtering
  • Queries
  • Forms & Form Controls
  • Subforms
  • More Forms
  • Reports
  • Importing, Exporting, Linking
  • More..

Please note that the course outline does not exhaust here, for a more detail course outline, email us at info@i-edu.com.sg.

Go to Top