Microsoft Access 2003: Introduction for Beginners (1 day)

About this class

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.

This training may be available onsite; please contact us if you are interested.

Who will the lesson benefit?

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.

What delegates will learn

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.

Examination details

This course will prepare you for the following exams and certification tracks shown. Please note that the exam may not be included in the price shown: please contact us to check.

Microsoft® Certification Tracks  »
    Microsoft® Exams  »
       Exam access2003: MOS: Access 2003
       Elective (MOS - Master 2003)  »
          MOS: Access 2003
          MOS: Access 2003
          MOS- Access 2003  »
             Exam access2003: MOS: Access 2003

What prerequisites are required

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

Contents of this class

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

Optional follow-on classes

• Microsoft Access 2003 Specialised [A5M2]