Pagoda Training Ltd - Course Outline

Pagoda Training Ltd
Helping clients deliver effective IT training projects

Microsoft Access 2007 Advanced - Course outline

Duration	Two Days
Objectives	Delegates will create more advanced forms containing subforms, combo boxes, option groups and check boxes. The course covers importing and exporting data and linking to external databases. Delegates will also learn how to create Macros to automate their databases. The course includes further reporting techniques and database security.
Who should attend	People who intend to design databases at an advanced level or improve existing Access databases. Also those who wish to convert databases created in other applications. Sharing and security is also covered.
Experience needed	Delegates should have attended an introductory Access course, or gained the relevant experience through working with Access.

Content	Review of Database Design Types of Relationships Indexes Referential Integrity Queries Expressions and Operators Join Properties Action Queries Find Unmatched Query Wizard Find Duplicates Query Wizard Unique Values Top Values Advanced Forms Creating Multi-table forms The Property Sheet Form Events The Controls Group Objects Using Calculated Controls The expression builder Query by form Creating a Main Menu Form Using Hyperlinks Advanced Reports Inserting Page Breaks Creating Columns Inserting Charts Importing and Exporting Importing Text Files Importing Excel Files Exporting to Excel Importing Access Objects Linking To Access Tables Macros Creating Access Macros Macros Actions Attaching Macros to Events Running a Macro from a Form Macro Groups Using Conditions in Macros Synchronizing Forms using a Macro Security Trusted Locations The Trust Centre Setting a Database Password

Pagoda Training Ltd, 2nd Floor, Thornborough Hall, Leyburn, North Yorkshire, DL8 5AB
Tel 01969 625596 Email training@pagoda.co.uk
Incorporated in England Registration No. 3132465