OUR VISION

To be the premier Information and Communications Technology (ICT) training and consulting services provider in the caribbean.

OUR MISSION

To improve the quality of knowledge and skills base of ICT professionals within the caribbean through the provision of competitive world-class ICT training and consulting services on current and emerging platforms.

Microsoft Access 2003: Level 1

Duration: 3 Days

In this course, you will be introduced to the concept of the relational database and the Microsoft Office Access 2003 relational database application, and information management tools. You will also learn how to design and create a new Access database.

Target Audience
This course is designed for students who wish to learn the basic and intermediate-level operations of the Microsoft Access Database program to perform their day to day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes.

The first day addresses job responsibilities that include working with tables to create and maintain records, locate records, and produce reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications.

The second day addresses job responsibilities that include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces integrating Access data with other Microsoft applications.

Course Objectives
You will be introduced to the features of the Microsoft Office Access 2003 application. You will design and create a new Access database; improve queries, forms, and reports; and integrate Access with other applications. This course is also designed for students pursuing the Microsoft Office Specialist Certification for Access 2003, and it is a prerequisite to taking more advanced courses in Access 2003.

Course Outline

  • An Overview of Microsoft Access
  • Managing Data
  • Establishing Table Relationships
  • Querying the Database
  • Designing Forms
  • Producing Reports
  • Planning a Database
  • Building the Structure of a Database
  • Controlling Data Entry
  • Finding and Joining Data
  • Creating Flexible Queries
  • Improving Your Forms
  • Customizing Your Reports
  • Expanding the Reach of Your Data

Pre-requisites
Windows XP (New Version) - Level 1
Windows XP (New Version) - Level 2

Print this page Print this page