Follow Us :

Microsoft Access 2003 Fundamentals

Course_Reference: 
E2-A5M1
Manufacturer: 
0
Training_Provider: 
112
Summary: 

The skills and knowledge acquired in Microsoft Access 2003 Fundamentals are sufficient to be able to use and operate the software at an efficient level.

PreRequisites: 

Microsoft Access 2003 Fundamentals assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Audience: 

Microsoft Access 2003 Fundamentals is designed for users who are keen to extend their understanding and knowledge of the software.

Objectives: 

At the completion of Microsoft Access 2003 Fundamentals you should be able to:

  • start and exit from Access and understand what a database object is
  • understand some elementary database theory.
  • design and create a new database file in Access
  • make changes to data in a table
  • format data in tables
  • sort and filter data in a table
  • use a range of data validation techniques to protect data integrity
  • preview and print a range of objects
  • create and use queries to locate and display data
  • work with forms
  • create reports in Access
  • design relational databases
  • create relational databases
  • set table relationships in a database
  • add records to a relational database

  • Access 2003 Orientation
  • Database Theory
  • Creating a New Database
  • Managing Table Data
  • Formatting Table Data
  • Sorting & Filtering Table Data
  • Data Validation
  • Printing In Access
  • Select Queries
  • Working With Forms
  • Reports
  • Database Design
  • Creating Relational Databases
  • Setting Table Relationships
  • Adding Relational Records

Description: 

The skills and knowledge acquired in Microsoft Access 2003 Fundamentals are sufficient to be able to use and operate the software at an efficient level.

Keywords: 
Introduction

Software Vendor

IT Technical

Business Skills