Microsoft Access 2007/2010
Intermediate

Course Overview

In this course, you will be introduced to some of the more advanced features of Access including advanced form controls such as command buttons, option groups, tabs and subforms. You will also create multi-table forms. You will create calculated fields including conditional IFF statement in queries, create summary queries and use action queries 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.

Register

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 2010/2007

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.