Microsoft Access Level 3 Advanced training course
Call us on 01483 572855 or email guildford@pitman-training.net today
      GUILDFORD

Course Description: Access  Level 3 - Advanced

Your training in and use of Microsoft Office Access has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft Office Access . You're now ready to extend your knowledge into some of the more specialised and advanced capabilities.

Prerequisites: Access Level 1 - Introduction and Access Level 2 - Intermediate, or equivalent knowledge.

Benefits: You will create complex Access databases using forms, reports, and macros.

Target student: This course is designed for the student who wishes to learn intermediate and advanced operations of the Microsoft Office Access database program. The Access Level 3 - Advanced course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.

Training can be delivered at our training centre in Guildford, Surrey or at your office.

Length: One Day

For course timetable and prices click here

Course Contents:

Access  Level 3 - Advanced

 

Lesson 1: Structuring Existing Data

Topic 1A: Import Data

Topic 1B: Analyze Tables

Topic 1C: Create a Junction Table

Topic 1D: Improve Table Structure

 

Lesson 2: Writing Advanced Queries

Topic 2A: Create Unmatched and Duplicates Queries

Topic 2B: Group and Summarize Records Using the Criteria Field

Topic 2C: Summarize Data with a Crosstab Query

Topic 2D: Create a PivotTable and a PivotChart

Topic 2E: Display a Graphical Summary on a Form

 

Lesson 3: Simplifying Tasks with Macros

Topic 3A: Create a Macro

Topic 3B: Attach a Macro to a Command Button

Topic 3C: Restrict Records Using a Where Condition

 

Lesson 4: Adding Interaction and Automation with Macros

Topic 4A: Require Data Entry with a Macro

Topic 4B: Display a Message Box with a Macro

Topic 4C: Automate Data Entry

 

Lesson 5: Making Forms More Effective

Topic 5A: Change the Display of Data Conditionally

Topic 5B: Display a Calendar on a Form

Topic 5C: Organize Information with Tab Pages

 

Lesson 6: Making Reports More Effective

Topic 6A: Cancel Printing of a Blank Report

Topic 6B: Include a Chart in a Report

Topic 6C: Arrange Data in Columns

Topic 6D: Create a Report Snapshot

 

Lesson 7: Maintaining an Access Database

Topic 7A: Link Tables to External Data Sources

Topic 7B: Back Up a Database

Topic 7C: Compact and Repair a Database

Topic 7D: Protect a Database with a Password

Topic 7E: Determine Object Dependency

Topic 7F: Document a Database

Topic 7G: Analyze the Performance of a Database

Topic 8D: Merge Access Data with a Word Document

Microsoft Office training in Surrey, Hampshire, Sussex, Berkshire and London
 

Pitman Training Guildford, Portsmouth House, 1 Portsmouth Road, Guildford, Surrey GU2 4BL