Microsoft Access 2003: Introduction for Beginners (1 day)

Course Overview

Microsoft Access 2003 is the Office 2003 relational database management program and an ideal development environment for database applications. A business requires its people to be capable of driving the design and improvement of their databases. This course is designed to fulfil this need. It also covers material necessary for completion of the relevant European Computer Driving Licence (ECDL) exams.

Microsoft is an increasing popular career choice. This Microsoft training course will help accelerate your job prospects.

Related Courses

• Microsoft Access 2003: Advanced (1 day)
• Microsoft Access 2003: Intermediate (2 day)
• Microsoft Access 2003: Introduction for Beginners (2 day)
• Microsoft Access 2003: Advanced (2 day)
• Microsoft Access 2003: Visual Basic Applications (VBA)
• Microsoft Access 2003: Visual Basic Applications (VBA)
• Microsoft Access 2003: Intermediate (1 day)
• Microsoft Access 2002 2003: Advanced Development in Microsoft Access
• Microsoft Access 2003: Programming with VBA

Audience

The course is aimed at those who will be designing, supporting, amending or creating databases. Delegates will learn how to use the more advanced and powerful features of Access 2003 in order to be more efficient in data management, including complex forms, reports with charts and action queries for bulk data processing.

Skills Gained

Delegates will be able to create a database and manage data more effectively. They will be able to create complex forms and reports, use action queries to process data and set query properties to maximise their use of queries. Delegates will also be shown the basic concepts of relational database theory.

This course will enable delegates to:

• Design a relational database.
• Create tables and relationships.
• Set field properties.
• Create advanced queries and action queries.
• Create complex forms displaying data from multiple tables.
• Produce advanced reports.

Prerequisites

This course requires that you have a good working knowledge of Microsoft Windows and should also be able to use a mouse and keyboard.

Course Outline

• Getting started.
• Databases and tables.
• Fields and records.
• Data entry rules.
• Simple queries.
• Using forms.
• Creating reports.
• Relational databases.
• Working with related tables.