Microsoft Access Training Course 2003 Advanced

Overview and objectives of the Microsoft Access Training Course

This Microsoft Access Training course will help you to customise and manage  database applications using Microsoft Access.

You will learn to implement macros and command bars, link to external data sources and update data using action queries. You  will also learn  to use the User Level Security Wizard to secure the application.

Who is this Microsoft Access Training Course for?

If you want to be able to customise simple Access databases and add automation, this course is for you.

Microsoft Access Training Course prerequisites

Delegates should have ideally attended the Microsoft Access Introduction and Intermediate Training Courses.

Microsoft Excel Training Course Contents

Using a Subform or Subreport

Use the Form /Report Wizard to create a form or report based on multiple tables, U se the Subform control and synchronise forms, Modify the layout of a Subform, Use the Subreport control.

Creating Chart Reports

Create a chart report, Insert a chart control, Modify a chart control.

Creating PivotTable Reports

Create and use a PivotTable or PivotChart.

Linking to an External Data Table

Create a link to data stored in a spreadsheet, Create a link to a table in another Access database, Split a database into a front-end and back-end, Manage linked tables

Managing Shared Access

Understand the issues involved in sharing a database, S et record locking on shared objects, Secure an Access database with user level security, Configure user and group accounts, Configure account permissions, Transfer ownership of database objects

Designing a Macro

Understand w hat a macro is and how it works, Create a new macro • R un a macro, Add a macro to an event handler

Designing an Application

Create and delete toolbars and menu bars, Add and delete toolbar buttons and menu item s, Create a switchboard form, Customise start-up settings, Add help screen to an application