Microsoft Access 2003
Intermediate

Course Overview

In this course, students will be introduced to some the more advanced features of Microsoft Access, including designing effective forms with various types of controls such as command buttons, option groups, tabs and subforms. Students will also learn to create multi-table forms and Switchboard (Main Menu) forms. Various types of queries will be used to create calculated fields (and use conditional IFF statements), summarize in queries and to append tables, create tables and prompt with parameters. Students will also learn to control report design and use autoformats in reports. Time permitting, macros (in macro objects) will be created to automate tasks within an Access database.

On Request Only - Contact DPA

Course InformationRelated Training

Duration: Two-Day Course
Platform: Windows Only
Fee: Call for information

We recommend one to eight people for this course.

Course Content Download PDF (57kb)

Advanced Form Design

Advanced Queries

Advanced Report Design

Designing a Main Menu (Switchboard)

Creating Macros (Time Permitting)

Application Overview: Microsoft Access 2003

Microsoft Access is a relational database management system which combines the relational Microsoft Jet Database Engine with a graphical user interface. Access can use data stored in Access/Jet, Microsoft SQL Server, Oracle, or any ODBC-compliant data container. Microsoft Access AutoForm creates a form that displays all fields and records in the underlying table or query. If the record source you select has related tables or queries, the form will also include all the fields and records from those record sources. You can also use the wizard, which asks you detailed questions about the record sources, fields, layout, and format you want and creates a form based on your answers. In addition you can also create a basic form and customize it in Design view to suit your requirements.

Users: IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create robust databases that can be searched, sorted, analysed, reported, updated and shared with other users.